Ignore selections Set Analysis

[Anonymous]

Hello, I need to ignore selections in all fields except those included in the expression below. How can I do that?

Sum ({$<År = {$(=max(År))}, Kvartal = {$(=maxstring(Kvartal))}, Mottagare = {$(=maxstring(Mottagare))}, Version = {'$(vVersion1)'} >} Vattenfall_Value)

-

Sum ({$<År = {$(=max(År))}, Kvartal = {$(=maxstring(Kvartal))}, Mottagare = {$(=maxstring(Mottagare))}, Version = {'$(vVersion2)'} >} Vattenfall_Value)

[#2]

Hi,

Use 1 instead of the first $

sum({ 1 < ......

1 signifies ALL, $ signifies the current selections

Fabrice

[hic · Accepted solution]

If you want to ignore all selections, you should use "1" instead of "$". E.g. ... {1<År= ...

HIC

[pgrenier]

Hello Johan,

In order to ignore all selections except a distinct few, you may use the following approach:

Sum({1<Year=$::Year>} Sales)

So, for your specific expression, it would look something like:

Sum({$<Âr=$::Âr, Kvartal=$::Kvartal, Mottagare=$::Mottagare, Version= {'$(vVersion1)'} >} Vattenfall_Value)

Cheers,

Philippe