9 Replies Latest reply: Jun 30, 2014 2:12 PM by Vlad Gutkovsky RSS

    Question with set theory –  Count distinct customers across multiple transactions selected in dynamic list box.

    Trich Schultz

      Question with set theory – Count distinct customers across multiple transactions selected in list box.

       

      My data is transactional. In the table “Test: I am trying to get the unique customers across the two rows. So males with some education.

       

      Reponse is actually a combination of two fields Lable & Response

       

      I was trying something like this count(disinct ({p(Response)>} Member_id)

       

      This is a list box Response (It is one field)


      Some High School     100

      Male                         50

       

      So I want a table that calculates unique customer id for the intersection of  "males" and "Some High School"