PDA

View Full Version : [SOLVED] Sort / Filter Slicer Entries



Paul_Hossler
03-14-2013, 09:42 PM
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
03-20-2013, 05:59 AM
1. No - you have only A-Z, Z-A and custom lists available.
2. No, I'm afraid not.

Paul_Hossler
03-20-2013, 10:34 AM
1. Darn
2. Darn

:banghead:

That's what I was afraid of.

Paul

Aflatoon
03-20-2013, 11:06 AM
Would be nice functionality though - I'll suggest it for the next version of Office.