---
title: "Separating the subtotal or total from the report's data"
slug: "how-do-i-separate-the-subtotal-total-from-the-report-s-data"
description: "How to separate a report's subtotal or total from its data in Cintra iQ."
updated: 2026-07-29T09:13:20Z
published: 2026-06-10T11:26:21Z
canonical: "help.cintra.co.uk/how-do-i-separate-the-subtotal-total-from-the-report-s-data"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.cintra.co.uk/llms.txt
> Use this file to discover all available pages before exploring further.

# Separating the subtotal or total from the report's data

## To separate the subtotal/total

You can create a line to separate the **Subtotal/Totals** from the rest of the data in the report using the **Sort** tab.

> [!NOTE]
> **Note:** The **Subtotal** is for numeric values only.

1. Open an existing report or create one. Navigate to the **Sort** tab. Sort the order of the report columns with the appropriate field name.
2. Insert a break.

![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/204001064337.png)
3. Specify the **Subtotal**.
4. Return to the **Field Details** tab.
5. Select the desired **Fieldname**. **Note:** Ensure the **Fieldname** is numeric for the **Subtotal** options to appear.
6. Select the **Subtotal** options.

![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/204001064338.png)
7. Click the **OK** button.
8. Run the report. The **Subtotal/Total** is separated accordingly.