Hi All,

I have a pivot chart with 3-4 filters. If i select a value in Filter 1, Filter 2 should show only the possible values of Filter 1 and so on for Filter 3 and 4.

Filter 1 Filter 2
A 1
A 2
A 3
B 5
B 6
B 7

If i select "A" in Filter 1, Filter 2 should show only "1,2,3". But currently it is showing all the values in filter 2

Regards
Sujay Babu