Show only the possible values in the pivot chart filter

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

SampleData.xls

Hi,

If the attached excel chart, if i select "Alberta" in the region field, then it should only "Pencil, Binder, Pen, Desk" in the Item filter. Because those are the only possible values of "Alberta" region.

Instead it is showing all the values.

Regards,
Sujay