With Office 2010, Excel has an added feature that takes Pivot Tables a step further: the Slicer – which allows you to slice and dice an existing Pivot table through new dimensions.
For example, here’s a simple Pivot table summarizing sales by customer by year:
But what if we wanted to further analyze these sales numbers, slicing them by different salespeople and product categories, for example? Enter the Slicer:
In this example we’re still looking at sales by customer by year, but we’ve sliced it for sales by 2 salespeople only, and for just the Seafood and Bowls product categories.
Anyone else used this (or even knew it existed)?