If you add the Month field to the Filters area of a PivotTable, Excel filters the PivotTable to show data only for January.

Question

Quizplus · Accepted Answer

When you add the Month field to the Filters area of a PivotTable, Excel provides a drop-down list of all the months in the data set. You can select any month from the list to filter the PivotTable accordingly. By default, all months are selected, and the PivotTable shows data for all months.

If You Add the Month Field to the Filters Area