Three dimensions but only show one of the three if 1 of 3 selections is made

[#1]

I have a dimension  [Division] that contains only two items, 'Spa' and 'Bath'

In a new field, When 'Spa' is selected i want to display the dimension [Elec Comp], when 'Bath' is selected i want to display the dimension [Packaging]

when neither 'Bath' or 'Spa' is selected i want the new field to to be null()

[Division]

Spa

Bath

[Elec Comp]

[Packaging]

[#2 · Accepted solution]

Hello Joseph,

I would create a calculated dim (e.g. in a straight table) like this

=if(GetFieldSelections([Division]) = 'Spa', [Elec Comp],

    if(GetFieldSelections([Division]) = 'Bath', [Packaging])

    )

Regards, Roland

[#3]

Roland,

i created a calcualted dim based on your suggestions and i was ale to get exactly what i needed. 

Thank you for your help.