How to add new column in crosstable

[QlickySense]

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?

[MayilVahanan]

Hi

Try like below

CROSSTABLE(x,y, 2)
Load
cust_ID,

vVarCalculated,
vVar1,

vVar2,

vVar3

Resident TableX;