1 Reply Latest reply: Aug 9, 2016 7:11 PM by Sunny Talwar RSS

    Problem with Totals using FirstSortedValue and aggr

    JUAN GONCALVES

      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

      CaseFirstSortedMonth.jpg

      Month

      CaseFirstSortedYear.jpg

      Day

      CaseFirstSortedDay.jpg

      Thanks in advance,

      Juan