Aggregate AT

This function aggregates columns based on the level or levels you specify.

Syntax: AGGREGATE(measure AT level [, level1, levelN])

Syntax description:

Measure is the name of a measure column.

Level is the level at which you want to aggregate. You can optionally specify more than one level.

Steps: 

Go to Criterial – Select the Column – Right Click – Select Edit Formula – Click on Insert function – click on Aggregate folder and select Aggregate At 

Example: AGGREGATE("Sales"."Rp Revenue" AT "Date (Common)"."Year")