3 Replies Latest reply: Jan 6, 2012 10:55 AM by Sunil Kenth RSS

    Chart showing sales for the last date in the data-set

    Sunil Kenth

      Hi,

       

      I would like to do a bar chart that shows sales for the latest/highest date in my dataset.  So for example if I open the application today the chart would only show me sales for 6th Jan 2011 and if i opened up the application tomorrow it would only show me the sales for 7th Jan 2011.

       

      I then, on the same chart want to be able to show sales for that same date but for the previous year.

       

      My sales field that i am summing on is called 'SALES_RV' and the date field is 'Excel_Date'

       

      Thanks for your help.

       

      Sunil