ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Formula Problem (https://www.excelbanter.com/excel-discussion-misc-queries/251010-pivot-table-formula-problem.html)

HT

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


Herbert Seidenberg

Pivot Table Formula Problem
 
Excel 2007, PivotTable
% of subtotal
http://www.mediafire.com/file/x0nzzy0kowy/12_14_09.xlsx


All times are GMT +1. The time now is 10:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com