Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to Filter the month to January of the current year through the last complete month
Examples:
for January 2012 you would pull December 2011 YTD info
for February 2012 you would pull January 2012 and February 2012 YTD info
for March 2012 you would pull Jan 2012, Feb 2012 and Mar 2012 YTD info
The change should be applied to all the years.
Example:--
For Feb 2008----Jan2008 and Feb 2008
For Mar 2009---- Jan to Mar 2009…and so on.
But the data should be displayed only for months which are complete/over.
As in if user is selecting May 2012…and the system date is May 1st,that means, month may is still not over, and thus the data should be displayed for only Jan 2012 to April 2012.
Hi
Create a variable and assign the expression as vMaxDate=Nummin(Max(DateField),MonthEnd(Today(),-1))
Expression as
Sum({<DateField={">=$(=YearStart($(=vMaxDate)))<=$(=vMaxDate)"},YearField=,MonthField=>} Sales)
Celambarasan
Hi ,
I want this as a seperate field. So that i can include month as a field in multi box.
Hi,
i want this to be included in the multi box, so that whenever i click month ,it will show the corresponding months. How can i achieve this