Problem with Totals using FirstSortedValue and aggr

[#1]

Hi Gurus,

I'm trying to create a pivot table: Dimensions: WARH (warehouse), IDPROD, (product) and DATEINV (date inventory) , period (master dimension year, month, day).

Expression, Stock at the end of Year, Month, Day: FirstSortedValue(DISTINCT Aggr(sum(QTY), IDPROD,DATEINV) , -DATEINV)

Details are OK but the total is not correct:

Year

Month

Day

Thanks in advance,

Juan

[sunny_talwar]

May be this:

Sum(Aggr(FirstSortedValue(DISTINCT Aggr(sum(QTY), IDPROD,DATEINV) , -DATEINV), WARH, IDPROD, DayInv))