Multiple alternate states within a bookmark

[Mt3]

Hi,

I was wondering if any of you have assinged 2 or more alternate states to a bookmark selection in set analysis?

I have tried below and result are following:

sum({1-[Group 1]::BM01} Sales) - works fine

sum({1-[Group 1,Group2]::BM01} Sales) - does not bring any results

sum({1-([Group 1]+[Group2])::BM01} Sales) - does not bring any results

sum({[Group 1][Group2]::BM01} Sales) - does not bring any results

Also, do you think it would be possible to add multiple bookmarks, to the selection? Exemplary:

 sum({1-(([Group 1,Group2]::BM01) + ([Group 1,Group2]::BM02) )} Sales)

I have checked that  sum({1-(([Group 1]::BM01) + ([Group2]::BM02) )} Sales) gives a result but skewed in numbers.

[chris_djih · Accepted solution]

i would guess you have to do the operations the other way around:

try something like this: sum({1-([Group 1]::BM01+[Group2]::BM01)} Sales)