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

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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
  • 678 views
  • 4 likes
  • 2 in conversation