Hi @BSFL89 , I must confess that I haven’t quite managed to follow exactly what you are trying to do but that may be because I’m not at my computer at the moment and am just reading this on my mobile.
I wonder if you could give a sample of the output for a given customer as it is hard to visualise just from a long description.
In terms of the Java Snippet, whilst it really has direct access to only a single row of data, it can be made to work ‘cumulatively’ and as it processes each row, it can be made to ‘remember’ information that has been acquired from previous rows which I think is possibly what you are trying to do here.
Maybe give this post a read which gives some examples of this feature of Java snippets and maybe something here can be adapted to what you need, or may give some pointers…