Get max date in expression based on dimension

[#1]

Hello,

I am using pivot table to show the inventory data.

For 1 material no, there are different batch dates.

So as on any selected date in calender, I want to consider only max batch date on or before calender date.

for eg:

if Jan 2015 is my calender date, and material no is 11106 and there are batch dates in June 2014, Dec 2014 and March 2015.

So as on Jan 2015, dec 2014 is the max batch date.

So how to write the expression using set analysis for this?

[buzzy996]

may be u can try this way,u can simply setup ur calendar date with batch date,tht helps to bring the corresponding values into ur dashboard.

[#3]

No, I can't do like that because I have posting date also and depending on that only I created Calender date.

Can you have another solution. Please reply me.