| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom field in Pivot Table? | Excel Discussion (Misc queries) | |||
| How do I filter "Blank" cells in Pivot Table | Excel Discussion (Misc queries) | |||
| Filter based on Pivot table | Excel Worksheet Functions | |||
| Pivot table page filter not accepting multiple values. Workaround? | Excel Worksheet Functions | |||
| Change Data In Pivot Table | New Users to Excel | |||
Linear Mode
