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 o...
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
amitchandak
Super User
Super UserAnonymous , 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