Set Analysis to Exclude particular possible

[Anonymous]

Hello Expterts,

I want to exclude some fixde  valuse of column from expression.How can I achive this.

I have tried this sum( {$<~[Country] = {*"City of New York"*}>} Sales) which is mentioned in Help.

But this is not working.

[maxgro]

sum( {$<Country= {“*”} – {"*City of New York*"}>} Sales )

[#3 · Accepted solution]

Hi,

Try this

sum( {$<[Country] -= {'City of New York'}>} Sales)

Or

sum( {$<[Country] ={'*'}- {'City of New York'}>} Sales)

Or

sum( {$<[Country] -= {"City of New York"}>} Sales)

[MK_QSL]

Use -= .... In set Analysis -= means not equal to....

SUM({<Country -= {'UK'}>}Sales)

will give you SUM(Sales) for all countries except UK

[Anonymous]

Thanks Rakesh.