Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
=Max(Aggr(Count(Country),Country))
=Max(Aggr(Count(Country),Country))
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
Hi.
do you mean like the attached?
Regards
ASHFAQ
Try below in Text Box
For Number
=MAX(Aggr(COUNT(Location),Location))
For Location
=FirstSortedValue(Location, -Aggr(COUNT(Location),Location))