Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to display 97 countries out of 100 ,
3 are excluded by using set analysis
????
heip me
thanks in advance
May be like this:
Sum({<Countries -= {'Country1', 'Country2', 'Country3'}>} Measure)
May be try this also
sum( {$<Countries = E({1<Countries ={‘C1’,'C2','C3'}>})>} Measure)
i have to display 97
it has to change dynamically as selection made in list box
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, '|'))
Hi,
Try this expression.
Sum({1-$}Measure)
Regards,
Kaushik Solanki
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.
thanks to all
for the answers