How do I set up filter for page fields in pivot table?

I have a fantastic pivot table that I built that I use to answer questions
from by customers. However, the questions are often varied and I find it
difficult to easily select and de-select data. Is there a way to filter the
page fields in a pivot table. For example, I might need to go from seeing
all the data for one plant to the data for one material at all the plants. I
have over a thousand materials, over a hundred plants. So, going from one
set to data to the other is taking some time because I have to select and
de-select so many individual items. I would really like to add a "All" and a
"None" category.

Thanks in advance for your help!

In Excel 2002 and later versions, there's a Show All checkbox on the
Items dropdown list. For earlier versions, you can use programming, as
in the sample code shown here:

http://www.contextures.com/xlPivot03.html


Mitsycat wrote:
> I have a fantastic pivot table that I built that I use to answer questions
> from by customers. However, the questions are often varied and I find it
> difficult to easily select and de-select data. Is there a way to filter the
> page fields in a pivot table. For example, I might need to go from seeing
> all the data for one plant to the data for one material at all the plants. I
> have over a thousand materials, over a hundred plants. So, going from one
> set to data to the other is taking some time because I have to select and
> de-select so many individual items. I would really like to add a "All" and a
> "None" category.
>
> Thanks in advance for your help!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks Debra! I have Excel 2000, so I will check out the programming options
supplied in the address you attached below.

"Debra Dalgleish" wrote:

> In Excel 2002 and later versions, there's a Show All checkbox on the
> Items dropdown list. For earlier versions, you can use programming, as
> in the sample code shown here:
>
> http://www.contextures.com/xlPivot03.html
>
>
> Mitsycat wrote:
> > I have a fantastic pivot table that I built that I use to answer questions
> > from by customers. However, the questions are often varied and I find it
> > difficult to easily select and de-select data. Is there a way to filter the
> > page fields in a pivot table. For example, I might need to go from seeing
> > all the data for one plant to the data for one material at all the plants. I
> > have over a thousand materials, over a hundred plants. So, going from one
> > set to data to the other is taking some time because I have to select and
> > de-select so many individual items. I would really like to add a "All" and a
> > "None" category.
> >
> > Thanks in advance for your help!
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

You're welcome! I've also added "Show All Page Field Items" and "Hide
All Page Field Items" to my Pivot table Add-in, that you can download here:

http://www.contextures.com/xlPivotAddIn.html

Mitsycat wrote:
> Thanks Debra! I have Excel 2000, so I will check out the programming options
> supplied in the address you attached below.
>
> "Debra Dalgleish" wrote:
>
>
>>In Excel 2002 and later versions, there's a Show All checkbox on the
>>Items dropdown list. For earlier versions, you can use programming, as
>>in the sample code shown here:
>>
>> http://www.contextures.com/xlPivot03.html
>>
>>
>>Mitsycat wrote:
>>
>>>I have a fantastic pivot table that I built that I use to answer questions
>>>from by customers. However, the questions are often varied and I find it
>>>difficult to easily select and de-select data. Is there a way to filter the
>>>page fields in a pivot table. For example, I might need to go from seeing
>>>all the data for one plant to the data for one material at all the plants. I
>>>have over a thousand materials, over a hundred plants. So, going from one
>>>set to data to the other is taking some time because I have to select and
>>>de-select so many individual items. I would really like to add a "All" and a
>>>"None" category.
>>>
>>>Thanks in advance for your help!
>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html