8 Replies Latest reply on Mar 9, 2016 7:22 AM by Lee Forst

    How to filter a rolling 12 trend

    Lee Forst

      Please see the attached workbook created in 9.2.  I'm trying to show a rolling trend line.  I have the table calc to do what I want, but I need to filter the view to show the latest 12 month period while retaining the rolling calculation.  From what I've read, the filter needs to be based on a table calc as well.  But everything I've tried to do has resulted in failure.  Any ideas?

       

      Thanks!