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 144: Summarize By tab

 

In the example shown in Figure 145, the options selected in Figure 144 are indicated. By contrast, in Figure 141, no Summarize By options were selected for this report.

 

A screenshot of a computer

Description automatically generated

Figure 145: Summarize By option selected.