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

    Hide rows if the first column empty

      Hi,

       

      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!

       

      Thanks

      Paul