Hi,
I have been reading the posts about issues with pivot table filters being deselected when new data comes in. Our source is from an analysis services site. If the following month the item that was deselected is applicable, then we have an error. I looked into the clear cache, clear filters, etc. My question is this. The business has multiple tabs on the spreadsheet with the same pivot table; however each tab might have a group of products selected. For example, one tab is all the color Yellow. The other tab is all the color red. The whole data set for the pivot table has yellow, red, blue, and green.
If I do do any clear filters...wouldn't it clear the filters on every tab so the business would lose the filter on the first tab of Yellow and the second tab of red?
Any thoughts?
I have been reading the posts about issues with pivot table filters being deselected when new data comes in. Our source is from an analysis services site. If the following month the item that was deselected is applicable, then we have an error. I looked into the clear cache, clear filters, etc. My question is this. The business has multiple tabs on the spreadsheet with the same pivot table; however each tab might have a group of products selected. For example, one tab is all the color Yellow. The other tab is all the color red. The whole data set for the pivot table has yellow, red, blue, and green.
If I do do any clear filters...wouldn't it clear the filters on every tab so the business would lose the filter on the first tab of Yellow and the second tab of red?
Any thoughts?