I have data as below to calculate the Total Amount.
| ID | Amount ID | Amount | Start Date | End Date |
| 800 | 1 | 10855.35 | 3/1/2018 0:00 | 10/31/2018 23:59 |
| 800 | 2 | 11107.8 | 11/1/2018 0:00 | 10/31/2019 23:59 |
| 800 | 1 | 11410.74 | 11/1/2019 0:00 | 10/31/2020 23:59 |
In this FY is from July 1st - June 30th.
Below should be the calculation.
FY for 2019 is July 2018 - June 2019.Based on the start date and End date there are 4 Months in 1st row and 8 months in 2nd row that falls under the 2019 FY.so Expense would be (10,855 * 4) + (11,107*8) = 132,283.
FY for 2020 is July 2019 - June 2020.Based on the start date and End date there are 4 Months in 2nd row and 8 months in 3rd row that falls under the 2020 FY.so Expense would be (11,107*4) + (11,410*8) = 135,717.
I want to show Expense by Year in bar chart.
Thank you much
