ExcelBanter - Filter dates in a pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Filter dates in a pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/124303-filter-dates-pivot-table.html)

JDB

Filter dates in a pivot table

I have a pivot table that provides an average score by team. Is there a way
that I can filter the list by team and then by month?

Roger Govier

Filter dates in a pivot table

Hi

One way would be to drag the Team and the Month fields to the Page area,
then use the Dropdown there to make your selections.

--
Regards

Roger Govier

"JDB" wrote in message
...
I have a pivot table that provides an average score by team. Is there a
way
that I can filter the list by team and then by month?

All times are GMT +1. The time now is 01:24 PM.