Subtotals in a Pivot table

[#1]

Hi,

I am unable to figure out a subtotal formula for the below structured pivot table

Dim 1          Dim 2              Metric 1                Metric  2                    expression/Metric 3

Q1               NA                    10                              20                     Metric 2/Subtotal of Metric 2   = 20/50 = 40%      

Q1               1-100               10                              30                       30/50 = 60%

Subtotal--------------------------  10+10                     20+30

Q2               1-100                 20                              20    

I am unable to calculate the expression 3/metric 3 in the pivot table.........please let me know

Please find the attached excel to see what problem I am facing

Thanks,

Harsha            

[nagaiank · Accepted solution]

A solution is attached.

[paulomulato]

Good morning, could put the solution in the message body , I am using the free edition, thanks.