Exclude multiple words form 'COUNT'

[#1]

I want to exclude two definitions of 'COUNT'. Probably not so complicated, but I do not get it done. One exclusion works fine, a second exclusion unfortunately not.

What I would like to exclude: << choose from list >> and '...'

The expression I use:

Count ({$ <[Type or funtion] - = {"<< >> choose from list"}>} {$ <[Type of funtion] - = {"..."}>} [Type of funtion]) /

Count (TOTAL <Corporatie> {$ <[Type of funtion] - = {"<< >> choose from list"}>} {$ <[Type of funtion] - = {"..."}>} [Type of funtion])

Or: how to select only predefined textstrings in 'COUNT'

[venkatg6759]

Try this

aggr(Count ({$ <[Type or funtion] - = {'<< >> choose from list','...'>} [Type of funtion]),[Type of funtion])

[alexandros17]

Count ({$ <[Type or funtion] = {'*'} - {"<< >> choose from list","..."}>} [Type of funtion])

....

Let me know

[#4]

Like this?

aggr(Count ({$ <[Type or function] - = {'<<choose from list>>','...'>} [Type of function]),[Type of function]) /

aggr(Count (TOTAL <Organization> ({$ <[Type or function] - = {'<<choose from list>>','...'>} [Type of function]),[Type of function])

Probably not, since it doesn't work...

[alexandros17]

I don't know about aggr because I don't know data but

aggr(Count ({$ <[Type or function] - = {'<<choose from list>>','...'}>} [Type of function]) /

aggr(Count (TOTAL <Organization> ({$ <[Type or function] - = {'<<choose from list>>','...'}>} [Type of function])

Let me know

[SunilChauhan]

you can change only below in expression

[Type or function] - = {'listvalue1','listvalue2','listvalue3'}

you can even exclude more you want by comma sepeareted as above

hope this helps

[#7 · Accepted solution]

The tips given work, thanks... but on second thoughts I find it more convenient to configure the load script. After some research:

The dimension that you want to exclude of certain values​​:

[dimension]

FROM '$ (SOURCE) "(OOXML, embedded labels, table is [NAME TABLE]

Where [dimension] <> 'value to exclude' AND [dimension] <> 'value to exclude';