> For the complete documentation index, see [llms.txt](https://docs.powerviz.ai/powerviz/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.powerviz.ai/powerviz/heatmap/advanced-settings-introduction/totals.md).

# Totals

The Totals feature in Powerviz heatmaps allows you to display aggregated sums or averages for rows and columns. This setting provides a quick overview of overall data trends and totals, aiding in summary analysis and comparison.

### Row Total

#### Label

* Label Name: Enter a name for the row total label.
* Font Family: Choose the font family for the label text.
* Styling: Apply styling options such as Bold, Italic, and Underline.
* Text Size: Set a custom font size for the label text.
* Label Color: Select the color for the label text.

#### Show Bar

* Enable Setting: Turn on this setting to display bars representing the total values.
* Bar Representation: Choose to display bars by percentage of maximum value or percentage of total.

#### Color Palette

Select a color palette for the total bars. Options include:

* Single
* Gradient
* Sequential
* Diverging
* Qualitative

#### Show Values

* Enable Setting: Turn on this setting to display values on the total bars.

Value Representation: Choose how to show the values:

* Absolute
* Average
* % of Total
* % of Max

#### Formatting options

* Auto Font Size: Disable to set a manual font size for values.
* Font Family: Choose the font family for the values.
* Styling: Apply text styling options such as Bold, Italic, and Underline.
* Text Color: Select the color for the value text.
* Text Background Color: Choose a single color or gradient for the background of the text.

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

### Column Total

#### Label

* Label Name: Enter a name for the column total label.
* Font Family: Choose the font family for the label text.
* Styling: Apply styling options such as Bold, Italic, and Underline.
* Text Size: Set a custom font size for the label text.
* Label Color: Select the color for the label text.

#### Show Bar

* Enable Setting: Turn on this setting to display bars representing the total values.
* Bar Representation: Choose to display bars by percentage of maximum value or percentage of total.

Color Palette

Select a color palette for the total bars. Options include:

* Single
* Gradient
* Sequential
* Diverging
* Qualitative

#### Show Values

* Enable Setting: Turn on this setting to display values on the total bars.

Value Representation: Choose how to show the values:

* Absolute
* Average
* % of Total
* % of Max

#### Formatting Options

* Auto Font Size: Disable to set a manual font size for values.
* Font Family: Choose the font family for the values.
* Styling: Apply text styling options such as Bold, Italic, and Underline.
* Text Color: Select the color for the value text.
* Text Background Color: Choose a single color or gradient for the background of the text.

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

Example

<figure><img src="/files/8ZXTOIdkZ6W0XalXfCJy" 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 dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.powerviz.ai/powerviz/heatmap/advanced-settings-introduction/totals.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.