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