4 Replies Latest reply on Oct 21, 2013 8:10 AM by Matt Lutton

    Displaying last x quarter information

    Philip George

      Hi,

       

      I have a dataset like the attached item.

       

       

      Fiscal Quartersales
      2012Q1100
      2012Q2200
      2012Q3300
      2012Q4400
      2013Q1500
      2013Q2100
      2013Q3200
      2013Q4300
      2014Q1400

       

       

      Fiscal quarter field is a string. cannot be converted to date data type.

       

      I want to display one one chart like attached item.also the chart should always display the latest 3 fiscal quarters information and the user should be able to change the number from 3 to other values.

       

      I can use parameter for user input.but I am not able to filter the chart to specific number of quarters because actual fiscal quarter field is a string field.

       

      Can anyone help me in this.

       

      Regards,

      Philip George