Suppose I have a table that looks as follows:
I want to use the NULLs (blank cells here) as a means of identifying the 'islands' to sum as well as using the last date for each 'island' as the date assigned to the summed value. The output would be as follows:
Hope what I'm trying to do makes sense. I've been playing around with row_number / over / partition by, but can't get the logic quite right.