3 Replies Latest reply on Feb 17, 2016 9:20 PM by Shinichiro Murakami

    Sum Ifs not hard coded

    Alexandre PAREJA-GARCIA

      Hi.

       

      I have been looking to a lot of different article without finding a solution which fits my problem.

       

      This is a logistics / shipment problem.

      I have 5 columns:

      Tableau 1.JPG

       

      I would like to detect if 3 or more of the same product are send for each Request.

       

      In Excel I would for each line enter this formula:=SUMIFS(E:E,A:A,A2,D:D,D2) and then If F2>=3 then...

       

      Tableau 2.JPG

                                                                                   

      How would you do it in Tableau?

       

      The concatenation methods may not work since I will set up the table to have for unique key Concatenation Order Number&Line Number

       

      Regards,

       

      Alex