Create a Group Based on Separate Metrics

[villa1980]

A very simple one, but my mind has gone blank.
I have created a Metric Field, which contains the separate headers, BAU, Operational,Final.
What I would like to do is create a new Metric that basically says if it is BAU then "Normal", Operational then "Ops" , Final then "Make Decision".
I still want to keep the original headers, but then want this new group so can report at both levels.

Thanks

[Anonymous · Accepted solution]

Hi, @villa1980 

You want a formula like this?

Measure=IF(A1="BAU", "Normal", IF(A1="Operational", "Ops", IF(A1="Final", "Make Decision", Blank())))

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[villa1980]

Just wanted to say thank-you for the response and it worked very well. An if statement did not cross my mind, I was trying to use Switch but that was erroring.

Thank-you again.

Alex