Sum Numbers aggregated by max Sn, Country, City.

[Rizzo]

Hi all,
OK, I give up 😞 .How to write the expression to sum "Number" field values aggregated by the last "Sn", "Country" and "City" fields.

The result should be  9 (2+1+2+4 )

Sn	Country	City	Number
1	Spain	Madrid	1
2	Spain	Madrid	2
3	Germany	Berlin	0
4	France	Paris	3
5	Germany	Berlin	1
6	Poland	Warsaw	2
7	Poland	Warsaw	2
8	France	Paris	4

Thank you in advance

[Taoufiq_Zarra · Accepted solution]

Hi,

Maye be :

=Sum(Aggr(FirstSortedValue(Number, -Sn), Country,City))

and DON'T GIVE UP 😜

[Rizzo]

That woks! Thank you Taoufiq ZARRA 🙂