I have a table without geometry that contains three columns: Item, Sub-item, and amount. I would like to create a new table with the sum of the amount of the sub-items that have the same Item attribute. (These categories are invented)
Normally I would use the GDAL Dissolve with the Item as the dissolve field. But in QGIS it doesn't accept layers without geometry as an input.
I have created dummy point geometry to get around this but feel like I must be missing something. Could I just be using an sql query? Also I would like it if any of the sub-items are null it would give me a null sum. Currently it only gives a null if all of the items are null.