FirstSortedValue and set analysis

[john_henry]

I am trying to display the region with the max value, but filtered by a specific type.  I have the following formula which finds the highest region based on count of IDs.

FirstSortedValue(DISTINCT Region,-Aggr(count(ID),Region))

Now I need to limit the above formula to evaluate where "Type" column is only "Robo".  I tried using set analysis, but was unsuccessful:

=FirstSortedValue(DISTINCT Region,-Aggr(count({<Type={'Robo'}>}ID),PROVINCIA))  

How do I find the Region with the highest count of IDs where Type is only 'Robo'?

[Anil_Babu_Samineni]

Your formula should work, Is that not working for you?

=FirstSortedValue(DISTINCT Region,-Aggr(count({<Type={'Robo'}>}ID),PROVINCIA))  

If it is not working, Perhaps restrict at end of dimension as well

=FirstSortedValue({<Type={'Robo'}>} DISTINCT Region,-Aggr(count({<Type={'Robo'}>}ID),PROVINCIA))  

Or

=FirstSortedValue({<Type={'Robo'}>} DISTINCT Region,-Aggr(NODISTINCT count({<Type={'Robo'}>}ID),PROVINCIA))