Aggregating sun based on two values

[#1]

Hi all

I have a requirement where

Region  country  sales

Apac     ind          100

Apac      chn          90

Mena     eup         80

Mena     uk            40

I want to aggregate data based on region and country and show top values based on combination

I have to show in a single bar chart where

My dimension is region and sum of sales is expression

Output is as below

Region     sales

Apac   100

Mena   80

[sunny_talwar · Accepted solution]

May be like this

Dimension

Region

Expression

Max(sales)

or

Max(Aggr(Sum(sales), Region, country))

[Anil_Babu_Samineni]

Try with Max(Sales)

OR Else Use Expression like

Aggr(Sum(Sales),Region)

[trdandamudi]

One more way is as below:

Dimension:

Region

Expression:

FirstSortedValue(sales, -sales)

[#5]

Thank u so much sunny it worked

[#6]

count of values using group by

Hi Sunny can you please help me out in the above issue