Focal Point
Change column order in a cross-tab multi-verb report
May 13, 2008, 02:22 PM
<Steven>Change column order in a cross-tab multi-verb report
I have a cross-tab report created using the multi-verb technique as shown below:
TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
SUM SALES
BY COUNTRY
ACROSS BODYTYPE AS 'BODYTYPE' ACROSS-TOTAL AS 'Total Sales'
ON TABLE COLUMN-TOTAL AS 'Total'
END
I want to figure out how to get the DEALER_COST column to position besides the 'Total Sales' column. In addition, I need to have another compute field based on the values of the DEALER_COST column and the values of the 'Total Sales' column.
Please help.
Thanks
May 13, 2008, 02:32 PM
Darin Leethrow this in before the END statement:
ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=N2, SEQUENCE=99,$
ENDSTYLE
Regards,
Darin
In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
May 13, 2008, 02:36 PM
Darin LeeAs for the next question, you could do this with a simple compute in the first verb phrase:
COMPUTE PROFIT/D12.2=SALES - DEALER COST;
Regards,
Darin
In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat