Pivot Table Filtering

[LizCane]

Hi,

I have 2 filters in my Report Filter field. Is there a way to minimise the selection of Filter #2 when I choose a selection in Filter #1? At the moment, Filter #2 returns everything that is available and I only want it to return what’s available after selecting something in Filter #1.

Does anyone know if this is possible?

Any help would be gratefully appreciated.

P.S. I have no working knowledge of VBA

 

[The Fox In The Box]

Have you considered Slicers?!

 

[LizCane]

Have you considered Slicers?!

Thanks for this, but I was wondering if there was a way to do it within the Pivot Table?