Sort / Filter Slicer Entries

[Paul_Hossler]

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

[Aflatoon]

1. No - you have only A-Z, Z-A and custom lists available.
2. No, I'm afraid not.

[Paul_Hossler]

1. Darn
2. Darn

:banghead:

That's what I was afraid of.

Paul

[Aflatoon]

Would be nice functionality though - I'll suggest it for the next version of Office.