How would you add a date filter to a PivotTable with these fields: Date, Category, Item, Unit Price, Number Sold, and Extended Price?
A)remove Date from any PivotTable area
B)drag Date to the ROWS area and group it.
C)drag the Date field to the FILTERS area.
D)You must use a slicer with dates.

Question

Quizplus · Accepted Answer

To add a date filter to a PivotTable with these fields, you would simply drag the Date field to the FILTERS area. This will create a filter for the pivot table based on date.

How Would You Add a Date Filter to a PivotTable