Simulate List Box with Pivot table

[#1]

Hi Everyone,

I'm working in a Project where drill-down List boxes are not permitted and I'm trying to simulate one with a Pivot table, but when I select one item, the other Item values are lost. Can you help me please to resolve this issue or suggest me a better way to simulate drill-down List boxes with two dimensions .

Thanks.

Attached qvw sample.

[#2]

Fixed.

File attached

[#3]

I couldnot attached the qvw. The solution is,change the expression 1 for: MaxString({1} Cct.CostCenterLevel1 & Cct.CostCenterLevel2)