Dimensions

[#1]

Hi Guys;

I have created a bar graph. When a user selects [Load group] 'A' l want the dimension on the bar graph to be [Carrier Name]. When a user selects [Load group] 'B', l want the dimension on the bar graph to be [Carrier Alt Carrier Designator].

How do l do this?

Regards;

Moses

[sunny_talwar]

There is two ways to do this:

1) Calculated dimension:

If([Load group] = 'A', [Carrier Name],

If([Load group] = 'B', [Carrier Alt Carrier Designator]))

or

2) Use two dimensions and conditional hide/show them

[Carrier Name] -> Hide show condition [Load group] = 'A'

[Carrier Alt Carrier Designator] - > Hide show condition [Load group] = 'B'