5 Replies Latest reply on Apr 8, 2013 2:39 PM by Pete Staley

    Dynamic Column Hide When Lookup Is Used

    Pete Staley

      Hello,

       

      I have a text table that uses a lookup to calculate the current day's value. Each row looks back a specified number of days, and divides the present value by a past value.

       

      While this table is great for viewing lifetime performance, it's not ideal for a weekly snapshot. My goal is to view the last 7 days worth of data without resetting the calculation (a result of the lookup function). Sure I can hide the excess rows manually, but having a way to do a relative dynamic hide would be all the more sweeter. Any ideas?

       

      - Pete