| po no | invoice no | Party | inv date | value | status |
| 1 | aa1 | ABC | 01-May-26 | 100 | Under Cr |
| 2 | aa2 | XYZ | 02-May-26 | 200 | Over Due |
| 3 | aa3 | ABC | 02-May-26 | 300 | Under Cr |
| 4 | aa4 | XYZ | 03-May-26 | 400 | Under Cr
|
I need result as below using formulas (not Pivot table)
(We can achieve this using query in google sheets, but in zoho sheets need help)