Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to add new column to crosstable, however it appears that its always goes under "y value"
CROSSTABLE(x,y)
Load
cust_ID,
vVar1,
vVar2,
vVar3,
vVarCalculated
Resident TableX;
What is currently(vVarCal is weighted value)
ID | X | Y |
ID1 | vVar1 | Value of vVar1 |
ID1 | vVar2 | Value of vVar2 |
ID1 | vVar3 | Value of vVar3 |
ID1 | vVarCalculated | vVarCalculated |
What I would like to achieve
ID | X | Y | vVarCalculated |
ID1 | vVar1 | Val of vVar1 | Val of vVarCal |
ID1 | vVar2 | Val of vVar2 | Val of vVarCal |
ID1 | vVar3 | Val of vVar3 | Val of vVarCal |
Is it something I can do or its limited to only X and Y?
Hi
Try like below
CROSSTABLE(x,y, 2)
Load
cust_ID,
vVarCalculated,
vVar1,
vVar2,
vVar3
Resident TableX;