SUM each Payment row Running Total (YTD) by Vendor ID/Name?
My code succeeds when my query for one Vendor, but needs to be reset for the whole report (muliple Vendors)
A running total ( YTD Amount) for each group of Vendor payments, but needs to be reset when Vendor_ID changes so my ROWS BETWEEN clause is in error when a new Vendor is read
SUM(CI.Payment_Amount) OVER(ORDER BY CI.check_date
ROWS BETWEEN UNBOUNDED PRECEDING
AND CURRENT ROW) YTD