11 Replies Latest reply: Mar 19, 2012 10:05 AM by Dayna Litherland RSS

    Sum of Row Values in Pivot Table

    Dayna Litherland

      All,

       

      I'm hoping someone can point me in the right direction, I want to do a calculation on a pivot table to work out the percentage for each item, so I need to get the value for the total of the row... i.e.

       

      Product A Total: 4000

      When expanded, you see the subtotal for each sub-product:

      P1 2000

      P2 1000

      P3 1000

       

      So my calculation would be:

      P1 4000/2000

      P2 4000/1000

      P3 4000/1000

       

      I've tried TOTAL, but I don't want the total for all of the products, just the product related to the sub-product.. Hope this makes sense!

       

      Kind Regards,

      Dayna