Quick Calculation - Percentage

Application Scenario

The function can be used when you need to calculate the proportion of the data in chart or table components.

For example, you may need to calculate the proportion of the sales volume in each region and area to the total, as shown in the following figure.

Function Description

You can use the Percentage function in Quick Calculation.

Note:

This function cannot be used in detail tables.

You can download the example data.Store Sales Data.xlsx

Concept

The Percentage function is to calculate the percentage of the current dimension data out of the total sum of all dimension data in the indicator, indicating the percentage of a single value out of the total value of the indicator.

For example, you may want to display the proportion of sales volume of each General Region and view the sales volume of each Specific Area when all region nodes are expanded, as shown in the following figure.

Percentage Calculation

1. Use Store Sales Data to create a group table, as shown in the following figure.

2. Click the icon of the Sales field and choose Quick Calculation > Percentage.

Percentage Calculation Using Functions

In addition to the Quick Calculation function, you can also use the following formula for percentage calculation.

SUM_AGG(Contract Amount)/TOTAL(SUM_AGG(Contract Amount))

Concept

The In-Group Percentage function is to calculate the percentage of current dimension data to the total sum of the current group.

For example, you may want to display the proportion of the sales volume of each General Region and view the proportion of the sales volume of each Specific Area in each region to the corresponding General Region when all region nodes are expanded, as shown in the following figure.

Percentage Calculation

1. Use Store Sales Data to create a group table, as shown in the following figure.

2. Click the icon of the Sales field and choose Quick Calculation > In-Group Percentage.

In-Group Percentage Calculation Using Functions

In addition to the Quick Calculation function, you can also use the following formula for in-group percentage calculation.

SUM_AGG(Contract Amount)/TOTAL(SUM_AGG(Contract Amount),1)