Calculated Items in Pivot Table

C

Craig

It seems that Excel calculates all possible permutations or a calcuation.
For example:

Region Person Budget Actual Variance (calculated)
North John 10 5 -5
North Peter 10 6 -4
East Mary 15 16 1
East Sue 15 14 -1

In the Excel pivot table, there are entries for Mary & Sue in the North
(even though there is no such data). The calculations are blank, but the
worksheet quickly becomes confusing. Is there a way to filter out these
"nonsense" permutations?
 
D

Debra Dalgleish

You can manually hide the rows, but there's no built in way to supress them.
 

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

Problem with Calculated item in Pivot Table 0
Problem with Calculated item in Pivot Table 1
Slicers and Calculated Items in Pivot Table 2
Pivot Tables (% to total within groups) 0
Pivot chart problem 0
Copying data from one workbook to another dependent on user select 1
Countifs or a pivot 1
Calculated Item in Pivot table 1

Top