How to Clear Pivot Table Filters
In this example, we have only NC and SC showing in our Pivot Table, but we need all values to be showing.
In order to see all of our states in the Pivot Table, we need to clear our Pivot filters.

To do so click the arrow by row labels and Clear the filter from whatever the row label header is. In this case, the State.
The quickest and more advanced way of quickly clearing your Pivot Table filter is via hotkeys: ALT>A>C.

summary
- It can be easy to forget data is filtered
- Clearing filters is fast and easy with our "auto clear" acronym
- One can clear filters or change filtered items in the column directly