Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this
Dimension
Region
Expression
Max(sales)
or
Max(Aggr(Sum(sales), Region, country))
May be like this
Dimension
Region
Expression
Max(sales)
or
Max(Aggr(Sum(sales), Region, country))
Try with Max(Sales)
OR Else Use Expression like
Aggr(Sum(Sales),Region)
One more way is as below:
Dimension:
Region
Expression:
FirstSortedValue(sales, -sales)
Thank u so much sunny it worked
count of values using group by
Hi Sunny can you please help me out in the above issue