and I have a pivot table with a bucket of age group (<30, 31-40, 41-50, etc), so each ID belongs to a certain age group.
I would show, for every group age, the sum of the "Value" for age group. Since there are several ID with multiple "Value", I'd like to Sum the values that belongs to the same ID (assuming ID 100 as age 20, and ID 200 as age 50, I would show that the <30 Age group has 300 €, and the 41-50 Age Group has 1300 €). I tried with the
Thank you all. Youssef, your solution doesn't work, every row has the "0" value now. Aron, actually I don't have the Euro Currency symbol, I'm sorry I wrote it only for show that it is a numeric value. Anyway, you also proposed the same functions of Aron that sadly it's not working. Antonio, I can't use the LOAD inline because I've a big set of data, loaded from a SQL table.
I solved. Since I'm using a pivot table, and the datas are already grouped, the Aggr function it's not necessary. A simple Sum(Value) works. It's curious, anyway, that the Aggr doesn't work in this case.