4 Replies Latest reply on Feb 13, 2012 2:06 PM by paul.kretacz

    Hide rows if the first column empty



      I am aware that similar threads exist but they don't give an answer to my problem.


      I have calculated field which segregates data into two columns - Selected Plant and Other Plants.


      For some fields, there are no data for Selected Plant but there are for Other Plants. I want such rows to be hidden.


      Please look at the attached file. In this example, I would like to be able to hide 'Gold' row.


      Any ideas appreciated!