11 Replies Latest reply on Jul 19, 2018 6:59 AM by dinesh punnam

    How to filter by top (10%, 20%, etc.) percent based on underlying data

    Heather Campbell

      I would like to create a filter (perhaps a slider) which allows me to select the top 10%, 20%, etc. percent of donors within each relevant region.  I've tried ranking but I don't want to include the individual ID_number level in my view.  (see 1st tab in the attached workbook).

       

      Any advice would be appreciated!