I am making a strainght table which needs to recall previous result in a particular row above if there is any. (The expected result is shown in below example) The Order Count summation is grouped by the 3 dimensions, 'Month', 'Group' and 'Supplier'.
|Month||Group||Supplier||Order Count||Order Count (Previous Year)|
The Row number interval may not be the same in different combinations, I can't work it out by above function.
Can you please kindly advise is there any way to get this achieved?