I have daily transaction for multiple model and date ,would like to get each model's last value of the each month . Eg, if last date of product A is 5/18/2022 then May's Closing inventory value will be 15 and 1453.
The table i have
| Date | Product Name | Qty | Amount |
| 5/18/2022 | A | 15 | 1453 |
| 5/30/2022 | A | 17 | 1152 |
| 6/11/2022 | A | 14 | 1627 |
| 7/18/2022 | A | 11 | 1561 |
| 4/26/2022 | B | 10 | 1774 |
| 5/4/2022 | B | 16 | 1631 |
| 5/13/2022 | B | 13 | 1440 |
| 5/20/2022 | B | 16 | 1110 |
| 6/7/2022 | B | 16 | 1817 |
| 6/10/2022 | B | 14 | 1991 |
| 6/13/2022 | B | 20 | 1469 |
| 6/13/2022 | B | 14 | 1467 |
| 6/22/2022 | B | 11 | 1150 |
| 7/9/2022 | B | 12 | 1013 |
The result i would like to get
| Date | Product Name | Qty | Amount | Closing Inventory per month | Closing Inventory Value |
| 5/18/2022 | A | 15 | 1453 | 15 | 1453 |
| 5/30/2022 | A | 17 | 1152 | 17 | 1152 |
| 6/11/2022 | A | 14 | 1627 | 14 | 1627 |
| 7/18/2022 | A | 11 | 1561 | | |
| 4/26/2022 | B | 10 | 1774 | 10 | 1774 |
| 5/4/2022 | B | 16 | 1631 | | |
| 5/13/2022 | B | 13 | 1440 | | |
| 5/20/2022 | B | 16 | 1110 | 16 | 1110 |
| 6/7/2022 | B | 16 | 1817 | | |
| 6/10/2022 | B | 14 | 1991 | | |
| 6/13/2022 | B | 20 | 1469 | | |
| 6/13/2022 | B | 14 | 1467 | | |
| 6/22/2022 | B | 11 | 1150 | 11 | 1150 |
| 7/9/2022 | B | 12 | 1013 | 12 | 1013 |
