how to create a new dimension based on the higher rating in two other dimensions

[lbrosten]

I have two dimensions "Perceived Risk" and "Scored Risk". Each show a rank of either High, Medium, and Low.

I need to create a new dimension, Risk, which selects the highest of the two risks.

If Perceived risk is _ and Scored Risk is _ then Risk is_
			New Dimension
Group Name	Perceived Risk	Scored Risk	Risk
Clinic 1	High	Low	High
Clinic 2	High	Med	High
Clinic 3	High	High	High
Clinic 4	Med	Low	Med
Clinic 5	Med	Med	Med
Clinic 6	Med	High	High
Clinic 7	Low	Low	Low
Clinic 8	Low	Med	Med
Clinic 9	Low	High	High

[chrismarlow]

Hi,

Maybe similar to below;

Cheers,

Chris.

[lbrosten]

Chris this didn't work. Here is what I see.

[chrismarlow]

Hi,

Maybe another closing bracket on the end?

Cheers,

Chris.

[lbrosten · Accepted solution]

Ended up creating a new field in the scrip called Risk Level. Then created new master item. Thanks for your help.