Counting values

[#1]

Hi I have a table as presented below

Location
USA
USA
USA
Spain
Italy
Italy

I need to count what is the maximum repetition of a country. For ex. in this case the result of expression should be 3  (USA occur 3 times, I don't need to know what country it is, just amount). This is just a sample table so in real case I can't use set analysis because of huge amount of different countries

Any idea how to solve that ?

[anbu1984 · Accepted solution]

=Max(Aggr(Count(Country),Country))

[Anonymous]

Go to straight Table->Don't add any dimension->Create the expression->Count(Country)->Sort(Descending)->Go to Dimension Limits->Restrict the number of vaues you want to display

[ashfaq_haseeb]

Hi.

do you mean like the attached?

Regards

ASHFAQ

[MK_QSL]

Try below in Text Box

For Number

=MAX(Aggr(COUNT(Location),Location))

For Location

=FirstSortedValue(Location, -Aggr(COUNT(Location),Location))