cross table difference between the group variable

[Beecelal]

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

[Sam_SAS]

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]

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]

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.