There are many options to manage totals and subtotals in the visual.

With Total feature, you can do the following –

• Manage Grand Totals
• Manage Subtotals
• Split subtotal from parent row

Related Links

Group

Top N

Pagination and Breaks

Manage Grand Total

Follow these steps to customize row/ column grand total –

1. To turn on the row or/and column grand total, click on Total under Home tab, turn on Show row grand total or/and Show column grand total.

   

   

   Grand total enabled

   

By default, row grand total appears on top, and column grand total appears in right.

1. To change the positions of grand totals, click on Position(s) under Total. This will pop up Positions box.

   

   

   Customize the total and subtotal positions

2. In Positions, under Row, tick/ select Bottom for Grand Total. Under Column, tick/ select Left for Grand Total.

   

3. Click Apply to save the changes made to row and column grand total positions. Now you can see that the grand total positions have changed as applied.

   

   Grand Total Positions changed

4. In the positions box, turn off the Grand Total for Row and Column.

   

   Turning off Grand Total

Manage subtotal

<aside> 💡 Note: Row or/and column subtotals will appear only if there is hierarchy in row or/and column.

</aside>

You can turn off or customize the position of the subtotals. By default, row subtotal appears on top and column subtotal appears in right.

1. To turn off/ change positions of row or/and column subtotals, click on Position(s) under Total. This will pop up Positions box.

   

2. Follow this to turn off the subtotals - In Positions, under Row, tick/ select Off for Subtotal. Under Column, tick/ select Off for Subtotal. Click on Apply to save the changes.

   

   

3. Similarly, if you want to change the positions of subtotals (Follow Step 1). Then in Positions box, under Row, tick/ select Bottom for Subtotal. Under Column, tick/ select Left for Subtotal. Click on Apply to save the changes.

   

   

Now in the visual you can see row subtotal in the bottom and column subtotal on the left.

Split subtotal from parent row

Inforiver visual also allows you to split the subtotal from parent row. This will move row subtotal to the bottom position and the subtotals of each parent will automatically have their respective total headers.