Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
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
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
i created a calcualted dim based on your suggestions and i was ale to get exactly what i needed.
Thank you for your help.