Subtotal filed in pivot table in Excel?
 

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?

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