4 Replies Latest reply on Sep 13, 2016 12:47 AM by Andrew Murphy

    Calc for customers with only products x, y and z

    Andrew Murphy

      I have a requirement to show a viz with balance distributions for customers who have purcahsed only products x, y and z.

       

      The idea is for the user to choose x, y and z and for dashboard to recalulate.

       

      I have tried using LOD calc:

       

      {FIXED [Customer]: sum(IF CONTAINS([Product],[Product #1]) and CONTAINS([Product],[Product #2]) and CONTAINS([Product],[Product #3]) then 1 end)}

       

      This does not give me what I want, and I cant figure out if there is another way of doing this (I have seen some examples using sets but was hoping to exhaust this approach first).

       

      Thanks in advance if you can assist.

       

       

       

      Andrew