Hi,
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) |
Jan-2012 | Menswear | ABC Co.Ltd. | 10 | - |
Mar-2012 | Menswear | ABC Co.Ltd. | 11 | - |
Jan-2012 | Menswear | DEF Co.Ltd. | 12 | - |
Jan-2013 | Menswear | ABC Co.Ltd. | 20 | 10 |
Apr-2013 | Menswear | ABC Co.Ltd. | 21 | - |
Jan-2013 | Menswear | DEF Co.Ltd. | 22 | 12 |
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?
B.Rgds,
Hasson