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