6 Replies Latest reply on Aug 16, 2018 1:06 AM by Simon Runc

    How to Hide rows with null values using Calculated Field

    chandrakanth k

      Hello All,

       

      Below is the table which I have created and I need to hide the vendor numbers which have null values in Amount column.

       

       

      Currently I am hiding it manually but I want to hide it using calculated field so that my auto refresh on extract works and I don't need to open the work book to manually hide these rows.

       

      Regards,

      Chandrakanth.K