> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/rollup-column.md).
# Rollup Column
A rollup column aggregates values from related records in a linked table and displays the aggregated result in the current table. Use rollup columns to calculate values such as **sum**, **count**, **average**, **minimum**, **maximum**, **median**, **earliest date**, **latest date**, **countA**, **empty**, and more.
### Use cases of rollup column
You can use a rollup column to
* Display the total hours logged for a project.
* Show the number of open tasks assigned to an employee.
* Calculate the total value or quantity of orders for a product or customer.
* Display the latest or earliest order date for a product.
A rollup column is similar to a [reference column](/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/reference-column.md) but also automatically calculates aggregated values from related records. This eliminates the need to manually maintain summary values across multiple tables. When data in the linked table changes, the rollup value is recalculated automatically.
This article explains how to create and configure a rollup column by using a sample **Products** table.
In this example, you create:
* A rollup column that displays the **total order quantity** for each product.
* A rollup column that displays the **latest order date** for each product.
### Add a rollup column
1. Go to **PowerTable** > **Insert Column** > **Visual Column** > **Add Roll Up Column**. A side panel opens.
2. Configure the following details:
* **Column Name**: Enter an appropriate name for the rollup column, such as *Total Orders*.
* **Schema**: Select the schema that contains the linked table.
* **Linking Table**: Select the table that contains the records to aggregate.
* **Column from Current Table**: Select the column in the current table used to match records.
* **Column from Linking Table**: Select the matching column in the linked table. In this example, *ProductKey* is the matching column.
* **Column To Rollup**: Select the column to aggregate. Here, choose *OrderQuantity* as the column to roll up.
* **Aggregation**: Select an aggregation function, such as **Sum**, **Average**, or **Count**. Use **Sum** to add and aggregate the order quantities for each product.
3. **If Condition**: Optionally, add one or more filter conditions by using **Add Filter** to aggregate only the records that meet specific criteria. Combine multiple conditions by using **AND** or **OR**. For example, you can aggregate only the orders placed after a specific date by filtering on the **OrderDate** column.
4. The display properties for the rollup column can be configured in the panel's **Display** tab. To learn more, see [Display](/powertable-sheets/how-tos/configure-column-properties/display.md).
5. Select **Save**.
A rollup column that displays the aggregated order quantity for each product is added based on the matching product key.
{% hint style="info" %}
### Note
Products with no related records or no values to aggregate display a blank value in the rollup column.
{% endhint %}
### Another example
To create another rollup column that displays the latest order date, repeat the same steps. Select **Order Date** as the column to roll up, and select **Latest Date** as the **Aggregation** type. Select **Save**.
The latest order date rollup column is added, as shown in the following image.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://docs.fabricplan.com/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/rollup-column.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
