User selectability of dimensions

[#1]

Hi all,

I want to have the following requirement in my application.

I wish to have 3 list boxes,

First list box will have all the fields , second should display only those fields that are selected in the first list box and the third should show only the values of the selections made in the second list box.

I have attached sample docs for your reference.

Kindly help me out here.

Thanks in advance,

Vidhya

[MK_QSL]

Expression for 2nd List box

=Pick(Match(GetFieldSelections(MyFields),'Country','City','Sales','Year','HalfYear','Qtr','Month','Day'),

Country,City,Sales,Year,HalfYear,Qtr,Month,Day)

Expression for 3rd list box

=GetCurrentSelections()

[#3]

Thanks for your response Manish.

If I give the second expression suggested by you, I get only the values of the fields, which is not my requirement.

I have attached sample appln with more details. Kindly find the same.

Thanks,

Vidhya