Urgent - Grouping element from same category

[Anonymous]

Hello,

I am trying to group the same businesss area into the same category. In my exemple, i need to group Professional and VP into VMHS, because i need to the total num and den for the VMHS in order to build my report.

best regards,

Anis

[amitchandak · Accepted solution]

@Anonymous , You need to create a new column

cate new = if([Category] in {"VP"}, "VMHS", [category])

then you can create a sum measure on a numeric column

You are creating a column not measure. Also category is text column will not sum