10 Replies Latest reply on Sep 6, 2013 8:49 AM by Katie Minks

    filtering: 2 conditions are TRUE, one is FALSE

    yulia.khazanova

      I have the following condition:

      Look only at the customers that visit all three shops. For this purpose I use the following formula:

       

      MAX(IIF([Shop 1]=1,1,0))+

      MAX(IIF([Shop 2]=1,1,0))+

      MAX(IIF([Shop 3]=1,1,0))=3

       

      Now I need to look only at the customers that are visiting shop 1 and 2 and NOT 3. Could you please help me with the formula?