# Totals & subtotals

Be it a typical table or a hierarchical matrix style report in Power BI, Inforiver allows you to seamlessly manage subtotals and grand totals in a couple of clicks.

{% embed url="<https://lumel.wistia.com/medias/zhxhi6ndv3>" %}
Totals & subtotals - Overview
{% endembed %}

In this example, we have hierarchies across both rows & columns.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FJabS975KvgRenB0ob8VJ%2F2.4.3.1%20Data.png?alt=media&#x26;token=12dbfc6e-1427-4e9b-88cc-5b5e8527310d" alt=""><figcaption><p>Matrix with row and column hierarchies</p></figcaption></figure>

Note that

(a) the row subtotals (United States & International) are at the top, and

(b) the row grand total is the top&#x20;

(c) there are no subtotals and grand totals for columns.

### 1. Customization options

Let us take a look at the customization options available in Inforiver.&#x20;

Click on the 'Totals' option in the Home tab Analyze section. There are options to enable/disable subtotals and totals and to change the positions.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FVYV8jcaVxQIVfPWZhngW%2F2.4.3.2%20Totals%20menu.png?alt=media&#x26;token=511c5251-fc36-49b0-9ecc-7941cdefeaac" alt=""><figcaption><p>Customization options for totals and subtotals</p></figcaption></figure>

{% hint style="info" %}
Row or/and column subtotals will appear only if there is a hierarchy in the row or/and column fields.
{% endhint %}

Let us make some changes as shown below. The corresponding changes in the matrix are highlighted in red.&#x20;

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FqMuANzpoo2zCK9fLJxN4%2F2.4.3.3%20Updated%20totals.png?alt=media&#x26;token=34d83b41-04ba-41f2-b7ba-476fcd98bee8" alt=""><figcaption><p>Changes to subtotals and totals</p></figcaption></figure>

In the row subtotal section, you can see an option called 'Split'. Enable this and disable both the grand totals and the column subtotal.

Let us now look at the United States. There is a header row with no values, followed by a set of records. At the end of this section, the records are totalled.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F96H6c6uNUzA7TUdZ23Kw%2F2.4.3.4%20Split%20row%20subtotals.png?alt=media&#x26;token=906b4ee2-0db9-4927-aa7f-c87278b8c45a" alt=""><figcaption><p>Split row subtotals option</p></figcaption></figure>

### 2. Freeze totals

When **pagination is turned off**, you have the option to freeze totals.&#x20;

{% hint style="info" %}
It is not possible to freeze totals when using the 'Drilldown' layout&#x20;
{% endhint %}

To turn off pagination, in the 'Design' tab, click on 'Single page'.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2Fc7HrZDkR1ViBsOYMQDoR%2F2.4.3.5%20Freeze%20totals.png?alt=media&#x26;token=3942e6e9-1bfe-4104-b24e-7d5fc3685184" alt=""><figcaption><p>Pagination turned off</p></figcaption></figure>

In the 'Totals' menu, you can now see an option to freeze the total.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FRyrWhEpZckhpbMwxG4BL%2F2.4.3.6%20Freeze%20totals.png?alt=media&#x26;token=ef39f47f-c5c2-4854-97ad-c5e2209606ea" alt=""><figcaption><p>Freeze total</p></figcaption></figure>

On selecting 'On', you can see that the grand total row is frozen on the top. You can also freeze it at the bottom by selecting 'Row grand total' as 'Bottom' and 'Freeze total' as 'On'.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FP77wNXcqGJAanJESdWvi%2F2.4.3.7%20Freeze%20totals.png?alt=media&#x26;token=81890608-f578-48f3-83a7-ccf05f207ec9" alt=""><figcaption><p>Grand total row frozen</p></figcaption></figure>

In summary, Inforiver allows you to manage row & column subtotals & grand totals the way you want in an intuitive & flexible manner.

In the next section, we'll be covering [inserting empty rows](https://docs.inforiver.com/working-with-inforiver/2.-displaying-information/basic-formatting/insert-blank-rows).

#### Resources

[Manage totals & subtotals in Power BI](https://inforiver.com/blog/general/managing-totals-subtotals/)