5 Replies Latest reply: Jan 5, 2014 7:00 AM by Neta Lor RSS

    Help with aggregation of last value of a period in a pivot chart

      Hi,

       

      I have a pivot chart where inventory data is per weekly period but where I want to aggregate up to montly periods.

       

      I would like to be able to collapse the weekly period into montly periods and to see the projected inventory for the last weekly period, not the sum of weekly periods. I guess I need to use firstsortedvalue and aggregation but I did not get this right.

       

      Dimensions:

      PeriodFinishWeek

      PeriodFinishMonth

      ProductType_LN

      ItemNo (Collapsed in the spreadsheet example).

       

       

      See attached excel spreadsheet for illustration.

       

      Thanks in advance,

       

      Regards,

      Freddy