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.