Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
Could someone please help me. As i am trying to get the firstsorted value for each dimensions and use the firstsorted value to count no of IDs.
For example:
Country | Top City | Customers at Top City | Total Customers |
---|---|---|---|
Australia | Sydney | 1200 | 2000 |
America | New York | 1400 | 3000 |
I got Top City using First sorted value =
For example: FirstSortedValue(city_name, (-(Aggr(count(ID), Country, city_name))))
but i want to calculate the Customers at that City by using above expression, as i cant use If condition as we have many countries.
Thanks in advance.
Karthik
Try this:
Max(Aggr(Count(ID), Country, city_name)