---
title: "ACE Analytics Pivoting and Summarizing Data"
slug: "ace-analytics-pivoting-and-summarizing-data"
updated: 2023-04-17T16:05:08Z
published: 2023-04-17T16:05:08Z
canonical: "docs.interprose.com/ace-analytics-pivoting-and-summarizing-data"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.interprose.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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:

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/RB_36.png?sv=2026-02-06&spr=https&st=2026-10-31T18%3A42%3A32Z&se=2026-10-31T19%3A42%3A32Z&sr=c&sp=r&sig=5ByC8v%2BX7hDMimG5uVE4h5a47tSZ9sO2jxDr6Wgs%2Ffs%3D)

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:

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/RB_37.png?sv=2026-02-06&spr=https&st=2026-10-31T18%3A42%3A32Z&se=2026-10-31T19%3A42%3A32Z&sr=c&sp=r&sig=5ByC8v%2BX7hDMimG5uVE4h5a47tSZ9sO2jxDr6Wgs%2Ffs%3D)

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.