Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Year and a Month. I do have data in the data set for the whole year. But the requirements is that if it is 1st of the month The month filter will only display the months prior to the current month. For Example if today is Dec 1st, the month filter will show the months,
Jan, Feb, Mar............Nov else it will show the months up to today
May be this:
If(Day(Today()) = 1 and Max(TOTAL Year) = Year(Today()), If(Month < Month(Today()), Month), Month)
May be like this
If(Day(Today()) = 1, If(Month < Month(Today()), Month), Month)
Thanx for the quick response, it works, but one more thing, I Have data for previous years also, so I want to do the above only for current Year, for previous years I still want to see all the months.
FOr example, today is Dec 01,2016 so when I select 2016 the Months available should be Jan thru Nov, but for Years 2015 and 2014 I should see all months
May be this:
If(Day(Max(TOTAL Date)) = 1, If(Month < Month(Max(TOTAL Date)), Month), Month)
NO doesn't work cuz my date field is just Year and MOnth ;YYYYMM', Any more ideas.
May be this:
If(Day(Today()) = 1 and Max(TOTAL Year) = Year(Today()), If(Month < Month(Today()), Month), Month)