Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've 3 columns
Customer Cust Rating Item
A Great Pen
A Good Pencil
A Bad Eraser
A Great Ink
B Great Pen
B Good Pen
B Bad Pencil
B Avg Eraser
I would like to show the Rank 1 item based on Great Customer Rating in a text box for all the customers.
For example, In the above table, Customer A & B ordered 8 products out of which they rated 'Great' 3 times. Pen was rated Great twice.
How can I show that in a text box and not a table?
May be something like this:
=FirstSortedValue(Item, -Aggr(Count(Item), Item))