4 Replies Latest reply: Oct 14, 2014 6:49 PM by Marco Wedel RSS

    Only to Display Quarter End Values

    Ankit Modi

      I have the below data:

       

      YRMONAmount1Amount2
      201301100
      201302200700
      201303300800
      201304400
      2013055001000
      2013066001100
      2013077001200
      201308800
      2013099001300
      20131010001500
      20131111001600
      20131212001700
      20140113001800
      2014021400
      20140315002000
      2014041600
      20140517002200
      20140618002300
      2014071900
      20140820002500
      20140921002600


      OUTPUT:

       

      2013031100
      2013061700
      2013092200
      2013122900
      2014033100
      2014064100
      2014094700

       

       

      I want to display in a chart only the Quarter End Year-Mon(Dimension) and the values of the Quarter end as shown above not the sum of the Quarters. Basically the above output in a chart. Please any one can help