petergemeni
Programmer
Hi
id name country
1 jagan india
2 ram india
3 sebastien france
4 john USA
5 wilson Australia
so on ...
i want to display all countries with number of ppl above 10 and rest as others like
india 11
australia 16
USA 12...
others 57
so the problem is in formula if i say
if(count(id)>10;[country];"others") there is context problem in formula and gives wrong result
also tried if(count(id) foreach([country])>10;[country];"others") in vain
please help please please
id name country
1 jagan india
2 ram india
3 sebastien france
4 john USA
5 wilson Australia
so on ...
i want to display all countries with number of ppl above 10 and rest as others like
india 11
australia 16
USA 12...
others 57
so the problem is in formula if i say
if(count(id)>10;[country];"others") there is context problem in formula and gives wrong result
also tried if(count(id) foreach([country])>10;[country];"others") in vain
please help please please