Sheets Exercises
Start free Sheets lesson

Members lesson 24

Filter a pivot

Focus pivot reports by keeping selected statuses and regions.

What you will practice

  • Add a field to pivot filters
  • Keep one selected value
  • Keep several selected values
The first 15 lessons are free.
Join the members waitlistBack to all lessons
Lesson preview

Ticket volume

Starting table
ABCD
1RegionQueueStatusTickets
2EastBillingOpen18
3WestTechnicalClosed24
4NorthAccountsPending11
5EastTechnicalClosed29
6WestBillingOpen16
7NorthTechnicalOpen21
8EastAccountsPending9