BI Tool Summarize By

Properties > Main Level Settings > Summarize tab

Properties > Details Setting > Summarize tab

 

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

 

In the example shown in Figure 154, the options selected in Figure 153 are indicated. By contrast, in Figure 150, no Summarize By options were selected for this report.

 

A screenshot of a computer

Description automatically generated

Figure 154: Summarize By option selected.