So what I am trying to do is find what customers order per product for there 1st order and every subsequent order after. I can do this by filtering on first, second, etc order via fixed calc but I would like it to be more dynamic so that there is one calculation that finds the repeat orders. The Holy grail would be to have a parameter that you identify what the first product purchased is and then you can see if a customer purchased that item this is what historical they purchased in subsequent orders. Any help would be greatly appreciated!
Is this is what you are looking for? Below are the list of customers and the products the first purchased and then for those who made their 10th order. I can attach the workbook with explanations later in the day.
The first purchase list is obviously longer than what is displayed on the screenshot.
Let me know your thoughts.