Creating a Matrix Report

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.


Top of page

Example: Creating a Simple Matrix

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                .

Top of page

Example: Creating a Matrix With Several Sort Fields

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