Pivot Table Formula Problem
I have a pivot table that has two row fields with a subtotal, and a data field.
For example, the first row field is Customer, the second is Product, and the
data is a count of that customers purchases of that product.
The Customer field has a Sum subtotal.
What I want is to divide each product count by that customers subtotal.
I can not figure out how to refer to a subtotal in a pivot table formula, or
how to do this if you cannot refer to the subtotal.
thank you for any help and suggestions!
Heather
|