Forum Discussion
Solved
How to use %age formula in a Pivot
Dear Experts, Need your help! So, in the Attached spreadsheet, I want the %age of txNumber 1/2/3/4/5 for each of the Pdcchstartsymbol (0/1/2) for each AL(2/4/8) as below:- ...
No Single nor any formula, Pivot Table only:
- Duplicated your initial Pivot Table
- Removed unecessary values (searchSpaceId), Subtotals (for Pdcchstartsymbol) & Grand total for rows
- Moved txNumber to Rows area (under aggregationLevel)
- Report Layout in Tabular Form
- Removed Subtotal for aggregationLevel
- Changed Count of slot measure => Show Values As % of Parent Row Total:
