Manage Grand Totals

hila shows a Grand Total as an immediate summary of results data in a fixed row at the bottom of a table, under the following conditions. To ensure the results remain mathematically sound, this row is specifically reserved for monetary values and amounts. To maintain data integrity, the Grand Total is automatically suppressed for percentages, ratios, growth rates, and so on, because summing these metrics would result in inaccurate insights. Additionally, the Grand Total is not displayed if a table has been pivoted or transposed.

Note: the Grand Total reflects only the data currently available in the result table. If a table has reached its row limit, the Grand Total represents the sum of the available rows in the result table, not the absolute total of the entire underlying data source.

Configure Grand Totals

These metadata tags control grand totals:

• exclude_from_total Any columns with names on this list are excluded from grand total calculation. The default value of this list is [“percentage”,”%”,”achievement”,”ratio”].

• no_total_if_multiple If any columns with names on this list has more than one unique value, Grand Totals are not calculated for the entire table. The default value of this list is [“currency”,”account type”].

See Metadata tags for more information on setting these tags.