How to calculate history purchase in large data case

[uacg0009]

Hi all,

I want to calculate that if a vip buy selected item, before this purchase what he bought and whether it was within 12 months?

I do a small example like below:

I use this way to calculate it:

and it works in the small example:

But because actually my data is too large, it will make my computer crash, and I also use delta load per month,

it is unuseful. So do you have any idea to solve it? Maybe there is another to calculate it.

I just want to calculate the history purhcase. If I use the alternate state, it will be so slow, so I want to calculate it in qvd.

But the data is too large. Do you have any method?

Thank you so much!

You can feel free to tell me if you have any question.