Calculate total of a measure while ignoring filters

[Achraf_Ougdal]

Hello,

I have a bit of a special need. I would like to calculate the % of a calculated item but while ignoring the filters.

For example I have the following Data

If I want to filter on the European Countries, I would like the % to take the total of value (580) and not 350 (150+200).

In other words the % should be like this : Sum(For_Group) Value / Sum (For_All ignoring the filter) Value like this.

Thank you very much 

[yabwon · Accepted solution]

1) Provide some example data (in form of a data step) we could use to help you.

2) What code did you test?

Bart

[Achraf_Ougdal]

Hello, Unfortunately, I am unable to provide any data example. I am working on SAS Visual Analaytics on SAS 9.4 (Windows).

This is the Expression I used to calculate the % : ( Sum [_ByGroup_] ('Value'n) / Sum [_ForAll_] (
'Value'n) ) * 100

But the problem is when I filter on the Continent the Sum [_ForAll_] ('Value'n) takes the total of the continent (It's vulnerable to the filter) I want it to ignore the filter and take the Sum(Value) for all countries in all continents.

Thank you