Return Accruals
Hello Everyone,
I would like to write a plsql which return complete table and same insert into a separate table, the available data which i have is as bellow:
I am attaching my working sheet, in first sheet mention my available data and in second sheet green highlighted fields my desire results.
Income | Disbursement Date | 18-Dec-17 |
---|---|---|
1,266,666.67 | Rental Dates | 18-Mar-18 |
1,232,432.43 | 18-Jun-18 | |
1,198,198.20 | 18-Sep-18 | |
1,163,963.96 | 18-Dec-18 | |
1,129,729.73 | 18-Mar-19 | |
1,095,495.50 | 18-Jun-19 | |
1,061,261.26 | 18-Sep-19 | |
1,027,027.03 | 18-Dec-19 | |
992,792.79 | 18-Mar-20 | |
958,558.56 | 18-Jun-20 | |
924,324.32 | 18-Sep-20 | |
890,090.09 | 18-Dec-20 | |
855,855.86 | 18-Mar-21 | |
821,621.62 | 18-Jun-21 | |
787,387.39 | 18-Sep-21 | |
753,153.15 | 18-Dec-21 | |
718,918.92 | 18-Mar-22 | |
684,684.68 | 18-Jun-22 | |
650,450.45 | 18-Sep-22 | |
616,216.22 | 18-Dec-22 | |
581,981.98 | 18-Mar-23 | |
547,747.75 | 18-Jun-23 | |
513,513.51 | 18-Sep-23 | |
479,279.28 | 18-Dec-23 | |
445,045.05 | 18-Mar-24 | |
410,810.81 | 18-Jun-24 | |
376,576.58 | 18-Sep-24 | |
342,342.34 | 18-Dec-24 | |
308,108.11 | 18-Mar-25 | |
273,873.87 | 18-Jun-25 | |
239,639.64 | 18-Sep-25 | |
205,405.41 | 18-Dec-25 | |
171,171.17 | 18-Mar-26 | |
136,936.94 | 18-Jun-26 | |
102,702.70 | 18-Sep-26 | |
68,468.47 | 18-Dec-26 | |
34,234.23 | 18-Mar-27 |
The result which i want to extract in table from my saved data is as bellow: