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