Select Page

Lesson 9 picks up where Lesson 8 left off. Lesson 8 showed how label filters can filter Pivot Table data based on the row or column labels in the table. You can also filter based on the values in the data section of the Pivot Table, and these value filters offer a variety of ways to select data. You can select all of the data than equals a given amount (x) , does not equal x, is greater than x, is greater than or equal to x, is less than x, is less than or equal to x, or between x and y. Combining label filters and value filters should make your Pivot Tables even more powerful.