Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is my example data
ID | Date | Amount |
1 | 2020-05-10 | $150.00 |
1.1 | 2020-06-11 | $900.00 |
1.2 | 2020-05-12 | $200.00 |
1.3 | 2020-07-13 | $18.00 |
1.4 | 2020-05-14 | $500.00 |
1.5 | 2020-06-15 | $1000.00 |
ID | MonthYear | Sum(Amount) |
1 | JUL-2020 | $918.00 |
1 | JUN-2020 | $1000.00 |
1 | MAY-2020 | $850.00 |
The second table is