Sum MAX values in set analysis

[Rizzo]

Hi All,

There are such data:

ID CITY NUMBER
1 London 5
2 London 8
3 Berlin 3
4 Rome 6
5 Berlin 7
6 Warsaw 8
7 Rome 1
8 Warsaw 5

I need to sum only max numbers of the cities and show the result in KPI chart.
The math is like this:
London(8) + Berlin(7) + Rome(6) + Warsaw(8) = 29

How should look the expresion ?

[tamilarasu · Accepted solution]

Try,

Sum(Aggr(Max(NUMBER), CITY))