7 Replies Latest reply: Jul 19, 2018 8:40 AM by Sunny Talwar RSS

    Expression to show YTM data

    Ron M

      Hi Guys,

       

       

      I am trying to create a YTM graph using current and last year data, attached is a sample qvf file. In the first sheet of the attached qvf, the graph is on YTM basis. I have done this by defining 2 columns with data restricted on a YTM (Till June) basis. However, I do not want to create these additional columns as I already have a single column where data from Jan 2017 to June 2018 is available. Now, for my comparsion between 2017 YTM and 2018 YTM, I can easily use an expression for YTM 2018 as only YTM data is available for 2018. However, for 2017, I have the full year data. I want to be able to define YTM 2017 using an expression in such a way that I am able to apply month filters to the YTM graph. For example, if I select Jan, Feb and March as filter, both 2017 YTM and 2018 YTM bars should show 3 months cumulative data and so on. Hope my explanation is clear. Please help me with this.

       

      An expression which helps me select data suing the maximum function, upto June is what I am looking for. Please advise.

       

       

      Regards,

      Rony