BI Tool Summarize By

 

The Summarize By option will allow you to set up various total calculations. The options available to Summarize By are called “Buttons” and show as grey rectangles. When clicked, the buttons will turn blue. The type of calculation used is dependent on field type.

 

§ Count - Available in all types of fields

§ Min and Max  - Used in numeric and date fields

§ Avg -  Only available for numeric fields

§ Total -  Only available for numeric fields

 

Be sure to click the checkmark in the upper right corner to save the settings.

 

A screenshot of a computer

Description automatically generated

Figure 124: Summarize By tab

 

In the example shown in Figure 125, the options selected in Figure 124 are indicated. By contrast, in Figure 121, no Summarize By options were selected for this report.

 

A screenshot of a computer

Description automatically generated

Figure 125: Summarize By option selected.