Firstsorted value and its count in the same table

[karthikdaibala]

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

[sunny_talwar]

Try this:

Max(Aggr(Count(ID), Country, city_name)