Hey,
i have been browsing this community for ages but could not find a solution for my problem. Even though there is a lot of input on the topic nothing helped.
I would like to compare the Sales for a selected period of time (MonthAndYear) with the same period 12 month ago. My best result is this one:
Sum({$<CalendarYear={$(=max(CalendarYear)-1)}>} Menge)
With this scenario I have to select years and month in seperate Listboxes, thus selecting only 'Jan 2011' AND 'Dez 2010' is not possible (at least i dont know how)
I would like to have the solution based on my selection in the field CalendarMonthAndYear.
Could my Calender Format be the problem? Right now I use this one (Found it somewhere in the net)