MTD Charts

[#1]

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,

[jonasheisterkam]

Here a solution.

[#3]

Hi Jonas,

Thanks for solution,

I have attached my sample file where I calculated WTD, In the chart I am deriving the measures using expressions. Please have a look and I want to achieve MTD in the same way.

Please advise.

Regards,

Sandhya Molli

[gautik92]

Try this

=sum({<Year={$(=Max(Year))},Transactiondate={">=$(=MonthStart(max(Transactiondate)))"}>} Qty)