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.
