Hi there,
I have read several posts about trying to filter out unwanted "calculated items" when using "calculated item" formulas within a pivot table.
The best I have come across thus far is to apply a "Does not equal between -0.00001 and 0.00001" "Value Filter" to either a row or column label.
This is perhaps better explained via the following pdf which I came across:
http://c3017412.r12.cf0.rackcdn.com/06_05_11.pdf
Seeing as I have created a workbook with a number of worksheets containing various pivot tables (different views using different row and column labels but essentially from the same source data "named range")... here's where the questions starts... is there an easier way to apply the "value filter" to each pivot table without having to go in and apply this filter to each pivot table row / column label?
(Note I am using Excel 2010)
Many thanks,
Linesy
I have read several posts about trying to filter out unwanted "calculated items" when using "calculated item" formulas within a pivot table.
The best I have come across thus far is to apply a "Does not equal between -0.00001 and 0.00001" "Value Filter" to either a row or column label.
This is perhaps better explained via the following pdf which I came across:
http://c3017412.r12.cf0.rackcdn.com/06_05_11.pdf
Seeing as I have created a workbook with a number of worksheets containing various pivot tables (different views using different row and column labels but essentially from the same source data "named range")... here's where the questions starts... is there an easier way to apply the "value filter" to each pivot table without having to go in and apply this filter to each pivot table row / column label?
(Note I am using Excel 2010)
Many thanks,
Linesy
