# Pivot Grid - Advanced Settings

## Pivot Grid - Custom Action

We’ve introduced **custom action support for Pivot Grids**, allowing administrators to configure both **global actions** and **mass actions** directly within pivot views.

This enables users to trigger Salesforce **Flows** or **custom actions** without leaving the grid.

#### Flow – Apply Discount %

Below is an example of the **Apply Discount %** Screen Flow used in this demo.

The Flow includes:

* A **Discount Screen**, where the user enters the discount percentage
* An **Update Records** step, which applies the discount to the selected records

<figure><img src="/files/wkOCTzyxEE2scaZcT7K3" alt=""><figcaption></figcaption></figure>

#### Action Configuration

Below is a sample configuration used in this demo:

```json
[
    {
        "label": "Apply Discount %",
        "name": "Apply_Discount",
        "component": "gmpkg:DataGridCallFlowComponent",
        "attributes": {
            "flowName": "Apply_Discount",
            "idListParam": "idList",
            "autolaunched": false
        }
    }
]
```

Below is a step-by-step tutorial on how to configure these actions 👇

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

## Pivot Grid - Second X Column

We’ve introduced support for **secondary X-axis columns** in Pivot Grids, enabling more advanced multi-dimensional analysis through hierarchical grouping.

In this advanced guide, we’ll cover:

* Configuring **two X-axis columns** to enable multi-level grouping
* Using **intermediate aggregations** to display summaries between grouped levels
* Hiding the **Grand Total** to control overall aggregation visibility
* Enabling **X-axis header groups** to improve structural clarity

Below is a step-by-step tutorial demonstrating how to configure these options 👇

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


---

# Agent Instructions: 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:

```
GET https://docs.gridmate.io/advanced-guides/pivot-grid-advanced-settings.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.