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? |
Calculated Items in Pivot Table
You can manually hide the rows, but there's no built in way to supress them.
Craig wrote: 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? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 01:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com