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

    Sum Ifs not hard coded

    Alexandre PAREJA-GARCIA



      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