3 Replies Latest reply on Mar 7, 2016 9:13 AM by Bill Lyons

    Filtering and hiding blank or null data

    Connie Nomann

      The project I am working on displays the number and type of degree each Academic department awards by year. There is a filter to select department and the view is updated with the number of degrees awarded. If the chosen department doesn’t award all degree types the field is either blank or null for that degree. So, I’m trying to figure out how to dynamically remove degrees with blank or null values.

       

      For example: the workbook file I am attaching is displaying the Accounting department. Accounting only awards AAS and Certs awards. I don’t want the AA, AS or Dip degrees to show on the view. How do I remove them in a way that would be updated for each department?

       

      Thanks for any help.

       

      Connie