Aggregation Example

As an example of crosstab aggregation, consider the crosstab configuration below.

 

In this configuration:

Row dimension is a 'Region'/'State' hierarchy

Column dimension is a 'Category'/'Product' hierarchy

Measure is 'Quantity Purchased'

The 'Aggregate' menu specifies 'Sum', which indicates that each value in the crosstab will represent the sum of 'Quantity Purchased' taken over all records matching the given row and column headings. Thus, for the row region heading 'USA East' and the column category heading 'Business', the summary value of the measure shown in the crosstab represents the summed quantity of all 'Business' category products purchased by 'USA East' region customers.

 

In the same way, if you set the 'Aggregate' menu to 'Max', the summary value shown in the crosstab for the above row and column combination would represents the maximum quantity of 'Business' category products purchased by any 'USA East' region customer.

See Also

Crosstab Properties: Hierarchy Tab, for information on how to specify a custom drill-down hierarchy.

<< 4.3.3 Crosstab Aggregation Methods © 1996-2013 InetSoft Technology Corporation (v11.4) Aggregation Options >>