Set Analysis for neary all selections removed

[#1]

Hello,

I want to create an expression which sums up all values for all selections removed, except for one field.

sum( {1<Region= {US} >} Sales )

This sample from the help file is nearly what I need.
Just that I want to keep Region = 'Current Selection'.

How to specify 'current selected Region' in that context?

Thanks in advance,
Thilo

[#2 · Accepted solution]

Ok,

got it:

sum( {1<Region={$(=Region)}>} Sales )

Thilo

[johnw]

I don't think that will work if you have no or more than one Region selected. I think this will, though (untested):

sum({1<Region={'$(=concat(Region,chr(39)&','&chr(39)))'} Sales)

[nivellen11]

I had same problem

Thanks John for your post it helps a lot.

You just skipped 2 chars >} before Sales

it should look like this and it work:

sum({1<Region={'$(=concat(Region,chr(39)&','&chr(39)))'}>} Sales)