Text Box showing the name of the company with highest revenue

[danialier]

Hello,

I have the attached QV document with two text boxes: one for the company names and another one for the revenue of each company.

I want to create a third text box showing only the name of the company with highest revenue. Then, as soon as I will add more companies in the QV document I always want this third box to show the name of the company with the highest revenue.

Do you know how to do that ?

Thanks,

dani

[Gysbert_Wassenaar]

=FirstSortedValue(COMPANY, -REVENUE)

[danialier]

Great !!! Thanks Gysbert ! That works now !

[danialier]

One more question...

In case the highest revenue is the same for two companies, what I need to do to make sure than the third text box displays the name of the two companies then ?

thanks,

dani

[Gysbert_Wassenaar · Accepted solution]

=firstsortedvalue(aggr(concat(COMPANY,', '),REVENUE),-aggr(max(REVENUE),REVENUE))

[danialier]

Thanks !