Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Maye be :
=Sum(Aggr(FirstSortedValue(Number, -Sn), Country,City))
and DON'T GIVE UP 😜
Hi,
Maye be :
=Sum(Aggr(FirstSortedValue(Number, -Sn), Country,City))
and DON'T GIVE UP 😜
That woks! Thank you Taoufiq ZARRA 🙂