pivot tables - calculated fields

[Guest]

In my pivot table, I can select a customer and see the quantity of each
product they ordered over the last 6 months. I need to see the percentage of
the total for each product. I want to add a column that will perform this
calculation. How do I do this?

 

[Guest]

Hi
Have a look here:
http://www.contextures.com/xlPivot10.html

 

[Guest]

hi Andy,

Thank you! This fixed the problem.

-Esche

 

[Guest]

Glad to help and thanks for the feedback!