Selecting all except exclusions

[#1]

I have a scenario where I want to display data based on exclusions rather than selections. (It came up on a webinar this morning but wasn't answered at the time).

For example if I had a list of all cost centres and was displaying data based on all these cost centres, ie total spend, but then had a need to exclude some, say those representing capital spend.  I don't want to have to select cost centres individually; I want to select the capital spend group and display the the total spend from the cost centres that remain when the capital spend cost centres are excluded.

Any guidance gratefully accepted.

[alexandros17]

Take a look to set analysis help search for E use with which you can exclude selections, really easy to use.

[bgerchikov]

Hi Gareth,

In addition to element function E, I'd suggest to use "-" in Set Analysis as follows:

CostCenter -={"Some Value"}

Hope it will help

[ashfaq_haseeb]

Hi,

Try something like this

=sum( {$<CostCenter= E({$} CostCenter)>} Sales )

Regards

ASHFAQ