> For the complete documentation index, see [llms.txt](https://docs.gridmate.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.gridmate.io/product-tour/grids/pivot-grid-in-action.md).

# Pivot Grid

Summarize and edit time series records as a pivot table with search and pagination.

GridMate provides a component to display a collection of records as a Pivot Table. With GM - FieldSet Pivot, we can display time series records with the ability to summarise and edit the data.

In this tutorial, we will setup a pivot grid to visualize forecasts per opportunity per month. We created a custom object to store forecasts. The forecast object has a master-detail relation to the opportunity.

![](https://4046919449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MEsSbGy_U_OhthKUpxu%2Fuploads%2F7pnORKdUwu6hBYnd4JDM%2FScreenshot%202022-01-13%20at%2017.04.03.png?alt=media\&token=be41473b-a56a-4041-a164-79c3c3288909)

Also, An automation has been set to create the forecast records for each closed won opportunity. Below is a quick demo on how to configure the **GM - Pivot Grid** component.

{% embed url="<https://youtu.be/32o6BgKfG7c>" %}

{% hint style="info" %} <mark style="color:blue;">**X Columns**</mark> property contains the fields to build the columns of the grid. We put the date of the forecast in our case.

<mark style="color:blue;">**Y Columns**</mark> property contains the fields to build the row headers. In our example, we want to group our forecasts by Opportunity. Multiple fields could be used as row header.

<mark style="color:blue;">**Value Columns**</mark> property contains the fields to use as cells. Multiple fields could be used. In our example, we want to visualize the investment, the revenue and the net revenue.
{% endhint %}

{% hint style="success" %}
The Config. Wizard can be used to configure different properties like the sort, order and aggregation....
{% endhint %}

## **Custom Labels**

To configure **Custom Labels**.

1. Launch the Configuration Wizard and select the **Custom Labels** tab.
2. Step 1 - Select Fields. From the Available list select the field to be renamed.
3. Step 2 - Define Labels. Define the label for each selected field.
4. Step 3 - **Custom Labels** Configuration

The Custom Labels Configuration dialog displays the **Custom Labels** text.

This value can be used to populate the **Custom Labels** property value of the GridMate component.

{% embed url="<https://youtu.be/piEEnCdG92k>" %}
Define Custom Labels
{% endembed %}

{% hint style="info" %}
To add helper text to fields:

* Click the gear icon and select **Setup**.
* Navigate to **Object Manager**, select the object (e.g., Forecast), and go to "Fields & Relationships."
* Find the field, click the **Edit**, scroll to **Help Text**, enter your text, and S**ave**.
  {% endhint %}

## Pagination <a href="#search-property" id="search-property"></a>

**Pivot Grid Pagination** allows you to control how records are fetched and displayed by grouping related data at a higher level. By setting a ***paging field name***, you move up one level in the data hierarchy ensuring that related records are loaded together on the same page.

in this tutorial, we’ll set the **paging field name** to **"opportunity\_\_c"**. This ensures that all forecasts related to a single opportunity are displayed together on the same page.

{% embed url="<https://youtu.be/-G_w7EMP8qI>" %}

Below is an example of the ***Paging Filter.***

```coffeescript
{
    "and": [
        {
            "AccountId": {
                "operator": "=",
                "value": "$recordId"
            }
        }
    ]
}
```

## **Search** <a href="#search-property" id="search-property"></a>

To configure the **Search Fields** properties.

1. Edit the Lightning page in the App Builder.
2. Scroll down until you see **Search Fields**.
3. Select **Search** **Field**(**s**). From the Available fields which are searchable, for example Text, PickList, Phone, Email, URL .

<figure><img src="https://4046919449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MEsSbGy_U_OhthKUpxu%2Fuploads%2FD6lidXn4xb0QlKJWQjzv%2FScreenshot%202025-06-25%20at%2019.32.21.png?alt=media&amp;token=58f70ccd-f0e1-4eb4-927d-63df1e04b61d" alt=""><figcaption><p>GridMate - Pivot Grid - Search</p></figcaption></figure>

Below is a step by step tutorial to configure the **GridMate - Pivot grid** **Search property** feature.

{% embed url="<https://youtu.be/kRzQmm2Ns6Q>" %}
Pivot Grid - Search
{% endembed %}

## Inline Cell Edit

To configure the **Inline Cell Edit** properties.

1. Edit the Lightning page in the App Builder.
2. Scroll down until you see **Enable Cell Edit** and check the box.

<figure><img src="https://4046919449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MEsSbGy_U_OhthKUpxu%2Fuploads%2FhY3jmqFYRZfx8fDtHs4M%2FScreenshot%202025-07-23%20at%2013.13.53.png?alt=media&amp;token=6db7d964-7604-4862-bd52-c9ee9c2dda75" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
When **Inline Cell Edit** is enabled, End User will be able to edit Y Columns as well.
{% endhint %}

Below is a step by step tutorial to configure the **GridMate - Inline Cell Edit** feature.

{% embed url="<https://youtu.be/TQ4zETuvUEM>" %}

## Next steps

<table data-view="cards"><thead><tr><th></th><th></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>Pivot Grid - Advanced Settings</strong></td><td>Add custom actions, a second X column and formulas to Pivot Grids.</td><td><a href="https://docs.gridmate.io/advanced-guides/other-components/pivot-grid-advanced-settings.md">Pivot Grid - Advanced Settings</a></td></tr><tr><td><strong>Report Table</strong></td><td>Embed Salesforce reports as tables on any Lightning page.</td><td><a href="https://docs.gridmate.io/product-tour/grids/report-table.md">Report Table</a></td></tr><tr><td><strong>GM - FieldSet Pivot</strong></td><td>Every property of the component.</td><td><a href="https://docs.gridmate.io/package-reference/components-library/kanban-and-pivot/gm-fieldset-pivot.md">GM - FieldSet Pivot</a></td></tr></tbody></table>


---

# 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 by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.gridmate.io/product-tour/grids/pivot-grid-in-action.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
