> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://ixopay.ferndocs.com/user-manual/manual/statistics/pivot-table/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://ixopay.ferndocs.com/_mcp/server.

# Pivot Table

> **Full version: not available for Starter and Growth clients**
>
> If you want to get access to all IXOPAY platform features you need to upgrade your plan. Please contact our Support Team in the [IXOPAY Customer Experience Portal](https://ixopay.my.site.com/support) for more information.

## Video: Creating a Pivot Table

![](https://documentation.ixopay.com/manual/assets/ideal-img/preview-vimeo-statistics-reports.238e7ba.480.png)

Learn how to easily create a pivot table.

To customize your pivot table:

1. Navigate to the **Statistics** section, sub-section **Pivot Table**.
2. Before customizing the pivot table, enter **Pivot PreFilters** to define the data available for analysis:
   1. **Choose** **Range/or date:** Select a time period from the drop-down (This month, last month, last 30 days, last 3 months, this and last 3 months, this week, last week, last 7 days, last 14 days), or select a specific date range using the date fields (from-to).
   2. **Time granularity** : year, month, day, hour, only hour, only day of week
   3. Choose whether to **Include Subtenants, Show Test Transactions** , **Show BinDB data**
   4. Select a **Tenant, Merchant, Connector**
   5. Select one or more **Status** and/or **Type**

Filter the data as needed and click on **Apply Filter** to create the pivot table. If you make any subsequent changes to the filter, you need to click on **Apply Filter** to apply your changes to the pivot table.

![Pivot Table](https://documentation.ixopay.com/manual/assets/ideal-img/pivot-table.3007c63.1280.png)Pivot Table

> **Note**
>
> If you do not select a specific **Merchant** as a pre-filter, the pivot table can include multiple merchants. This allows you to display the number of captures, debits and preauthorize transactions that were successful for different connectors, for example. You can still filter out specific merchants by applying filters to the pivot table's criteria (see below).

The data displayed in the pivot table can be further customized. You can determine what data should be included and how to visualize it:

1. **Pivot Table Type** : Select the type of visualization. The following options are available: Table, Heatmap, Row Heatmap, Col Heatmap, Ratio by Row, Ratio by Column, Line Chart, Bar Chart, Stacked Bar Chart, Area Chart, Scatter Chart (see Pivot Table Customization - section A)
2. **Pivot Table Data:** Select which data should be grouped in the pivot table: Count Transactions, Sum Amount, Sum Amount (in Base Currency), Fees, Payout, Success Rate, Success Rate + Count, Success Rate by Volume (see Pivot Table Customization - section C)
3. **Pivot Table Lines/Columns variable** : Drag & drop variables from the list (Section B the Pivot Table Customization screenshot) to section D or E (see Pivot Table Customization screenshot) to add variables as columns or rows respectively. Determine the order in which variables are displayed in the pivot table by dragging them to the desired position, indicated by a box with a dashed outline. The following variables are available: tenantName, merchantName, providerName, adapter, connector, metaConnector, method, type, isRecurring, status, status simplified, currency. baseAmount, feesCurrency, feesEntity, feesDeductsPayout, year, binBrand, binCountry, binLevel, binType
4. **Pivot Table Filter** : Click on a variable to apply a filter to restrict the data displayed in the table. For example, you can choose which merchants to display or filter by transaction status. The variable name is displayed in italics and with a red text to indicate that a filter has been defined.

![Pivot Table Customization](https://documentation.ixopay.com/manual/assets/ideal-img/pivot-table-customization.5891774.1280.png)Pivot Table Customization

After configuring your pivot table, you can save it as a template or download the table in XLS (Excel) format:

* Select **Save State** to save your current configuration as a template. You can choose to either **Save with PreFilters** or **Save without PreFilters**. Enter a name for the template. Once the template has been saved, you can load the template by clicking on **Load State** (see Saved Pivot Template).
* Select **Export** to export the pivot table as an .xls file.

![Saved State](https://documentation.ixopay.com/manual/assets/ideal-img/save-state.dc216a8.1280.png)Saved State![Saved Pivot Template](https://documentation.ixopay.com/manual/assets/ideal-img/saved-pivot-template.d0b32be.1280.png)Saved Pivot Template