Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Srry.....
Use
=sum( {<Excel_Date= {"$(=Max(Excel_Date))"} >} SALES_RV)
=sum( {<Excel_Date= {"$(=addmonths(Max(Excel_Date),-12))"} >} SALES_RV)
Hi You can use this expression"
=sum( {<Date = {"$(=Max(Excel_Date))"} >} SALES_RV) for latest date and
=sum( {<Date = {"$(=addmonths(Max(Excel_Date),-12))"} >} SALES_RV) for prervious year same date
Regards
Vijay
Srry.....
Use
=sum( {<Excel_Date= {"$(=Max(Excel_Date))"} >} SALES_RV)
=sum( {<Excel_Date= {"$(=addmonths(Max(Excel_Date),-12))"} >} SALES_RV)
Thanks Vijay