I want to add a filter to the 2Excel 2007 pivot table. How do I do that?

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?

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?

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?

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?

"Roger Govier" wrote:

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?

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

--
Regards

Roger Govier


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

"Roger Govier" wrote:

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?