Excel Video 287 showcases a third way to filter your Pivot Table data, Value Filters. Where Label Filters focused on what was in the row or column label, Value Filters look at the data in the Values area of the Pivot Table. It’s easy to filter for values that are equal to, greater than, less than, or between whatever numbers you’re looking for.
Watch in Excel Video 287 how I hover over the filter symbol next to Row Labels. Excel will give me a quick summary of the filter I have applied to the data without having to click and see what the filter settings are. It’s a handy shortcut to help you remember what filters you’ve applied.
Stay tuned next time. I’m planning on discussing a special kind of Value Filter called Top 10. I look forward to seeing you then.