I am having an issue with one of my PivotTables' filters. I have the filter set to top ten and it works fine but when I clear one of my filters on the slicer, the top ten filter on the table goes away and shows be the entire PivotTable worth of data instead of the top ten. I need to get it to where my PivotTables stay in the top ten no matter which slicer I click on.
Any Suggestions?
Hi ConorL,
Changing the slicer resets the criteria based on the available slicers in the slicer box... if you could upload a sample workbook, I'll take a closer look to find a way to achieve the desired results
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks