topic Re: Difference between percentage of two groups in a category in SAS VA in SAS Visual Analytics

Difference between percentage of two groups in a category in SAS VA

haneesh312 — Wed, 24 Apr 2019 07:04:25 GMT

I would like to aggregated field , which is the difference in percentages between two groups in a category using a calculated fiedls in SAS VA .

example:

Data

B
A

% of A -60%

% of B - 30%

difference -30%

I want difference field to be caluculated in a field and should be able drill up and down

PetriRoine — Thu, 09 May 2019 08:02:32 GMT

Have you tried creating two new calculated items, one for As and one for Bs, and then calculate the difference?

Something along the lines:

New calculated item for As:

IF (Category = 'A' )
RETURN Measure
ELSE 0

And a similar for Bs.

Then a new measure to calculate the difference between these two. Of course you need to take care of the percentage of total also.

Best regards,

Petri