Filter dates in a pivot table

G

Guest

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?
 
R

Roger Govier

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date filter in a pivot table 1
2003 Pivot Table Filter (items dropped in the Page Fields) 1
pivot table rolling 12 month filter? 1
Pivot Table Duplicate January 2
Filter by Color 1
Pivot Table - Filter - Hyperlinks? 3
Pivot table filter list - listing irrelevant subcategorys 1
Summarising info from a table with 2 variables 2

Top