Question on FirstSortedvalue formula

[danialier]

Hello,

I have the attached QV document with a black text box showing the company name that has the highest revenue. When I select a month the black box returns the right company name based on the highest revenue. However when I select all months the black box returns a wrong company name.

Please help !

Thanks,

dani

[jagan · Accepted solution]

Hi,

Try like this

=FirstSortedValue(Company, -Aggr(Sum(Revenue), Company))

Regards,

Jagan.

[parthiband]

Try this too

Only({$<Company={"=Rank(Sum(Revenue),4,1)=1"}>}Company)

Thanks,

[danialier]

Great, thanks Jagan !