How to Add Summary Rows in Grid Widget in Bold BI

Summary rows are a useful feature in grid widgets that allow you to display summarized data based on specific criteria. This article will guide you through the process of adding summary rows ( such as Sum, Average, Minimum, Maximum, Count, Distinct Count, and Custom expressions) to your grid widget in Bold BI.

Steps to Add Summary Rows

1. Enable summary row: Locate and check the box to enable the summary row feature. This will open the Summary Row dialog.
   

   

2. Customize summary row: Click the “Customize” button in the Summary Row dialog to customize the appearance and behavior of the summary row.
   

   

3. Add summary: Click “Add Summary” in the top right corner of the dialog to add a new summary row.
   

   

4. Choose summary type: Select the desired summary type from the available options: Sum, Average, Minimum, Maximum, Count, Distinct Count, and Expression (for custom expressions).
   

   

5. Customize summary text: Use the text box to customize the text displayed in the summary row.
   

   

6. Show or hide value: Toggle the “Show value” property to hide or display the summary value. You can also customize the value color using the color picker.
   

   

7. Apply measure formatting: Click the settings button to apply measure formatting for the summary row.
   

   
   
   
   

8. Add expression: To add a custom expression, select “Expression” from the dropdown menu. An expression icon will become visible, allowing you to input your custom expression.
   

   
   
   
   
   
   
   

Example

By following these steps, you can easily add summary rows to your grid widget in Bold BI and customize them to suit your needs.