Using Subtotal field of a pivot table in a calculation

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
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
format pivot subtotals 2
can i add subtotals to subtotals in a pivot table? 1
Average of Subtotals in Pivot Table 0
Pivot table subtotals 2
Pivot Table Subtotals - Calculated field subtotal incorrect 1
Grouping Years in a Pivot table 2
Pivot Table Subtotals 1

Back
Top