I have a chart on a report which displays all months for the current year. On the chart I have a cumulative target measure which my client wants to display all 12 months. The second series is my sales measure which I have coded as follows:
Total([Cube].[Measures].[Invoice Sales Value]
The problem with this is I cant get the series to stop at the current month because of the currentMember expression. There are only sales up until the current month but the chart has plotted October, November and December (sames values as September) because of the currentMember expression iterates through the 12 months in the categories.
Can anybody help me get the series to stop at the current month?
Just to give a bit more information, the month categories on the chart come from the children of Year value prompt.