Got this question yesterday from the DJ Monkey…
Let’s say you have three slicers: Percentile, Quarter, and Category:
For Bikes, You Always Want to See the 70th Pctile in Q2
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).
When you look at Accessories, you always want to see Q1 instead, and set the Percentile threshold to 60. And for Clothing, it’s a different set as well:
But for Accessories, You Always Want to See the 60th Pctile in Q1
And for Clothing, It’s 80 and Q4 That You Always Want to See
Is that too repetitive for you? Three clicks with a brief pause in between each makes you feel like a monkey? There’s no satisfying you, is there? Sheesh
But hey, there’s a way to essentially set multiple slicers in one click, without VBA, as long as you know ahead of time what the desired combinations are.
Read the rest of this entry »