From the course: Google Sheets: Pivot Tables

Unlock the full course today

Join today to access over 25,200 courses taught by industry experts.

Filter a pivot table by rule

Filter a pivot table by rule

From the course: Google Sheets: Pivot Tables

Start my 1-month free trial Buy for my team

Filter a pivot table by rule

“

- [Narrator] Pivot tables help you summarize large amounts of data, but you can always limit the data that appears by creating a filter. If the data you want to display in your pivot table fits a rule, such as all values greater than 1000, you can define that rule and use it to filter your pivot table. In this movie, I'll demonstrate how to do that. My sample file is 02_02_Rule, and you can find it in the Chapter Two folder of your exercise files collection. This workbook contains two worksheets, the first is Sheet one, which contains my data, and the second is Pivot Table two, which has the pivot table that you see now. If you want to filter your pivot table, then click any cell within the body of the pivot table, and then on the tool bar, if necessary click more. If the pivot table editor is hidden, such as by clicking its close button, then you will see the filter button pop up by itself. On the other hand, if I bring the pivot table editor task pane back, then I need to click the…

Contents