# 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.


---

# 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.datasuite.vn/english/features/chart/supported-chart-types/matrix-table.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.