Recall previous calculation in Straight Table

Mon, 30 Sep 2013 10:05:05 GMT

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

topic Recall previous calculation in Straight Table in QlikView

Recall previous calculation in Straight Table