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

    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