PROPORTION — Calculating the Proportion

Version

Application Scenario

You want to calculate the proportion that certain data occupies in the sum of all data.

For example, calculating the proportion of monthly passenger volume in the total annual passenger volume, as shown in the following figure.

Function Description

The PROPORTION function is added in version 11.0.4 to support calculating the proportion of each expanded value in expanded cells relative to the total value.

Note:

The hierarchical coordinate function only supports cell calculations and does not support cross-sheet calculations, watermarks, JavaScript references, or default parameter values.

Function Explanation

(1) Overview

(2) Example

A1 contains sales amounts of each region (vertically expanded), and PROPORTION(A1) represents the proportion of each region’s sales amount in the total sales amount.

Report Creation

Create a general report. The report calculates the proportion of monthly passenger volume in the total annual passenger volume.

Data Preparation

Create a built-in dataset Embedded1, as shown in the following figure.

Report Design

Enter text into cells A1 and B1, drag corresponding data columns to cells A2 and B2, and design the table as shown in the following figure.

Insertion of the Hierarchical Coordinate Function

Enter text in cell C1, and insert the hierarchical coordinate function PROPORTION(B2) in cell C2. This represents calculating the proportion of monthly passenger volume in total annual passenger volume, as shown in the following figure.

Format Setting

Set Format to Percentage for cell C2 , and select #0.00% from the drop-down list, as shown in the following figure.

Effect Display

(1) PC

Save the report and click Pagination Preview. The following figure shows the preview effect.

(2) Mobile terminal

The preview effects on the DataAnalyst app and HTML5 terminal are the same, as shown in the following figure.

Download the completed template by clicking PROPORTION.cpt.