View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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?