Reporting Service Application tips (2)-Use of the subtotal function in the Matrix

When using reporting service to create reports, we often encounter reports in the following format:

In general, we can easily add subtotal for the row group to perform the total operation. However, the default aggregate formula of Reporting Service is cumulative calculation. When our report has such an indicator as the change rate, you cannot use the accumulate calculation.

First of all, we need to know that the sum in the control in the Reporting Service matrix is calculated based on the formula in the data area. When we add a field to the data area, the sum () function is used by default, therefore, we only need to change the calculation formula of the data area so that this column can use our custom formula to calculate the total value.