Setting Up Data Area Totals Based on Dimension Levels

Question

How to set up data area totals by dimension levels?

Application Area

Total values can be displayed for any data area. To improve information contents, it is available to display total values associated with dimension levels.

Source Data

Create a data area

The data area looks as follows:

Display the following total values for the presented data:

Solution

Determine parameters for displaying values of data area totals. To do this:

  1. Select any cell in this area and select the Data Area Parameters context menu item.

  2. Go to the Totals > Rows tab in the Data Area Properties dialog box and determine the following parameters:

NOTE. Totals by levels and dimensions are set up similarly to the totals by rows and columns.

  1. Click the OK button to save settings.

  2. To apply the settings, calculate the data area.

After this the data area looks as follows:

To visualize calculated totals, the following formatting is applied:

Thus, data area aggregation by dimension levels has been set up.

See also:

Questions and Answers | Data Area | Data Area Properties