Lets take a look.
This pivot table is displaying just one field: Total Sales.
After we add Product as a row label, notice that a drop-down arrow appears in the header area.
When we open this menu, we see a variety of filter options.
The simplest way to filter is to simply include or exclude items by using the checklist that appears below.
This is called “Manual Filtering,” and we can select any combination of items that makes sense.
To quickly reset the filter, poke the arrow and choose Clear Filter from the menu.
you’ve got the option to also use the search box to filter for partial matches.
The current filter can also be extended.
For example, we can jot down white in the searchbox, then use add current selection to filter.
This modifies the filter to also include products that contain the word white.
Lets flush the filter.
There are many options for filtering labels under the Label Filters menu item.
For example, we can filter on products that begin with chocolate.
Or products that end with chocolate.
Filtering on column label fields works the same way.
Just like row labels, we can filter column labels to show any combination of cities we need.
