Other methods to set row aggregation

1. Setting aggregation from manage columns

Another way to set row aggregation for measures is by clicking on Manage Columns and then the icon. This allows you to manage row aggregations for specific measures.

Settings in 'Manage Columns' dropdown

A pop-up displays a list of measures under the Display section. You can change the aggregation type of multiple measures here.

Manage columns pop-up

You cannot set aggregation for a simulation measure.

Note that the row aggregation type for calculated columns and manual data input columns can also be defined here in the Manage Columns dialog box in addition to the Insert formula and Data input side panels.

Setting row aggregation in side panel

2. Setting aggregation from column gripper

To set aggregation for a specific measure, you can also click on that column's gripper and choose 'Aggregation' from the context menu as shown below. Click on the required aggregation type to apply it to that measure.

Set aggregation from the column gripper