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 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!


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question