Problem with Set Analysis

[#1]

Hi all,

I would like to use a set analysis, which deactivates 4 selection fields, so that neither of them does impact the chart results.

I am using the following syntax:

(sum({$<Year =,[Region]=,[Area]=, [Country]=>}_revenue) .

It works for Year, Region & Area, but it is not applied for country.

Would be great if you could help me out on this one.

Thanks,

Adi

[#2]

Hi

How works this one?

{<Year=, Region=, Area=, Country=>}

[#3]

Hi,,

infact, it gives me the same problem, it works for the first three, but not for the country 😞

Any other ideas?

[alboreal]

Only about 'Country'? And if you change the order?

[#5]

Yes, only for country. I tried to change the order and it does not work either.

Then I thought it might be related to the fact that I have modified the field to exclude some countries from the selection box:

= if([Reporting Entity] <>'AUT' and [Reporting Entity]<>'ESPT' ,[Country])

Label = Country

but I am doing a similar modification in the selection box for region and area and it still works....

[#6]

It Seems, that the issue is really linked to the fact, that I am using an if condition

= if([Reporting Entity] <>'AUT' and [Reporting Entity]<>'ESPT' ,[Country])

to populate the country list in a listbox.

When I replace Country in the Set Analysis with = if([Reporting Entity] <>'AUT' and [Reporting Entity]<>'ESPT' ,[Country]) , the set analysis works fine.

Now I wonder, if I could create a variable, which would replace the if statement and could also be used to populate the country list in a list box - would make things much easier.......