Total and Subtotals

1. Totals

The totals can be viewed under the Totals Tab in toolbar.

_{Options under Totals}

1.1 Row Grand Total and Subtotal

You can choose to display the grand total of the rows or the subtotal of hierarchical rows either at the top of the rows or at the bottom of the rows by selecting the Top or Bottom option. You can even hide it by selecting the off option. In addition, row Subtotals can be split using the split option.

_{Row Totals and Subtotal at the Top and Column Totals and Subtotal at the Right}

1.2 Split in Row Subtotal

You select the split option to view the subtotal of each sub-section separately.

_{Subtotal of Apac and EU is Split View}

1.3 Column Grand Total and Subtotal

You can choose to display the column grand totals or the subtotals either at the right end of the columns or the left end by selecting the 'Left' or 'Right' option. You can even choose to hide it by selecting the 'Hide' option.

_{Row Total and Subtotal at the bottom; Column Total and Subtotal at Left}

2.Freeze

Freeze 'On' option enables you to freeze the Grand Total either at the 'Top' or 'Bottom' of the Row.

_{Freeze 'On' when Row Grand Total at 'Top'}