---
title: "Create an aggregate worksheet"
slug: "create-an-aggregate-worksheet"
description: "Create an aggregate worksheet to group data from another worksheet by unique values and perform calculations on those data groups."
tags: ["worksheets", "aggregate"]
updated: 2024-05-24T16:44:00Z
published: 2024-05-24T16:44:00Z
canonical: "docs.zilliant.com/create-an-aggregate-worksheet"
---

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

# Create an aggregate worksheet

Use aggregate worksheets to combine data from an existing worksheet. Aggregate worksheets allow you to use unique values from selected source columns to group data.

To further combine source data, you can create [calculated](/v1/docs/define-calculated-columns) and [related](/v1/docs/define-related-columns) columns in aggregate worksheets. In these columns, you can perform calculations on the created data groups, create relationships between worksheets, and configure custom actions.

For example, if you sell products to multiple customers for different prices, you can use an aggregate worksheet to easily calculate the average margin of each product. For setup details, refer to this [usage example](/v1/docs/create-an-aggregate-worksheet#example).

Watch to learn how to use aggregate worksheets.

[Embedded content](https://zilliant.wistia.com/embed/iframe/npav62orl8)

## Limitations

Some common worksheet features aren't available to aggregate worksheets. You cannot:

- Add or edit [input columns](/v1/docs/define-input-columns-1)
- Add, edit, or copy rows
- [Import data](/v1/docs/import-and-export-data)
- Add [row-level action buttons](/v1/docs/add-row-level-actions)
- [Link analytics](/v1/docs/link-tableau-analytics-to-a-worksheet)
- Configure **Source Data** settings

## Configure an aggregate worksheet

1. From the **Manager Dashboard**, open a workbook.
2. In the worksheet tabs area, select Add.
3. Enter a name for the new worksheet, then select **Next**.
4. Select **Aggregate**, then select **Next**.
5. Select the source workbook and source worksheet that contain the data you want to combine, then select **Next**.
6. Select at least one column from the source worksheet by whose values you want to group the source data in the resulting aggregate worksheet, then select **Next**. The aggregate worksheet creates rows for all unique values from the selected columns.

          Note

          

You cannot change column selections after creating the aggregate worksheet.
7. To create a calculated column, enter information or make selections, then select **Finish**:
  - **Column Name**—Enter a name for the calculated column.
  - **Function**—Select an aggregate function to perform calculations.
  - **Column**—Select a column from the source worksheet whose values you want to aggregate in the calculated column.
  - **Value type**—Select the value type for the calculated column.
  - **Display format**—Select the display format of values in the calculated column.
  - (Optional.) Select **Add a calculated column** to create another column.

Alternatively, select **Skip and finish** to continue without creating a calculated column.

### Example

You sell your products to various customers and use a worksheet to organize this data. The worksheet features columns for:

- **Product ID**
- **Customer ID**
- **Price**
- **Margin**
- **Publish Date**

To prepare for annual reporting, you want to find the average margin for each product and customer. To do this, you create an aggregate worksheet.

While creating the aggregate worksheet:

1. Group your source worksheet data by unique products and customers.
  - At [Step 6](/v1/docs/create-an-aggregate-worksheet#configure-an-aggregate-worksheet), select the **Product ID** and **Customer ID** columns.
2. Calculate the average margin for each product.
  - At [Step 7](/v1/docs/create-an-aggregate-worksheet#configure-an-aggregate-worksheet), create the **Average margin** calculated column:
    - From the **Function** dropdown list, select the **AVG** function.
    - From the **Column** dropdown list, select the **Margin** source column.

The resulting aggregate worksheet displays three columns:

- **Product ID**—Lists all unique products from the source worksheet.
- **Customer ID**—Shows customers associated with the listed products.
- **Average margin**—Calculates the average margin for each product.

![](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Glossary/add_60(1).png?sv=2026-02-06&spr=https&st=2026-11-12T20%3A13%3A49Z&se=2026-11-12T21%3A13%3A49Z&sr=c&sp=r&sig=0JSPfRk3ab805WEMkNACxLGAoVp3MvNE%2Fxynzndozeg%3D) Add