Return String based on Highest Count

[#1]

Hello,

In a text field I want to display the name of a value with the highest count.

So far I have this

=MaxString(aggr(Count({1<[Billable_Status] = {Billable}>}Practice)Practice))

This returns back the highest count of billable employees in a practice, but I want it to display the name of the practice not the count.

Thanks.

[tresB · Accepted solution]

Try like:

=FirstSortedValue( YourNamefield, - aggr(Count({1<[Billable_Status] = {'Billable'}>}Practice), Practice) )

[#3]

This works!

Thanks a lot for the help