One Slicer to Control Them All.

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Got this question yesterday from the DJ Monkey.
Let's say you have three slicers: Percentile, Quarter, and Category:
And you find yourself selecting the same combinations over and over again. Above, you selected 70, 2, and Bikes - because Quarter 2 is essential for Bike sales, and 70 is the percentile you are most interested in for bikes. (Note that this percentile drives conditional formatting in this example - see this post for details).

Read more...

Tags: excel, slicer

 

2007-2015 VidasSoft Systems Inc.