Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My requirement is to create MTD (Month to Date) charts based on the user selection of date. if the user select any date of the month Chart should display Actual and Plan information form start of the month to selected Date. For example if user selects 23/11/2014, then chart should display Actula and plan data form 1/11/2014 to 23/11/2014.
Can any one please advise me on the date expression in Chart. I have date in the format of DD/MM/YYYY.
Best Regards,
Sum({< Date= {">=$(=Date(monthstart(max(Date)))<=$(=Date(max(Date))"} >} Value)
Sum({< Date= {">=$(=Date(monthstart(max(Date)))<=$(=Date(max(Date))"} >} Value)
Thanks Jonas,
The formula worked.
Regards.
Sandhya Molli