1 of 1 people found this helpful
My understanding of your task is that, if you select a date with [date_choice], you want to get a total of your measures from the first day of that month to that day.
If this is correct, try this:
IF [Book Date] <= [date_choice] AND [Book Date] >= DATETRUNC('month', [date_choice]) THEN [Actual] END
If this does not solve the problem, please attach a sample workbook. As much as I can suggest ways to get a MTD, the way you need to do it will depend on how you are arranging the data in your workbook.
I built an example workbook that discusses what you are looking for. It has multiple parameters that all the user to swap between YTD, QTD and MTD based on a parameter date.
I hope this helps
Sorry to reopen this but I'm faced again to the same issue.
I can have a YTD of a defined date but I can't display at the same time the YTD corresponding for each month . Because with YTD formula, as soon as I put month into the column shelf, it's doing the MTD automatically.
To illustrate this, my data are like this :
Name Value Book date A 10 31/01/2015 A 10 30/02/2015 A 10 30/02/2015 A 10 31/03/2015 I can display Name YTD (02/15) A 30 But i wanted to show : January (ytd) February (ytd) March(ytd) 10 30 40
A little clarification needed.
Do you want the YTD value to show in each month to be the same? Do you want a running YTD total for each month?
It would greatly help us to post a package workbook example with what you expect for the months.