Displaying the last loaded month data

[#1]

Hi,

We wanted to show monthwise data of the current stock of products.When we select the specific month, it should display the current stock available for that month. Suppose for this year, I have the current stock  data available from jan to March, Is there any method that when I select april or May or even December, it should display me the last loaded month data ie here its should be march. Can someone help please!!!

[#2]

Found a solution yet?

I have done something similare to that

[#3]

Yes! You could just make ur expression like Max(Month(Today()-1)), Then when selecting a max mont eg. May, it would so april.. Selecting April it would show March and so on.

or Month(Addmonths(Today(),-1))

[Anonymous]

Hi

expression

=count({<

  year=,

  month=,

  quarter=,

  monthyear=, 

  dateNum=

  {'>=$(=(Num(MonthStart(vSelectedDate, -2))))<=$(=(Floor(MonthEnd(vSelectedDate))))'}>} [Order id])

and

create one variable -> vSelectedDate = =If(Num(MonthEnd(Makedate(Max(year), Max(month), 1))) > Num(Today()), Num(Today()), Num(MonthEnd(Makedate(Max(year), Max(month), 1))))

try this

Regards

Ashok