-
Sort / Filter Slicer Entries
Just dipping a toe into the PowerPivot waters and experimenting with slicers using a regular PT
Q1 -- Is it possible to have the slicer entries sorted other than A-Z?
Example: I have a PT with states sorted High to Low based on sales $. The Slicer shows the states A-Z, and I'l like to have the slicer sorted high to low by $
Q2 -- Is it possilble to have the PT Top 10 filter reflected in the slicer choices?
Example -- Instead of the slicer showing 50, just show the top 10?
Thanks
Paul
-
1. No - you have only A-Z, Z-A and custom lists available.
2. No, I'm afraid not.
-
1. Darn
2. Darn
That's what I was afraid of.
Paul
-
Would be nice functionality though - I'll suggest it for the next version of Office.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules