Syntax for aggr( sum(Sales), Region ="Africa")

[#1]

Hi all

What is the "correct" syntax for the following in a Chart Dimension

aggr( sum(Sales), Region ="Africa")

[#2 · Accepted solution]

Aggr(Sum({<Region= {'Africa'}>} Sales), dimension)

Hi Try this

Dimension can be here any dimension from your chart according to which you want to aggregate. It may one or many

[#3]

Many thanks for that.

Worked wonders