set analysis issue

[#1]

how to display 97 countries out of 100 ,

3 are excluded by using set analysis

????

heip me

thanks in advance

[sunny_talwar]

May be like this:

Sum({<Countries -= {'Country1', 'Country2', 'Country3'}>} Measure)

[Chanty4u]

May be try this also

sum( {$<Countries = E({1<Countries ={‘C1’,'C2','C3'}>})>} Measure)

[#4]

i have to display 97

it has to change dynamically as selection made in list box

[vishsaggi]

Where do you want to display these countries? In a list box or a text box or a straight table?

IN text box try this:

= IF(Not Match(Country, 'Country1', 'Country2', 'Country3'), Concat(Country, '|'))

[kaushiknsolanki]

Hi,

Try this expression.

Sum({1-$}Measure)

Regards,

Kaushik Solanki

[sunny_talwar]

Do you mean if you select 10 out of the 97 countries, the expression should just show those 10? I think the expression should already do that.

[#8]

thanks to all

for the answers