5 Replies Latest reply on Oct 16, 2018 9:11 PM by amar savale

    Filtering by grouped and overlapping values

    Logan Butler

      I am trying to create a filter that allows me to select which students do poorly on a test by a calculated field. I have attached a sample workbook because I am unable to post the real data.

       

       

      In this workbook, we have a calculated field that shows when students score in the "Lowest", "Low", or "Normal" categories. I would like to have a filter that just has the two options:

       

      -Poor test scores (Low & Lowest)

      -All test scores (Low, Lowest, Normal)

       

      How can I accomplish this?