Aggregate

[niranjana]

Hi,

I need help in framing an aggregate function within set analysis within Sum function:

aggr(Sum({<Year={"$(=Year(Max(Date)))"},Month={"<=$(=Num(Month(Max(Date))))"}>}New_Sales),Product,Pack,Distributor,ATC4,[Ret/Hosp]). 

But it is not working. I need to sum the "New_Sales" within the set analysis and aggregate that sum with dimensions Product, Pack,Distributor, ATC4, Ret/Hosp. This expression is used in a straight table. 

Only aggregate part is throwing error.

Dimension is Product and measure is New_Sales as shown above

Any help is appreciated.

[chris_djih]

which error does it throw?

[niranjana]

it shows zero or dash.

Thanks