add filter to pivot table in excel 2007

R

Roger Govier

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.
 
S

Scott

Roger,

I'm missing something basic. When I add the field to the Report Filter box,
the field does not show on the Pivot Table and I therefore cannot use this
field to filter. How do I filter on the field when it does not show on the
table? If I move try to add the field again to teh row lables box, it takes
the field from the Report Filter box and moves it to the Row Labels box.

Thanks
 
R

Roger Govier

Hi Scott

Are you sure that you have the Sheet with the PT on it scrolled up to
show Row 1?

By default, the first filed added to the Report Filter would be placed
on row 1. The only way I can simulate your experience, is if I have the
table scrolled slightly, so it is only showing from Row 3 onward.
 
S

Scott

You were right about not having rows 1 and 2 visible. Now however, no matter
what I do, I cannot get the filter to work on this field. I followed your
steps and that of the help tutorial, but the ability to filter on this field
is not allowed. Suggestions?
 
R

Roger Govier

Hi Scott

If you want to mail me a copy of the workbook direct, I will take a look
to see if I can figure out what is going on.
To mail direct remove NOSPAM from my address
 
R

Roger Govier

Hi Scott

File received. Very simple problem.
Your column B on the Pivot tab is hidden, as a result you cannot see the
see the dropdown for the Report Filter.
Unhide the column and all works OK.
 
Top