View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Using Subtotal field of a pivot table in a calculation

No, you can't refer to the subtotal amounts in a calculated field or
calculated item. If you describe what you're trying to calculate,
someone may be able to help with a formula outside the pivot table, or a
way to accomplish it in the pivot table.

Ailish wrote:
I was wondering is it possible to use the subtotal that is generated in a
pivot table as part of a calculated field/item?



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