Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated Items in Pivot Table
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated field in Pivot Table | Excel Discussion (Misc queries) | |||
Calculated field in Pivot Table | Excel Discussion (Misc queries) | |||
Calculated field in pivot table | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) |