3 Replies Latest reply on Feb 14, 2019 8:09 AM by Santiago Sanchez

    Excluding zero values from Table Calculation

    yongsheng lim

      Hi all,

       

      Would like to exclude 0 values from a Table Calculation (across then down)

       

      Creating a calculated field:

      (ZN(SUM([Pivot Field Values])) - LOOKUP(ZN(SUM([Pivot Field Values])), -1)) <> 0

       

      And dragging to the filters shelf does not give me the results that I want

       

      Packaged Tableau workbook has been attached

       

      Any help would be greatly appreciated, thank you