topic Re: Calculate total of a measure while ignoring filters in SAS Visual Analytics

Calculate total of a measure while ignoring filters

Achraf_Ougdal — Tue, 11 Jul 2023 11:17:32 GMT

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

Re: Calculate total of a measure while ignoring filters

yabwon — Tue, 11 Jul 2023 11:28:05 GMT

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

2) What code did you test?

Bart

Re: Calculate total of a measure while ignoring filters

Achraf_Ougdal — Tue, 11 Jul 2023 12:31:33 GMT

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