Pivot Table Calculated field grand totals

J

Jon

I seem to have an issue with grand totals for some pivot
table calculated fields. Simple calculated fields like
value/constant total up fine, but more complex
calculations involving a series of if statements do not
total up, or partially total up.

Any ideas?
 

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

How to ignore a column of numbers in Grand Total for rows 1
Custom pivot formula 2
help calculating tax and total in pivot chart 2
grand totals in pivot table rows 5
Pivot Table - copy specified Grand Totals 1
Pivot Table Row Totals 3
Difference between 2 calculated fields showed as % of grand total 0
Add AVERAGE column to Pivot Table 0

Top