Set Analysis Excluding All Selections

[#1]

Hi All,

Using Set Analysis can we Exclude all the selections Except one field.

sum({1<FIELD1=FIELD1>} Sales) : This does not work.

Does any one have other alternatives.

Regards,

MAK

[#2]

sum( {1<FIELD={Value} Sales>} This works but it is restricted to this Value. I want it to be depended on only one field selection.

Can any body do this?

[yblake]

to get all selection except set A, use {1-A}

[rbecher]

I'm not sure if I understand what you want, but

sum( {1-$} Sales )

will summarize all except the selections.

[#5]

As you said , {1-$} will give All except the selections.

Here is what I want exactly

If I make selections on Field1 , Field2 , Field3....., Field100.

I want to summarize by Ignoring all selections but Including Field3 Selection.

[rbecher]

This will summarize all Sales values with the current Field3 selection:

sum( {1 < Field3 = {"$(=getfieldselections ( Field3 ))"} >} Sales )

Will work only if a single value is selected.

[#7]

Thanks Ralf.

Is there any solution for Multiple Values?

[rbecher · Accepted solution]

I played around a bit and this works now for me:

sum( {1 < Field3 = {$(=getfieldselections ( Field3 ))} >} Sales )

Just without the quotes! 😉

[#9]

Thanks Ralf,
I tried removing Quotes. It doesnt work.

Did you change anything else?

[rbecher]

No. It depends on the values of Field3. Do you have values with blanks or strange chars?

This is my last idea:

sum( {1 < Field3 = {$(=getfieldselections ( Field3, ',', 100 ))} >} Sales ) // getfieldselections with comma separator, max 100 values (default is 6)

You can check the return of getfieldselections ( Field3, ',', 100 ) if you insert it as a formula. It should return a comma separated value list.