Adding values of latest 3 dates and comparing it with sum of previous 3 dates

[ameydiwanji]

Hi All,

Can some one help me on below:

I have date wise values for one month and this table keeps on updating on daily basis. Now i want to add the values of latest 3 dates and compare it with the sum of next 3 dates. How to do that?

For example:

	F	E	D	C	B	A	Expected Result	Expected Result
	31/08/2018	30/09/2018	31/10/2018	30/11/2018	31/12/2018	31/01/2019	sum(A+B+C)	sum(D+E+F)
Product A	50	20	10	29	73	87	189	80
Product B	10	98	20	40	74	20	134	128

Many Thanks in advance