Hi All,
Just wondering if its possible to have a number of slicers attached to a pivot table but have certain slicer buttons perform a custom filter each time its selected.
Hi All,
Just wondering if its possible to have a number of slicers attached to a pivot table but have certain slicer buttons perform a custom filter each time its selected.
Without a sample workbook, I can only offer general advice. You probably need helper columns in the source data that evaluate to true or false for whatever custom filter you want.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks