8 Replies Latest reply on Mar 20, 2014 9:06 AM by Ashley Lambert-Maberly

    Creating a Filter to show the latest year vs. 5 years ago?

    Ashley Lambert-Maberly

      Hi,

       

      I know how to show the latest year in my data set (edit filter, click on Top, pick the top 1 by YEAR Maximum), but for an upcoming project the client would like to see the latest year compared to 5 years ago.  Ouch.  No idea.  (I'm imagining if I could see the underlying SQL for the filter I could edit it to include either the top year or top - 5years, or something like that, but don't know how one gets to see that).

       

      Is this possible?  How is it done?

       

      Our data is structured to just be a single snapshot each year, so the date field is simple, it's just YEAR.

       

      Thanks,

       

      Ash