Filter report filters based upon previous report filters!!??

Hi gurus,

I have a pivot with 4 report filters and I'd like each one themselves to be filtered down with options based upon the previous filter.

So for example, top filter is region, second is city so I only want the cities relevant to that region to be shown.

Thanks in advance!

Jackie

p.s using excel 2007