NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping →

Google Sheets tutorials›Pivot tables›Filter a pivot table

Google Sheets · Verified tutorial

Filter a pivot table in Google Sheets

Create a pivot table on a new sheet from A1:D6. Put Region in Rows and Revenue in Values summarized by SUM. Add Category as a filter and show only Software.

Verified by PhilisJuly 15, 2026About 60 seconds

Quick answer

Create a pivot table on a new sheet from A1:D6. Put Region in Rows and Revenue in Values summarized by SUM. Add Category as a filter and show only Software.

Step-by-step

1

Select the targetCreate a pivot table on a new sheet from A1:D6.

2

Complete the next actionPut Region in Rows and Revenue in Values summarized by SUM.

3

Apply the changeAdd Category as a filter and show only Software.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

The pivot table groups Software revenue by Region and excludes Services rows.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select A1:D6 and repeat the final action. The pivot table groups Software revenue by Region and excludes Services rows.

Example spreadsheet data

This is the clean fixture used for the verified run.

Region	Owner	Category	Revenue
North	Anna	Software	120
South	Ben	Services	180
North	Cara	Services	240
West	Dev	Software	210
South	Eva	Software	160

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Create a pivot table on a new sheet from A1:D6.
Complete the next action. Put Region in Rows and Revenue in Values summarized by SUM.
Apply the change. Add Category as a filter and show only Software.
The pivot table groups Software revenue by Region and excludes Services rows.