2003 Pivot Table Filter (items dropped in the Page Fields)

S

SeanF74

I have some data that I want to filter by months in a pivot table. I dropped
the data, and it is working to my needs except that I can't pick month ranges
in the filter at the top (the data dropped in the "Page Fields" area of the
pivot). I want to be able to look at both month ranges that differ in
length, what happens in even months. Basically, what I'm asking is: Is
there a way to allow multiple selection of the filter fields on a pivot table?
 
R

Roger Govier

Hi Sean

In Excel 2003 you can only do it by "cheating".
Place your Months in a Row filed area>Select the months you want>drag the
Months back to the Page area where it will show Multiple Selection as the
heading.

--
Regards
Roger Govier

SeanF74 said:
I have some data that I want to filter by months in a pivot table. I
dropped
the data, and it is working to my needs except that I can't pick month
ranges
in the filter at the top (the data dropped in the "Page Fields" area of
the
pivot). I want to be able to look at both month ranges that differ in
length, what happens in even months. Basically, what I'm asking is: Is
there a way to allow multiple selection of the filter fields on a pivot
table?

__________ Information from ESET Smart Security, version of virus
signature database 4510 (20091015) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4510 (20091015) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top