Lets take a look.
By default, a new pivot table will summarize all of the source data.
For example, this pivot table shows Total Sales by product.
By default, a new report filter shows all items.
When we select West, we see only sales for cities in the West region.
If we select East, we see sales for Cities in the East.
The Select Multiple Items setting, allows you to select more than one item at a time.
For example, we can show sales for the Midwest and South.
To scrub the report filter, you have two options.
Report filters maintain a memory of their last configuration.
Select all to reset the filter.
it’s possible for you to add more than one field to the report filter at the same time.
Click Clear, then select, Clear filters.
This will clear all report filters, and any other filters in the pivot table.
Note that slicers are another way to filter an entire pivot table.
Well look at Slicers in an upcoming video.
