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



      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.