1 Reply Latest reply on Nov 8, 2019 9:53 AM by Deepak Rai

    Show Records That Are In Multiple Categories

    Laurel Ayuyao

      Hi,

       

      I'm working with data from the National Science Foundation that details which institutions received grants over the past few years.

      Each of the projects has at least 1 program element code, and some have multiple program element codes.

      Is there any way to create a filter that will show the records with a certain element code.

       

      I'm attaching the workbook that I've been working on.

      So for example, on the sheet "Map: # Awards", I would like to add a dropdown filter for the program element code.

       

      Thanks in advance!

       

      Screen Shot 2019-11-08 at 12.34.49 PM.png