1 Reply Latest reply on Mar 9, 2017 8:45 PM by Deepak Rai

    Sum Dimension Field Value with Another Column With Same Value (like SUMIF)

    Dana Chaffin

      I have column Req ID that has same values in another column Sub Req ID (see screenshot and Tableau Workbook)

       

      Screen Shot 2017-03-09 at 8.18.39 PM.png

       

      What I would like to show is Req ID A12345 with a total of 6 and Req ID B12345 with a total of 3 and not show the other Req IDs (by filtering on NULL in Sub Req ID)

       

      I've searched and I wasn't able to find anything

       

      Any help would be greatly appreciated

       

      -----

       

      Tableau Version: 10