Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'