Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try like this
=FirstSortedValue(Company, -Aggr(Sum(Revenue), Company))
Regards,
Jagan.
Hi,
Try like this
=FirstSortedValue(Company, -Aggr(Sum(Revenue), Company))
Regards,
Jagan.
Try this too
Only({$<Company={"=Rank(Sum(Revenue),4,1)=1"}>}Company)
Thanks,
Great, thanks Jagan !