Skip to Content
Mar 16, 2009 at 09:20 AM

"Others" aggregate based on count In Webi report


Hi everybody,

I'm trying to create a variable to aggregate as "others" the categories for witch the population is less than 10 (in a webi report).

In this case : I have a "nationality by continent" variable, a "nationality by country" variable, and "number of pupils" indicators. What I'm trying to do is :

<li>to set the continent variable in the first column;

<li>to set the country variable in the second column. But in this column, only the country for which there are at least 10 pupils will be displayed. The others countries have to be aggregate as "Others";

<li>finally, to set the number of pupils by country displayed.

I try this function :

=If([Pupils Number] In ([Country]) < 10;"Others";[Country])

If i set the variable Country and the new one, countries with count less than 10 are "Others" for the new variable, but if i drop the country variable i receive a #multivalue error.

What am I supposed to do?

Thanks in advance for your help.