Hi
In Slicer, I have some unwanted items but they are not blank or no value.
Can I remove them from my slicer list?
thx
Hi
In Slicer, I have some unwanted items but they are not blank or no value.
Can I remove them from my slicer list?
thx
If the slicer is connected to a pivot table, it may reflect pivot table values that used to exist, but are no longer there. The following piece of code removes these old items and refreshes the pivot table. Actually it does it for all pivot tables in the workbook. You can adjust the code as needed.
Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Thanks
But they are not old items.
For example the slicer has Gross revenue, Licensee Revenue, other revenue and total revenue.
Now the slicer has all 4 revenue. But I do not to include "total revenue".
Is it possible?
Well, that's about as far as I think we can take it without a sample workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks