Worksheet Totals are single value column aggregates that live at the top most level or a worksheet. Worksheet totals can be created in your worksheet’s right hand panel, under the column view tab. The calculated total values will then be displayed in the worksheet’s control panel.
Creating a Total
Navigate to the column view panel in your worksheet’s right hand panel.
Under the TOTALS section, click on 'New Total...'
Select a column from the list to automatically create a recommended aggregate total. Or select
‘Add Empty Column’ to write your own formula.
For this example, we will select the column [Quantity]. This will automatically create a new column [Quantity - Sum], which calculates the formula Sum([Quantity]).
The column will appear in the right hand TOTALS list, its formula will be accessible in the formula bar, and the calculated value will be displayed under the TOTALS list in the control panel.