Rank, Textbox, Set Analysis

[Anonymous]

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?

[sunny_talwar]

May be something like this:

=FirstSortedValue(Item, -Aggr(Count(Item), Item))