Hello,
I wanted to have one of my slicers only show 2 of the options.
Im not sure if this is possible by regular settings so is there a code to put when the filter is cleared to auto filter those 2 options?
slicer has "Interco", "Direct" and "Indirect" and I only want the "Direct" and "Indirect" to show in my charts, never Interco.
Thanks.
Purge the "Interco" from the actual data, and then the slicers will not show it.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Sorry im not sure what you mean.
Delete the RAW data that you don't want in the slicer.
Then it would show up as "blank" in the slicer
Not if you removed it from the Data range.
Process the data, not he slicer is what I am telling you I would do.
Got itt!!!! Finally!
Thanks for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks