Slicer hierarchy value sorting - selected values won't sort to top

[briguy7]

I have two slicers that are in a hierarchy. These are attached to a Pivot table whose data source is an OLAP cube. Every Partner Parent is part of a Partner Group:

Partner Parents Slicers.png

My problem is that when I click SI Alliance in Partner Group, the Partner Parent slicer does not re-sort in any way. The corresponding selected Partner Parents are scattered throughout the alphabetical list. However, in a different document, I have slicers in a similar situation, except their Pivot table’s data source is a SQL Server database. When I click on a member of the higher up group (Accenture Global Client) the lower level group (Microsoft Account Name) sorts to show only the selected values at the top of the list:

This is with all selected - Accenture Slicers All.png

This is with just one Accenture Global Client selected. Note how the selected Microsoft Account Names have moved to the top of the list - Accenture Slicers Selected.png

Do you know how I can configure my Partner Parent/Partner Group slicers to behave like these Accenture/Microsoft slicers? Is there something that I can change in Excel or in the OLAP cube to make this happen? I have already tried right-clicking the slicer and going to Slicer Settings. The settings on the Parent/Partner Group slicers mimic those of the Accenture/Microsoft slicers exactly.

Thanks for your help!

[briguy7]

Bump? Does anyone even have the slightest idea as to where I might begin to investigate this?

[ertuoc]

I ran into this same problem with Olap cube data connect to 2010 with slicers. Have you found a solution? Thanks

[Izandol]

Perhaps this: http://eriksvensen.wordpress.com/201...the-right-way/

[briguy7]

This is exactly what I was looking for. Thank you!!