Get Max Sales over all countries

[micheledenardi]

Hi experts,

without using variables, i would like to calculate a new column on my strainght table where to put the max sales value over all countries:

With this data USA has the maximum number of Sales (12), i would like to create the column in blue where i have the max sales number over all countries. 

Country	Sum(Sales)	Max Sales
Spain	2	12
Germany	6	12
Italy	9	12
USA	12	12
Mexico	7	12

[mfarsln]

Hi,

Try this;

max(total Sales)

[sunny_talwar · Accepted solution]

Try this

Max(TOTAL Aggr(
    Sum(Sales)
, Country))

[micheledenardi]

Won't work.

Your solution show only the maximum value of Sales not the max value aggregated by country

[Sergio3]

Hi!

U need use AGGR ( like GROUP BY 😞