11 Replies Latest reply: Jun 15, 2016 8:14 AM by Sam Maile RSS

    Count Distinct, Multiple Measures (Sum)?

    Sam Maile

      Hi,


      I have three products which I am trying to sum on a distinct ID number.

       

      My current set analysis is:


      COUNT ({$< Product_1 = {">0"}>}  DISTINCT ID)

       

      There are two other products Product_2 & Product_3.

       

       

      I have tried adding them together using comma separators, however this prints out the wrong number compared what is printed out trough my SQL code.

       

      Help would be appreciated.