Set Analysis exclusion on all fields from a particular table

[#1]

Hi there,

Bit new to the Set Analysis. I would very much like to know if there is a simple way to exclude selections in an expression from an entire table? Is this possible?

Kind regards

Jonathan

[#2]

HI Jonathan,

You can exclude something in Set analysis by using the - sign

for example:

SUM(

     {<

          Dimension -= {'Value'}

     >}

     Sales

)

Regards,

Reyman

[swarup_malli]

Jonathan,

I'm attaching an example(.qvw).

Regards

Swarup

[SunilChauhan]

sum({1-$}value)

will sum all values exceept current selections

$ represent current selection

hope this helps you

[#5]

Hi everyone, thanks for the help and sorry for the late reply. What I was refering to would be to exclude any selections made on any dimensions in a whole table. Would I have to enter all the fields one at a time?

Thanks again for all the help