# Grand Total

## Properties Menu - Grand Total <a href="#properties-menu---grand-total" id="properties-menu---grand-total"></a>

Vitara grid chart by default shows ‘Grand Total’ row at the bottom of the visualization. The default function applied is ‘Sum’. However, we can modify the default aggregation function to other functions in the list.

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

Therefore, the term ‘Grand Total’ is just for naming purposes and does not mean it will show only totals. The actual value of the Grand total will be calculated by using the function applied in ‘Value Aggregation’. For example, if we apply ‘Value Aggregation’ function - Max, the grand total will also show the max value among the values. Show/Hide Grand total: If we don’t want to show ‘Grand Total’ row, then we can hide the ‘Grand Total’ row. Click on the ‘Edit’ button select the ‘Grand Totals’ tab and expand the dropdown box select ‘Hide’.

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

Now, you can do the text formatting options and apply background color to the Grand totals row; font family, font size, bold, italic, underline, text color, font alignment and back ground color. Below is the screenshots of ‘Title formatting’ and ‘Value formatting’ of Grand totals editor.

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

<figure><img src="/files/0NlWIs6HdT5lMqVdkSPd" alt=""><figcaption></figcaption></figure>

Examples of screenshots where the text formattings and back ground colors are applied for grand totals.

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

### Grand Total Threshold <a href="#grand-total-threshold" id="grand-total-threshold"></a>

We introduced a feature in Version 5.1.2 that enables users to add ‘thresholds’ to the grand total row. To enable thresholds for grand totals, go to the thresholds tab in the editor window, then pick source and target, then select ‘Grand Total’ from the group option above the source, and apply desired threshold condition.

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

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


---

# 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.vitaracharts.com/grid-microchart-guide/grand-total.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.
