Forum Discussion
Urgent - Grouping element from same category
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
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
1 Reply
- amitchandak
Super User
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