Google Sheets

Pivot Tables in Google Sheets

1. open a spreadsheet with a pivot table.
2. Click the pivot table.
3. At the right, next to "Filters," click Add. Then, choose an option.
4. Next to "Showing all items," click the Down arrow .
5. Choose how you want to filter:
   • Filter by condition: Write your own, or choose from the list of conditions, like if the cell is not empty, if data is less than a certain number, or if text contains a certain letter or phrase.
   • Filter by values: Uncheck the items you want to hide and click OK.