You can create a matrix report by sorting both rows and columns. When you include both BY and ACROSS phrases in a report request, information is sorted vertically and horizontally, turning the report into a matrix of information that you read like a grid. A matrix report can have multiple BY and ACROSS sort fields.
The following request displays total salary outlay across departments and by job codes, creating a matrix report.
TABLE FILE EMPLOYEE SUM CURR_SAL ACROSS DEPARTMENT BY CURR_JOBCODE END
The output is:
DEPARTMENT CURR_JOBCODE MIS PRODUCTION ------------------------------------------------ A01 . $9,500.00 A07 $9,000.00 $11,000.00 A15 . $26,862.00 A17 $27,062.00 $29,700.00 B02 $18,480.00 $16,100.00 B03 $18,480.00 . B04 $21,780.00 $21,120.00 B14 $13,200.00 .
The following request uses several BY and ACROSS sort fields to create a matrix report.
TABLE FILE EMPLOYEE SUM CURR_SAL ACROSS DEPARTMENT ACROSS LAST_NAME BY CURR_JOBCODE BY ED_HRS WHERE DEPARTMENT EQ 'MIS' WHERE CURR_SAL GT 21500 END
The output is:
DEPARTMENT MIS LAST_NAME CURR_JOBCODE ED_HRS BLACKWOOD CROSS ------------------------------------------------------ A17 45.00 . $27,062.00 B04 75.00 $21,780.00 .
Information Builders |