Excel 2010 and Excel 2013 Slicer Settings
User Rating: / 0
PoorBest 
Written by Thomas Ivarsson   
Wednesday, 21 November 2012 19:43

Here is an interesting new functionality in Excel 2013 regarding slicers with BISM Multidimensional. One of my colleagues asked for this functionality in Excel 2010 when he built reports with slicers for publishing in SharePoint 2010 Excel Services. The slicers should not show members without data in the slicer and this is obviously not the fact with Excel 2010 as you can see in the picture below. There is not such choice in the slicer settings(right click on the slicer)

Read more...

 

Tags: excel, tabular
 

Pyramid Analytics