I have a dataset that looks like this :
The budget is always the same for each (id, category) pair and I want to display it in a table, without summing duplicate values.
My output table should look like this :
I managed to create this table with the formula : sumOver(max(budget), [id, category])
I also need a KPI displaying the total value (13), but creating a KPI with this calculated field gives me the following error : Table calculation attribute reference(s) are missing in field wells
Thank you for your help !