Thread: add filter to pivot table in excel 2007
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 add filter to pivot table in excel 2007
Hi Scott

Drag the relevant filed to the Report Filter area of the Pivot Table
Field List.
The use the dropdown on that field to select the Item(s) required.

--
Regards

Roger Govier


"Scott" wrote in message
...
I want to add a filter to the 2Excel 2007 pivot table. How do I do
that?


Reply With QuoteReply With Quote