3 Replies Latest reply on Nov 13, 2013 11:06 AM by brett.cohen

    Rank function and Hiding Rows

    brett.cohen

      Is it possible to use a conditional hide (as opposed to a filter) in order to preserve rank?

       

      For example, I would like to show the last 20 days of performance, along with how they ranked over the past year - if I put a filter in for the last 20 days, it re ranks them amongst those 20 days, and if I manually hide days 21 ago and beyond, it will not hide day 20 automatically tomorrow when the data set updates.

       

      Is there an easier way to preserve the rank function or a better way to do a conditional hide?

       

      Or is there a better way to set up the rank function - other than using the index () to better suit my needs