1 Reply Latest reply on Apr 22, 2017 8:17 PM by Okechukwu Ossai

    Find number of product purchases per product for 1st,2nd,3rd,nth.... Order.

    L L

      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!