Using Subtotal field of a pivot table in a calculation

G

Guest

Hi

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

Thanks
Ailish
 
D

Debra Dalgleish

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.
 
G

Guest

Hi Debra

Thanks a million, I have the calculation in the main database and it is
working fine. I just wanted to check I wasn't missing something in the pivot
table.

Thanks again.

Ailish
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Formula Problem 1
Pivot Table percentages 1
Grouping Years in a Pivot table 2
Conditional SUBTOTAL in XL210 Table 7
Removing a subtotal from an insert item in a pivot table 2
Pivot Table Subtotals 1
Pivot Table Values as a % of a Subtotal 1
format pivot subtotals 2

Top