3 Replies Latest reply: Mar 13, 2018 1:30 PM by Patrick Bello RSS

    Using P() with multiple criteria

    Patrick Bello

      Is it possible to use P() to show a set that has multiple criteria in the formula? In my case looking for customers that each purchase all three products. I do not want in this group customers that only purchase 1 or 2 products. Only customers have purchase all three.

       

      Sum({$<CustomerName=P({1<Product={'1016'},{'2016'},{'1032'}>}CustomerName)>}(Qty))