how to handle year-2-year report

[#1]

Dear Experts,

I have to work out a table including the value of last fiscal year and this fiscal year with month basis. Could you pls help ?

Example:

Date	Product	SalesValue
2015-04-26	Keyboard	10,000
2015-07-15	Keyboard	15,000
2015-10-11	Keyboard	12,400
2015-12-10	Keyboard	16,300
2016-04-21	Keyboard	11,300
2016-05-20	Keyboard	14,100

Fiscal Year scope :

FY1415: 2014-10-01~2015-09-30

FY1516: 2015-10-01~2016-09-30

Expecting Result:

1) when select 'FY1516' , April,  get result like below:

Product	Month	SalesValue(CurrentFiscalYear-FY1516)	SalesValue(PreviousFiscalYear-FY1415)
Keyboard	04	11,300	10,000

2) when select 'FY1415' , July get result like below:

Product	Month	SalesValue(CurrentFiscalYear-FY1415)	SalesValue(PreviousFiscalYear-FY1314)
Keyboard	07	15,000	0

Thank you!

Regards,

Jessica