Create new category to represent multiple categories within the same field

[fjuren]

Hello,

I have a field called StatusName with the following categories: A, B, C, D, E.

I would like to do the following:

• Combine the categories 'A', 'B' and 'C' into a new category. For example, if the new category is called 'Total', I would like 'Total' to equal 'A' + 'B' + 'C'

Thanks in advance for the help!

[CELAMBARASAN]

Create a New Field with New category

StatusNameWithTotal:

Load Distinct StatusName, StatusName as StatusNameWithTotal

Resident <StatusNameTable>;

Concatenate(StatusNameWithTotal)

Load Distinct StatusName, 'Total' as StatusNameWithTotal

Resident <StatusNameTable>;

Now use the StatusNameWithTotal field in your dimension/calculations