From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Value filters

Value filters - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Value filters

“

- Now we talked about label filters, which are text based filters. Now we're going to talk about the value filters, which, as you might expect, are triggered by value based criteria. This is where you see those typical conditional statements like equals, does not equal, greater than, less than, between or top 10, and to be honest, most of these are super straightforward. If you drill into any of these options, just like with the label filters, you do have the option to toggle those different conditionals from right here within this dialog box and then all the way on the left, you can choose which value you're interested in. So in this case, I have two values columns here in my pivot sum of budget, and gross revenue, so I can apply this value title to either one of them. So for instance, sum of budget equals 12 million will obviously filter my list to only titles with a budget exactly equal to 12 million. Same idea as label filters as far as clearing them is concerned. I can clear them…

Contents