Just want to add to this…if you need a workaround for now…what I would do is first make sure you have enabled the RowID column in your sheet.
- Then create a template with the unique key values you would normally select for a query.
- Then create a multiple relation that links that template back to itself.
- Then create a Single Value column to get the first RowID out of that relation.
- Then create an IF/Then column that returns ‘true’ if the row’s RowID matches the single value RowID.
- Finally create any Rollup columns you need to sum data out of the relation.
This will give you data that can be filtered using the ‘true’ column and that will have all of your summed data for each unique key.