How to Display Total Sales Amount and its Percentage in a Bold BI Dashboard

This article explains how to design a Bold BI Dashboard with the sales amount and its corresponding percentage value.

To display the sales amount and its percentage value in a Bold BI Dashboard, follow these steps:

Step 1: Calculate the Total Records in the Column

Create an expression to calculate the total records in the column.

Total = TOTAL(SUM([Column_Name]))

Step 2: Calculate the Sum of the Column

Create an expression to calculate the sum of the column.

Sum Value = SUM([Column_Name])

Step 3: Calculate the Total Percentage

Create an expression to calculate the total percentage of the sales amount.

Total percentage = ([Sum Value] / [Total]) * 100

By following the provided steps, users can create a calculated field that calculates the total percentage for each sales amount value in the Bold BI Dashboard.

Additional References

• Configure Expression Columns