4 Replies Latest reply on May 15, 2018 1:28 PM by Michael Ye

    Hiding Rows if they are null

    Christopher Japit

      I'm trying to hide null rows from the view if they are null but all I have found online is using filters and that filters the data which isn't what I want.

       

      This is a sample data set to describe my problem.

       

      Material A doesn't require glass so I would just that row to be hidden. Likewise, Material B does not require Metal, Rubber, or Wood so I would like those to be Hidden as well. I attached an image to show which rows I would like to be hidden.

       

      Is there a way to do this without pivoting the data?