Displaying the top value in a text box

[#1]

I have a table like the following

UserNamejavascript:;	Team	Count
User1	Italy	1
User2	Spain	1
User3	Germany	1
User4	Italy	1
User5	Germany	1
User6	Italy	1

I would like to have a Text Box that displays "Italy" as being the most popular choice...regardless of any selections that are made on the data.

I have seen some solutions for this but if I had a list box based on username and I selected e.g. User5, the value displayed in the text box would change to "Germany" and would not display "Italy" which is, regardless of the selection, still the most popular choice.

This seems such a simple thing to do but I cannot see a simple solution for it.

[#2]

I did check out the screen shot but I only have the desktop version so can't open the qvw file.

[Kushal_Chawda]

Awsome

[sunny_talwar]

Since you have your solution, there is no point going over my proposed way of doing it

[#5]

As it turned out there was a problem with the original solution and I went back to your suggestion and it did actually work as you described.

[#6]

This solution did work initially but for some reason as the data changed the most popular team always remained the same regardless of how the data changed.

[sunny_talwar]

Great, I am glad it did help you out in the end