> ## Documentation Index
> Fetch the complete documentation index at: https://docs.royaltyport.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Pivot Table Cards

> Cross-tabulated grids with row and column dimensions

Pivot Table cards cross-tabulate your data across two dimensions — one set of dimensions defining the **rows** and one dimension spread across the **columns** — with one or more metrics at each intersection.

## Configuration

| Setting                  | Description                                                                                                                                                                                                             |
| ------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Row dimensions**       | One or more dimensions that define each row (e.g. Recording, Revenue Type, Year)                                                                                                                                        |
| **Column dimension**     | The dimension whose unique values become the column headers (e.g. Accounting Period). Use the **Asc** / **Desc** toggle next to the selected column dimension to control the order column headers appear left to right. |
| **Metrics**              | The values to aggregate at each row–column intersection (e.g. Licensor Revenue, Units)                                                                                                                                  |
| **Rows per page**        | Number of rows shown per page (default 10)                                                                                                                                                                              |
| **Show row grand total** | Toggle a **Grand Total** row at the bottom summing all metrics across columns (on by default)                                                                                                                           |
| **Show column totals**   | Toggle a **Total** column on the right summing all column values per row                                                                                                                                                |

## Sorting

Pivot Table cards have their own sort controls, separate from other card types.

### Column header order

The order column headers appear left to right is controlled by the **Asc** / **Desc** toggle on the selected column dimension in the **Column dimension** picker. Set it to **Asc** to sort column values alphabetically A→Z (or oldest→newest for periods), or **Desc** for Z→A.

### Row and column limits

You can independently limit how many row values and column values are shown. For each row dimension and for the column dimension, you can configure:

| Setting                      | Description                                                                                                    |
| ---------------------------- | -------------------------------------------------------------------------------------------------------------- |
| **Sort metric**              | Which metric to use when selecting the top rows or columns to include                                          |
| **Direction**                | **Descending** (highest first) or **Ascending** (lowest first) when applying the limit                         |
| **Number of rows / columns** | How many unique values to show — choose **Auto** to show all, or a fixed count (5, 10, 15, 20, 25, 50, or 100) |

<Tip>
  Use **Number of rows** limits to focus on top-performing assets or stores without manually filtering, and use **Number of columns** to limit the accounting periods shown.
</Tip>