Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
Sum(Aggr(FirstSortedValue(DISTINCT Aggr(sum(QTY), IDPROD,DATEINV) , -DATEINV), WARH, IDPROD, DayInv))