2 Replies Latest reply on Apr 4, 2016 1:07 PM by Andy Holt

    Quantity vs quantity 12 months ago

    Andy Holt

      Hello

       

      I have a feeling that the solution to this is really simple and I am just missing something easy, but I cannot figure it out so am reaching out for help.

       

      I have a time series of data and I want to show quantities for the last 12 months only. This bit is not a problem. I can do that.

      I also want to show the equivalent quantities from the previous 12 months. Using lookup() I can do that too.

       

      However, what I cannot do is combine these two things. When I filter on top 12 dates by month it removes the 12-months-ago data.

       

      How do I hide the first x months, retaining the most recent 12, but still allowing me that 12-month lagged data as a comparison?

       

      Many thanks indeed!

       

      chart.PNG