2 Replies Latest reply: Apr 19, 2018 6:55 PM by Patrick Bello RSS

    Nesting year into a formula

    Patrick Bello

      I'd like to create the measure below specific to a year, such as 2017. I'm not certain how to add this to my current formula that is pulling only customers that purchased 2 products together.

       

      Sum({$<CustomerName = {"=Count(DISTINCT {<Product = {'1016', '1020'}>} Product) = 2"}>} Qty)