topic Re: sum values group by ID in App Development

sum values group by ID

fsilva1 — Sat, 15 Mar 2025 13:48:42 GMT

Hi guys,

I have a table with ID, Suppliers, and Values. In the front end, I need to sum the Values by ID desconsidering suppliers. I tried to use sum(Aggr(sum(Values),ID)), but it is not correct. How can I do this? In this example, I need to show 100 because ID 1100 has a value of 100 and not 200.

Re: sum values group by ID

ramchalla — Sat, 15 Mar 2025 14:10:14 GMT

Hi,

Please let me know what should be the value displayed for the ID 1200. should it be 200 or 500? I can try and let you know the fix for this.

Re: sum values group by ID

fsilva1 — Sat, 15 Mar 2025 17:31:43 GMT

First of all, thank you for your answer..

Sorry, that was my mistake. Sales are based on ID, so for each ID, we have the same sales figure. Therefore, the correct sales amount for ID 1200 is 200.

Re: sum values group by ID

ramchalla — Sat, 15 Mar 2025 17:47:22 GMT

Hi,

in that case, you can use the below formula. Please find the attached qvw.

Sum(Aggr(Max(Sales), ID))

Re: sum values group by ID

BrunPierre — Sat, 15 Mar 2025 18:08:35 GMT

Are you considering the very first recorded sales figure for each ID?

Then try;

=Sum(Aggr(FirstSortedValue(sales, Aggr(Sum(sales), ID)), ID))

Re: sum values group by ID

Lech_Miszkiewicz — Sat, 15 Mar 2025 22:41:36 GMT

Hi,

If you just want to show values then dont use measure but use values as dimensions both for ID and for Value.

cheers