3 Replies Latest reply on May 4, 2012 5:43 AM by Zachary Fraile

    Exclude top N filter

    Zachary Fraile

      Is it possible to create a filter that will give me everything except the top N number of rows?

       

      I have a worksheet which gives me the top 10 results from a variable number of items.  I want to create a second worksheet that gives me everything that is not within those top 10 items as a single result.  Then I would be able to combine them on a dashboard like this:

       

      ITEM 1

      ITEM 2

      ITEM 3

      .

      .

      .

      ITEM 10

      ALL OTHERS

       

      Is that even possible?  I do not know how many items are in the list so I cannot simply select the bottom N - 10 items as that will change depending on the filters and/or parameters chosen.

       

      Thanks