Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
You can force the columns to move to front by creating an empty table
temp:
Load * Inline [
DimYouneed1,DimYouneed2,DimYouneed3
];
Concatenate (temp)
Load * From yourdatasource.qvd;
Main:
CrossTable(DimYouneed1,DimYouneed2,DimYouneed3,3)
Load * Resident temp;
drop table temp;