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

[haneesh312]

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

A

B

A

C

A

B
A

A

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]

Hello @haneesh312 ,

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