> For the complete documentation index, see [llms.txt](https://docs.datasuite.vn/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.datasuite.vn/english/features/chart/supported-chart-types/matrix-table.md).

# Matrix Table

A **Matrix Table** is a data visualization tool that allows you to display information across multiple dimensions. Unlike regular Data Tables, which present data in flat rows and columns, a Matrix Table enables the arrangement of dimensions along both rows and columns, with **measures** placed at their intersections. This creates a grid-like layout where each cell shows an aggregated value based on the combination of row and column dimensions.

#### Components of the View Matrix Table Interface

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

1. **Title**: The name of the Matrix Table.
2. **Columns**: Dimensions and/or measures displayed horizontally.
3. **Rows (Data rows)**: Dimensions displayed vertically, with support for hierarchical **expand/collapse** functionality.
4. **Totals**: Aggregated values displayed at the bottom of columns and at the end of rows.
5. **Row Pagination**: Splits the vertical data when there are too many rows to display at once.
6. **Column Pagination**: Splits horizontal data when there are many columns or measures.

#### Functions in the View Matrix Table

* **Expand/Collapse Rows**: Allows you to explore data at different levels of hierarchy for a more detailed or summarized view.
* **Vertical Paging**: Navigate through multiple row groups when the table contains a large dataset.
* **Horizontal Paging**: Navigate through column groups when many dimensions or measures are displayed.
* **Sort Axis**: Sort the table based on the values of any row dimension or measure:
  * **Ascending**: From smallest to largest (e.g., A–Z, 1–100, oldest to newest).
  * **Descending**: From largest to smallest (e.g., Z–A, 100–1, newest to oldest).
* **Refresh**: Reloads data from the source to reflect the most up-to-date values.
* **Hard Refresh**: Performs a full data reload by bypassing any cached data, ensuring everything is retrieved fresh from the original source.
* **Export File**: Allows users to download the current data in `.xlsx` format. The system supports exporting up to **50,000 rows** per file.

Click the **menu icon** in the top-left corner of the table to access additional supported functions.