How to insert Slicers from PowerPivot hierarchies the right way
User Rating: / 0
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.



Tags: excel, slicer

Pyramid Analytics