H
HT
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 customer’s purchases of that product.
The Customer field has a Sum subtotal.
What I want is to divide each product count by that customer’s 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
For example, the first row field is Customer, the second is Product, and the
data is a count of that customer’s purchases of that product.
The Customer field has a Sum subtotal.
What I want is to divide each product count by that customer’s 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