Dataset Totals
Totals are single value column aggregates that live at the top most level or a 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.
Create a Total
-
Open the column view tab 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, select the column Sales Amount. A new column is automatically created, Sales Amount - Sum, which calculates the formula
Sum([Sales Amount]).The column appears in the right hand TOTALS list, its formula is accessible in the formula bar, and the calculated value is displayed under the TOTALS list in the control panel.
Updated 12 days ago