![]() |
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 |
Pivot Table Formula Problem
|
All times are GMT +1. The time now is 10:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com