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

--
Andy.


"Esche" wrote in message
...
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?