# Grouping Options

This section allows you to configure how grouped rows behave in Finance Tables.

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

**Grand totals**

* **Enable a 'grand' total across all groups:** Show a grand total row across all groups.
* **View grand total at the top of the table:** Show the grand total at the top instead of the bottom.

**Grouping behaviour**

* **Use multiple columns for grouping:** Use multiple columns for grouping instead of a single grouped column.
*

```
<figure><img src="/files/3v9whksD0xnjPgH16go4" alt=""><figcaption></figcaption></figure>
```

* **When group is expanded, hide the parent row:** Hide the parent row when a group is expanded.
* **Show opened group names on the rows below:** Show the name of the opened group on the rows below it.
* **Show expand/collapse controls for pivoted columns:** Show chevrons for pivoted column groups so users can expand or collapse them.

**Group totals**

* **View group totals within each group level at the bottom:** Show totals at the bottom of each group.
* **Combine group header with group total (at group bottom):** Show one combined row at the bottom of each expanded group instead of a separate group header row and total row.
* **View total at the top of the group:** Show the group total above the group instead of below it.

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

**Sticky grouping**

* **Enable sticky group rows:** Keep group rows visible whilst scrolling.
* **Enable sticky group total rows:** Keep group total rows visible whilst scrolling.

Some grouping options depend on each other. For example, hiding the parent row is not available when sticky group rows or sticky totals are enabled.

**Other grouping settings**

* **Hide the number of rows counter behind a group row:** Hide the number of rows shown next to a grouped row.
* **Show aggregation function in header:** Show the aggregation function in the column header.
* **Automatically expand grouped rows:** Automatically expand grouped rows when the table loads.
* **Expand all but the last N groups:** Expand all grouped levels except the last N levels.
* **If group value is null or blank replace with:** Replace empty or null group values with a custom value.


---

# 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.infotopics.com/finance-tables/configuration/configuration-screen/appearance-tab/grouping-options.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.