Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How do I show the top selling fruit in a text box expression?
I have the number but Im looking to show the actual fruit name thanks.
=if(rank(count([fruit]))=1,Count([fruit]))
Thank you
=if(rank(count([fruit]))=1,[fruit])
or
=if(rank(count([fruit]))=1,[fruit] & ' = ' & Count([fruit]))
=if(rank(count([fruit]))=1,[fruit])
or
=if(rank(count([fruit]))=1,[fruit] & ' = ' & Count([fruit]))