4.3 Crosstabs

A crosstab, also known as a pivot table, contains one or more column headers and one or more row headers, and displays aggregated measure values at the row-column intersections.

For example, a train schedule displays dates horizontally across (column header), station names vertically down (row header), and departure times (measure) at the intersections. Not every row-column combination need have an associated measure value; for example, there may be combinations of date and station for which there is no corresponding train departure.

In general, the values at the row-column intersections of a crosstab represent summary information of a measure, rather than point values. For example, a crosstab with row headers representing 'Salesperson' and column headers representing 'Month of Year' might contain values at the intersections representing 'Average Sale Price' or 'Maximum Sale Price'. The measure in both cases is 'Sale Price'. The summarization method is, respectively, Average or Maximum. By effectively using summarization, crosstabs can display large amounts of data in a compact form.

<< Freehand Table Properties: Advanced Tab © 1996-2013 InetSoft Technology Corporation (v11.4) 4.3.1 Creating a Crosstab >>