Spotfire Client: How to categorize column values as additional columns

We have a column in a table which stores four levels such as "High", "Medium", "Low" and "Very Low". 

In a cross table we can show these Levels and a metric such as "Dollar" value. 

There may be a business requirement to see additional levels such as "High & Medium", "Medium & Low", "Low & Very Low" in addition to the existing levels. 

The Cross Table will show all these levels and the "Dollar" value for each level. 

First create some calculated columns as shown below and then add a new data table from the existing data table and use transformation "Unpivot".

A). Insert > Calculated Columns like the following.

1).  High =  If([level]="High",[value])
2).  Low  =  If([level]="Low",[value])
3).  Medium = If([level]="Medium",[value])
4).  Very Low = If([level]="Very Low",[value])
5).  Very Low & Low = If(([level]="Very Low") or ([level]="Low"),[value])
6).  High & Medium = If(([level]="High") or ([level]="Medium"),[value])
7).  Medium & Low = If(([level]="Low") or ([level]="Medium"),[value])


B). Next add a data table using the existing data table and use transformation : Unpivot
        Transformation name: Unpivot
        Columns to pass through: (None)
        Columns to transform:
            High
            Low
            Medium
            Very Low
            Very Low & Low
            High and Low
            High & Medium
       
See the attached categories.dxp for a finished example