Combine reported dimension rows in straight table

[nickedw0]

I have a straight table showing the number of errors

Critical | 4

High    | 6

Med     | 3

Low      | 2

Pass    | 20

Dimension is errorType, Expression is Count of error.

How do I combine rows to end up with:

High & Crit | 10

Med | 3

Other | 22

[sunny_talwar · Accepted solution]

May be like this

Calculated Dimension

If(Match(errorType, 'Critical', 'High'), 'High & Crit',

     If(Match(errorType, 'Med'), 'Med', 'Other'))

Expression

Count(error)