> For the complete documentation index, see [llms.txt](https://docs.vitaracharts.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.vitaracharts.com/grid-microchart-guide/grand-total.md).

# 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="https://230207405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOuiTPVEbVQnzR38vviPf%2Fuploads%2FiGKQibpysgCG28ciwRUL%2Fimage47.png?alt=media&amp;token=4c7c348b-f1c3-4c87-a4c6-b67ac5acff0f" 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="https://230207405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOuiTPVEbVQnzR38vviPf%2Fuploads%2FLvShcSkbb69cpfvpYzLx%2FGT1.png?alt=media&amp;token=03292c1c-f3e6-4555-9db8-cf05c2cc3a0c" 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="https://230207405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOuiTPVEbVQnzR38vviPf%2Fuploads%2FGNLl7ftfW0TYOZCmifYJ%2FGT2.png?alt=media&amp;token=233471d7-db27-4388-814a-cea444621390" alt=""><figcaption></figcaption></figure>

<figure><img src="https://230207405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOuiTPVEbVQnzR38vviPf%2Fuploads%2FN9LcsFeKmIRxwByKXECd%2FGT3.png?alt=media&amp;token=46db9a3c-1a4d-49c0-83dd-d6885f195655" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://230207405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOuiTPVEbVQnzR38vviPf%2Fuploads%2FPaR7eDnqBtL2dmWKej4h%2FGT4.png?alt=media&amp;token=e28128e2-73b9-4baf-8af0-9b53ca56d4db" 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="https://230207405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOuiTPVEbVQnzR38vviPf%2Fuploads%2FIppLZa8KBjlRcGB4UEzF%2FGT1%20(1).png?alt=media&amp;token=6642eeda-cf4e-48e2-ab85-d803c56a487e" alt=""><figcaption></figcaption></figure>

<figure><img src="https://230207405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOuiTPVEbVQnzR38vviPf%2Fuploads%2F1twweRXNeMNW7gDAP3Xk%2FGT2%20(1).png?alt=media&amp;token=8752ba0d-e507-479b-8cf7-8b0ad6a21440" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.vitaracharts.com/grid-microchart-guide/grand-total.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
