2 Replies Latest reply: Apr 20, 2017 2:14 AM by Sander Gardenier RSS

    First numeric value in table

    Michiel van de Goor

      Hi, I need to find the first value in a table:

       

      The table consists of these dimensions:

      • ProductID
      • reporting month
      • country

      Fact:

      • Amount

       

      And the values are a running sum where the first value is the start value.

       

      I want to calculate the monthly difference which is easy but I do not get the starting value for each ProductID, reporting month etc. right. I keep on finding the first value of the total table or the last value of the previous product etc.

       

      I tried previous functions, min(reporting month) in group by, peek etc but no luck so far.