Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the selection table : I select january 2012 and the YTD flag. In the first colum I have the sales untill today for january 2012. The next colum shows the sales for the same period but in 2011. In a next column I would like to see the sales of the full month january 2011, so that I can see how much we still have to sell to have equal sales as full month last year. Any suggestions ?
Hi Peter
Try this for YTD for last year:
Sum({$<Year={$(=Max(Year)-1)},
datum={'<=$(=AddYears(Today(),-1))'}
>} Sales)
And then you can use this for the full month:
Sum({$<Year={$(=Max(Year)-1)}>} Sales)
Where Year = Year(datefield)
And set Month(datefield) as your dimension
This way you can use a 3th expression like: Column(2)- Column(1) to show you the difference.
Good luck,
Dennis.
Use inmonth function
INMonth(Date, BaseDate,-12)
Take current date as Base Date