Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI Jonathan,
You can exclude something in Set analysis by using the - sign
for example:
SUM(
{<
Dimension -= {'Value'}
>}
Sales
)
Regards,
Reyman
Jonathan,
I'm attaching an example(.qvw).
Regards
Swarup
sum({1-$}value)
will sum all values exceept current selections
$ represent current selection
hope this helps you
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