How to insert Slicers from PowerPivot hierarchies the right way
User Rating: / 0
PoorBest 
Written by Erik Svensen   
Wednesday, 27 February 2013 19:30

I think the Excel 2010 introduction of Slicers to filter your pivot tables makes it so much easier to filter the information in the pivot table and the ability to let slicers "Show items with no data last" was very helpful. But when working on demo based on Adventure Works I was very surprised that it didn't work when I added the Geography hierarchy as slicers to my Pivot table.

Read more...

 

Tags: excel, slicer
 

Pyramid Analytics