Forum Discussion
Solved
Grouping numeric columns to categories
Hi everyone, I am trying to group several columns (which represent subcategories) to main categories. My data looks like this: Commitment Responsiveness Appearrance Pragmatism Customiz...
radu92,
You would need to add new column to calculate average of mulitiple columns.
Regards,
Lydia Zhang
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
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.