1 Reply Latest reply on Jun 28, 2018 2:53 AM by Tushar More

    hi please help me i want to show customer who purchased in both furniture and office supplies but not in technology

    anjali b

      the output should be like this

      when i am trying with this formula i see some customers are missing


      cal 1:

      { FIXED [Customer Name], [departmentsy] : MIN(IF [Category] = 'Furniture' OR [departments] = 'Office Supplies' THEN 1 ELSE 3 END )}


      cal 2

      IF  { FIXED [Customer Name] : SUM([Calcul 1]) } = 2 THEN 'OK' ELSE 'NOT' END


      some one please help me