Grid - Display Options - Adding totals to the bottom of a grid (V6.1 Onwards)

For V6.1 the ability to add totals to the bottom of grids was added.

Example:

How to add totals to Grids

• Edit or Create a Grid component in the normal way (Main Menu -> Component Builder).
• Select Display Options icon
• Select the kind of 'Grid Totals' function you would like to display for each column in the grid
  
  
  
  Example:
  
  

Important Note - Averages: The available 'Grid Totals' functions show simple aggregations/calculations based on the data shown in the grid columns. Be careful to note (for example) if a column/measure already contains a complex expression such as an average calculation or percentage etc., the Grid Totals 'Average' function will only show a simple 'average of the averages', which is not a true overall average.