---
title: "Pivot mode: Reorganising your data"
slug: "pivot-mode-reorganising-your-data"
updated: 2026-07-07T15:01:11Z
published: 2026-07-07T15:01:11Z
canonical: "help.cintra.co.uk/pivot-mode-reorganising-your-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.

# Pivot mode: Reorganising your data

Pivot mode lets you reorganise report data so you can group and summarise it in different ways. Instead of viewing rows of data, you can “pivot” the table to show totals, counts, or comparisons across categories.

This will help you spot trends or patterns, summarise large datasets, and create custom views without the need to export to MS Excel.

1. Open a report that supports pivoting (e.g. a Pay Elements report).
2. Enable **Pivot Mode** using the toggle in the right-hand panel.
3. **Set your column labels** (what appears across the top):
  1. Drag a field (e.g. Payroll Period) into the **Column Labels** area.
4. **Set your row groups** (what appears down the left):
  1. Drag fields (e.g. Payroll Name, Pay Heading Type, Pay Heading Name, Employee) into the **Row Groups** area.
5. **Add values** by dragging a field (e.g. Amount) into the **Values** area.
6. Use the **date filter** to set the date range (e.g. a full tax year).
7. To sort columns into alphanumeric order, click **Sort Columns** (bottom-right of the panel).
8. Save your template when complete.

To find out how to use the key features of pivot mode, [▶ **Watch: Save, share and export reports**](https://www.youtube.com/watch?v=12dR5IdYuqk) *(opens in YouTube)*

[Embedded content](https://www.youtube.com/embed/12dR5IdYuqk)