How to Calculate Percentage for Each Row Based on Total Actual Value
Calculating the percentage for each row based on the total actual value is a common requirement in data analysis and reporting. This can be achieved by creating an expression that computes the percentage for each row relative to the total value. Below are the steps to configure such an expression within a grid widget in Bold BI.
Step 1: Create an Expression
To calculate the percentage for each row, you need to create an expression that will perform this calculation on your data table column.
Expression Condition: TOTALPERCENTAGE([DataTable_Column])
For example, if you want to calculate the percentage based on the 'Quantity' column in your data table, your expression would look like this:
TOTALPERCENTAGE([Quantity])
Step 2: Configure the Expression Field
Once you have created the expression, the next step is to configure the expression field within your grid widget. This involves adding the expression to the grid so that it can display the calculated percentages.
Step 3: Render the Grid Widget
After configuring the expression field, the grid widget will now render the data along with the calculated percentages for each row as per your requirement.
By following these steps, you can easily display the percentage each row represents of the total actual value within your data set.
Additional References
For more information on creating expressions and configuring grid widgets, you may refer to the following resources:
