Setting an aggregate function for a column

Setting an aggregate function for a table column allows you to get a single value on the upper grouping level by performing a certain operation on the values of the lower grouping levels.

For example, you can set up a table that displays Available inventory amount with additional details on each facility Type and offered Product:

If you group the table data by Product, the upper level of the table will contain one grouping entry for each Product. The lower level of every grouping entry will contain the entries for each available Type. Note that the lower level entries display the Available inventory amount values in the Value column, but the upper level entries do not:

Setting an aggregate function for the Value column will allow you to view the Available inventory amount values on the upper grouping level. 

To set an aggregate function for a column

  1. Right-click the title of the column you wan to set an aggregate function for and select the desired function from the shortcut menu:


    The following aggregate functions are available:

If you set the Sum aggregation function for the Value column, you will get the Available inventory amount value calculated for each Product as the sum of individual Available inventory amount values for each Type:

If you set the Mean aggregation function for the Value column, you will get the Available inventory amount value calculated for each Product as the average of individual Available inventory amount values for each Type:



 

Related topics

Hiding / Showing table columns 

Grouping / U|ngrouping table records

Rearranging table columns