add filter to pivot table in excel 2007
 

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

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?

add filter to pivot table in excel 2007
 

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?

add filter to pivot table in excel 2007
 

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?

add filter to pivot table in excel 2007
 

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?

add filter to pivot table in excel 2007
 

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?

add filter to pivot table in excel 2007
 

I don't see your address anywhere on the screen, just your name. Please send
the address to . I would appreciate your
assistance.

Thanks

Scott

"Roger Govier" wrote:

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?

add filter to pivot table in excel 2007
 

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.

--
Regards

Roger Govier


"Scott" wrote in message
...
I don't see your address anywhere on the screen, just your name. Please
send
the address to . I would appreciate
your
assistance.

Thanks

Scott

"Roger Govier" wrote:

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?