I'm using QGIS for some analysis. I have data in this format:Name is a text variable and categories are all integers
And I want to generate a sum for all categories for each name, ie a table like this:
Is this possible is QGIS. I've been using the Group Stats plugin and I'm able to get the sums one category at a time but my data actually has many more categories than I've displayed here so it would take me a very long time to do.
I've been putting Name into the row box in Group Stats and in the value box I put Sum and CategoryA.
I'm quite new to QGIS so any help you could give would be great!
أكثر...

And I want to generate a sum for all categories for each name, ie a table like this:

Is this possible is QGIS. I've been using the Group Stats plugin and I'm able to get the sums one category at a time but my data actually has many more categories than I've displayed here so it would take me a very long time to do.
I've been putting Name into the row box in Group Stats and in the value box I put Sum and CategoryA.
I'm quite new to QGIS so any help you could give would be great!
أكثر...