This content has been marked as final. Show 2 replies
Hi, I need to find the first value in a table:
The table consists of these dimensions:
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.