How to limit values of list box

[#1]

Hi All,

I have 3 values for REGION column. Let values are A,B,C and corresponding sub-regions for 3 regions.in dashboard

I need to display only region A in list box of REGION and corresponding sub-regions of A in Sub-region filter list box.

how I should write a calculated dimension to display only A in REGION filter(listbox) and corresponding Sub-region of A in Sub-region

filter(list box).

Thanks in advance......

[#2]

I know this is why you use set analysis with Region = 'A' but you display the subregion just try out the formular.

only({<Region = {'A'}>}SubRegion)

reagards

[#3]

its not working....

even I select ' A',I am not getting any values

[#4]

I have written this formula

=aggr(only( {<SUB_REGION_NM=P({<Region={'A'}>} SUB_REGION_NM)>}SUB_REGION_NM),SUB_REGION_NM)

but I am getting all subregions of all regions.

[#5]

how are subregion and region linked and are they linked in you datamodel?

[#6]

region and sub-region are from same table

[#7]

Enable the below option in List box properties.

This might help u .

Thanks!

D J