Overview
Version
| Report Server Version | Version Description |
|---|---|
11.0 | / |
Level-by-level average is the average obtained by adding up the data from the first level to the current level in each group of group reports, namely, the accumulative average of the current level. Compared with the level-by-level average, cross-level average does not separately calculate the average for each group, but sums up the cumulative result of the previous group and calculates the average from the second group.
Cross-Level Average Previw
Vertical Cross-Level Average
Report Opening
Open the required report.
Average Calculating
Method 1:
In cell E3, enter the average formula = (IF(&B3 > 1, D3[B3:-1], D3[A3:-1,B3:!-1]) + C3) / seq(), as shown in the following figure.
The following table describes the formula.
| Formula | Description |
|---|---|
(IF(&B3 > 1, D3[B3:-1], D3[A3:-1,B3:!-1]) + C3) | Represents the cross-level accumulation value. |
seq() | Returns the number of executions (as the denominator) for which the function has been executed during the entire report execution process. |
Method 2: (Only applicable for versions before 11.0.4)
In cell E3, enter the level-by-level accumulation formula =LAYERTOTAL(B3, C3, D3) / seq() or =(IF(&B3 > 1, D3[B3:-1], D3[A3:-1,B3:!-1]) + C3) / seq().
Effect Preview
On PC
Save the template and click Pagination Preview. The effect is shown in section "Preview."
On Mobile Terminals
The preview effect on the app/HTML5 terminal is the same, as shown in the following figure.
Horizontal Cross-Level Average
Report Opening
In cell B6, enter the average formula = (IF(&B3 > 1, B5[;B3:-1], B5[;B2:-1,B3:!-1]) + B4) / seq(). Both Left Parent Cell and Up Parent Cell of cell B6 are set to Default, with Expansion Direction as Horizontal.
The following table describes the formula.
| Formula | Description |
|---|---|
(IF(&B3 > 1, B5[;B3:-1], B5[;B2:-1,B3:!-1]) + B4) | Represents the cross-level accumulation value. |
seq() | Returns the number of executions (as the denominator) for which the function has been executed during the entire report execution process. |
Effect Preview
On PC
Save the template and click Data Analysis Preview. The effect is shown in section "Preview."
On Mobile Terminals
The preview effect on the app/HTML5 terminal is the same, as shown in the following figure.
Template Download
Cross-Level Average-Vertical
For details, you can click to download Cross-Level Average-Vertical.cpt.
Cross-Level Average-Horizontal
For details, you can click to download Cross-Level Average-Horizontal.cpt.
