Grouping numeric columns to categories

[radu92]

Hi everyone,

I am trying to group several columns (which represent subcategories) to main categories. My data looks like this:

Commitment	Responsiveness	Appearrance	Pragmatism	Customization	Proactivity	Innovation
2	5	2	3	5	2	1
3	3	4	3	5	1	3

Now I would like to group the first three columns into the category "Personality" and the last four to "Customer focus", in able to create numeric KPIs based on the main category (e.g. the average for Personality as a KPI visual).

Any help is appreciated! 🙂

[v-yuezhe-msft]

@radu92,

Could you please post your expected result in table? How do you want to calculate these values of different columns when you group them into categories?

Regards,
Lydia Zhang

[radu92]

I would like to have the average of the subcategories as the main category. I solved it now by just adding a new column that calculates the AVG(column1, column2, etc.), but I was wondering if this could be done without an extra column.

[v-yuezhe-msft · Accepted solution]

@radu92,

You would need to add new column to calculate average of mulitiple columns.

Regards,
Lydia Zhang

[radu92]

Thanks! That's what I did 🙂