5 Replies Latest reply: Dec 8, 2017 6:08 AM by Vikas Desai RSS

    how to get last 6 months data

    deb sahoo



      There is a table having 2 field one is sales field and another is date field. date field contain dates of 2011 and 2012 .

      Maximum date is 16/02/2012 (dd/mm/yyyy). 2012 Feb is maximum.


      The requirement is display sum of sales of last 6 month in a bar chart . It will show Feb,Jan,Dec,Nov,Oct and Sept months sum(sales).


      Please help me to write a set analysis for  this.


      Thanks in advance.