BookmarkSubscribeRSS Feed
Beecelal
Fluorite | Level 6

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

3 REPLIES 3
Sam_SAS
SAS Employee

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

Beecelal
Fluorite | Level 6

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

Sam_SAS
SAS Employee

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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 765 views
  • 4 likes
  • 2 in conversation