Thread: Subtotal filed in pivot table in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default Subtotal filed in pivot table in Excel?
You could use a GETPIVOTDATA formula, as described he

http://www.contextures.com/xlPivot06.html

Jason wrote:
I am trying to refer to a summed field in a pivot table but keep getting an
error. The information is summed by date just above the grand total. Does
anyone know how to make the reference?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote