Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
How works this one?
{<Year=, Region=, Area=, Country=>}
Hi,,
infact, it gives me the same problem, it works for the first three, but not for the country 😞
Any other ideas?
Only about 'Country'? And if you change the order?
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....
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])