Why there is no total on the chart for the sample model.

[suvechha_b]

Hi,

See the attachement.

[tamilarasu]

Hi,

You need to add sum function in front of the aggr function. Use below expression.

=Sum(Aggr( Sum(sales_plan), [Division Code],[Product Code] ))

[trdandamudi · Accepted solution]

May be as below:

Expression: JE Forecst Units

=Sum(Aggr( Sum(sales_plan), [Division Code],[Product Code] ))

Or

=Sum({<[Division Code],[Product Code] >} sales_plan)

[MK_QSL]

You need to use SUM (Aggr(Your Expression, Dim1, Dim2, Dim2))