filter in a filter

Is there any way to run more than one filter from the drop down menu? I have
a large pivot table and am trying to create a filter, or set of filters to
help narrow down to more specific information for easy maneuvering in
presentations and help in general. As of now, when I create multiple
filters, it will only use one of the filters. Example, it will only narow my
entire pivot table by one selected field. I would love if there was a way
that I am missing that would allow me to do something like this. Have the
filters land use, (retail, office) and company, (A,B). I use the land filter
and select office. When i click on the company filter I would like to be
left with just the list of companies who own office properties. I hope that
made sense and thank you in advance

If you double-click elements in a Pivot Table a new sheet will be created
that will allow yo to drill down deeper into that set of data.

You can take a look at this too.
http://www.rondebruin.nl/easyfilter.htm

Regards,
Ryan---

--
RyGuy


"Erik" wrote:


Is there any way to run more than one filter from the drop down menu? I have
a large pivot table and am trying to create a filter, or set of filters to
help narrow down to more specific information for easy maneuvering in
presentations and help in general. As of now, when I create multiple
filters, it will only use one of the filters. Example, it will only narow my
entire pivot table by one selected field. I would love if there was a way
that I am missing that would allow me to do something like this. Have the
filters land use, (retail, office) and company, (A,B). I use the land filter
and select office. When i click on the company filter I would like to be
left with just the list of companies who own office properties. I hope that
made sense and thank you in advance