How to Seperate Amount between two given dates and sharing the amount equally between qtrs
I am new to QS and looking for some suggestions here.
I have a requirement a start date and end date fields and i need to generate quarters between these two dates and divide the amount equally between these quarters.
I want to First Generate Quarters between these two dates. After generating quarters i want to sum up the each Qtr share for these 5 IDs and want to know how much i will be paying out each qtr. (like forecasting. )
Also Please help me on how to show this in a line chart
I need the Quarter to be shown up as header linke Q3 2019,Q4 2019,Q1 2020,Q2 2020 and below the amounts. I think we need to do this using pivot table so that the amounts can be seperated by each qtr. But i need to total payout of each qtr. Because each qtr payout will be different as they start at different dates