Pivot table filter by weekday

To create a pivot table with a filter for day of week (i.e.

filter on Mondays, Tuesdays, Wednesdays, etc.)

In the example shown, the pivot table is configured to show data for Mondays only.

The filter is set to include Mondays only.

Steps

Notes