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

 

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

 

A screenshot of a computer

Description automatically generated

Figure 151: Summarize By option selected.