...
As you can see above, the pivot table is able to can show data filtered by our preference. You can apply a filter to a row, column, or values field. Each time we change our filter preference, the pivot chart is also updated, to reflect the change in our data.