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?
