topic Re: cross table difference between the group variable in SAS Visual Analytics

cross table difference between the group variable

Beecelal — Mon, 19 Jul 2021 10:01:38 GMT

Hi all,

I want to calculate the difference between group1 and group2 and between group3 and group4.
I have have the cross table and should be showing something as below (attached in excel).

here
Group is a column,
campaign and name are Row
count, net sales, order value are measures

I don't know how to apply in this case.

Thank you in advance for your help.
BR

Re: cross table difference between the group variable

Sam_SAS — Fri, 23 Jul 2021 14:18:27 GMT

Hello,

You can create the difference by using simple calculated measures. They would have an expression like this:

'Group1'n - 'Group2'n

Let us know if this works.

Thanks,

Sam

Re: cross table difference between the group variable

Beecelal — Fri, 23 Jul 2021 14:30:19 GMT

Hi Sam,

here Group1 and Group2 ... are not the Variable name. The variable Name is here the Group the Group is a category variable.

Thanks,

Celal

Re: cross table difference between the group variable

Sam_SAS — Fri, 23 Jul 2021 14:37:23 GMT

Oh! I get it now.

Sorry, I don't think you can achieve this using your current data structure and using the Crosstab object in VA.