Skip to main content
Pentaho Documentation

Apply a Summary Function

You can assign a summary function to columns that contain numeric values in your report. A summary function is a summarization technique that performs calculations on values in columns, groups, or in the entire report.

  1. Click the down arrow next to a report column that contains numeric values.
  2. Select Summary from the menu, then choose the summary type.
    Function Name Description
    None No summary function assigned
    Average Calculates the average value in a given column
    Count Counts the items in a group or report, but does not require a numeric value.
    Count Distinct Counts the distinct occurrences of a certain value in a column; does not require a numeric value
    Max Identifies the highest or largest value in a column
    Min Identifies the lowest or smallest value in a column
    Sum Calculates a total sum of the group or report (group level, and running total in the report footer)

    The numeric values in the column update.

  3. Save the report.