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
