Dynamic Pivot filter

[grifter]

Hi

I have a small pivot report with 5 filters. If i use one filter then in theory then some of the other filter data does not now apply to the remaining data for instance if we have:

User        Car Make
===        =======
Jim          Ford
John        Toyota
Mike       Saab

And I filter firstly on user = Jim then I want my 'car make' filter to only show 'Ford'. But in this case the 'car make' filter will still show all makes.

G

 

[noboffinme]

Hi Grifter

If Jim only has a 'Ford' & you make a selection from the 'Page' area, filter, you should only see data for Jim.

Are your filters in the 'Page' or the 'Row' area?

Can you post an example?

 

[vbaInet]

Something like this:

http://www.excelforum.com/excel-general/687168-excel-2007-solved-pivot-table-drill-down.html