LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
HT HT is offline
external usenet poster
 
Posts: 2
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table in Excel 2007 : Problem with % in Table spudsnruf Excel Discussion (Misc queries) 2 January 9th 08 09:53 PM
Pivot table problem Tendresse Excel Discussion (Misc queries) 1 August 17th 07 03:02 AM
Pivot table problem neil40 Excel Discussion (Misc queries) 0 May 21st 06 11:41 PM
Pivot Table Problem Siv Excel Discussion (Misc queries) 0 December 13th 05 07:59 AM
Pivot table problem KikiMarie Excel Discussion (Misc queries) 2 November 4th 05 10:32 PM


All times are GMT +1. The time now is 02:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"