2 Replies Latest reply: Aug 5, 2015 4:46 PM by Paulo Mulato

# Subtotals in a Pivot table

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

• ###### Re: Subtotals in a Pivot table

A solution is attached.

• ###### Re: Subtotals in a Pivot table

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