Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Nov 13, 2023
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:-

I have put the formula manual for 1st 5 entries, but in total, we need to repeat then 45 times for each cell, is there some way to use a Single formula to calculate this.

 

Note : The Data in Red is not needed in our Calculation., so for example for :-

 

Pdcchstartsymbol = 0 :-

the %age of txNumber = 1 for AL2 = 29480 / 31250(Total for AL2 for Pdcchstartsymbol =0)

 

And so on.

Thanks in Advance,

excel
Formulas and Functions

5 Replies

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Nov 14, 2023

    Hi anupambit1797 

     

    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:

Resources