About cross-tabulating

Cross-tabulating allows you to summarize a table by arranging character fields in rows and columns. The result is a grid of information, similar to a pivot table, that can make it easier to visualize relations and patterns in the data. You can count the records for each unique combination of row and column values – that is, each row-column intersection – and subtotal numeric fields for each intersection. You can save results in an ACL table, or view results on the screen or in a graph. Cross-tabulating works on sorted and unsorted tables.

Cross-tabulating is similar to summarizing using two character fields. The counts and subtotals in the output results are the same, but the information is arranged differently. Cross-tabulating also displays counts and subtotals of zero, which summarizing does not. Depending on the type of analysis you are doing, displaying counts and subtotals of zero can be useful.

Cross-tabulating in detail

Cross-tabulating counts the number of records in a table and performs the following operations:

Table 1. Operations performed by cross-tabulating

Operation

Location in Figure 1

Groups the records based on unique combinations of values (intersections) in two or more character fields arranged into a grid of rows and columns

intersections of Cust Number field (rows) and Type field (columns)

Subtotals numeric fields for each row-column intersection

Amount field

Optionally subtotals the number of records for each row-column intersection

Count field

Provides totals for all columns included in the output results

Totals row

Figure 1 provides an example of the results produced by cross-tabulating customer number and transaction type, and subtotaling on transaction amount, in an accounts receivable table (the ‘Ar’ table in ACL DATA\Sample Data Files\Sample Project.ACL) and outputting the results to screen.

Figure 1. Cross-tabulate results

Related tasks
Cross-tabulating data


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback