Pivot Table Filter - Only show available fields

[DaddyH]

Hi All,

I wonder if somebody could be so kind to help me out please.

I have created a Pivot Table and added a number of filters to the table.

Is it possible to only show fields that are available against the first set filter.

Example:

- The first filter gives me an option of 1 to 10.
- I choose option 2.

In the Second Filter i get an option of A to Z.
But the as i have chosen option 2 above the only letters that are used are B,C & D.

Unforutantely the second filter shows all the Letters (A-Z). But i only want the available fields of B,C & D to show.

Is there a way of doing this?

Thank you

 

[DaddyH]

Hi All,

Can anyone help here please? or is this not possible?

Thanks

 

[RoryA]

Unfortunately the dropdowns in a pivot table don't work the same way as autofilter ones. You could use Slicers instead, which will move any unavailable items to the end of the list, and disable them.

 

[DaddyH]

Hi, thanks for the response and that sounds like a nice work around.

Cheers

Nick