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.

--
Regards

Roger Govier


"Scott" wrote in message
...
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

"Roger Govier" wrote:

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?