Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Rizzo
Contributor II
Contributor II

Sum MAX values in set analysis

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 ?

Labels (1)
1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

Try,

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

View solution in original post

1 Reply
tamilarasu
Champion
Champion

Try,

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