ACE Analytics Pivoting and Summarizing Data

Click the Add Crosstab tab to use the feature that lets you create a crosstab (also known as a "pivot") table:

Here's how to use this feature:

1. Select the Header Values Column, whose values will be shown horizontally, as column headers, across the top of the crosstab table. Additional controls may appear depending on the data type of the selected column.
2. Select the Label Values Column, whose values will be shown vertically, in the left-most column of each row.
3. Select the Aggregate Values Column, whose values will be aggregated to produce the contents for the rest of the table cells.
4. Select the Aggregate Function to be applied to the column selected in Step 3. Options include Sum, Average, Standard Deviation, Count and Distinct Count.
5. Select a Summary Function to display a summary result.
6. Check the Compare Label Columns checkbox to cause the difference between column values to be displayed, along with a cell shading indicator. Click Add to generate the crosstab table, in its own panel.

The Summary Function and Label Column Comparison features provide interesting ways to analyze the data:

As shown above, summarizing the data totals the rows and columns, inserting a row and column to display the results, and the Label comparison inserts a the difference as a percentage into each and colors them to indicate their relative differences.

Click the Gear icon to hide the configuration area.