Displaying data for last date from the range

[#1]

Hi All,

I have a report where user chooses range of dates on the filter to properly display a bar chart. On the other hand I need to display one value for the last chosen date (max date from the multivalue date filter).

Eg. user selects 12 month to be displayed on the chart - from Jan 2012 to Dec 2012. Apart from the chart, I need to show him in separate text box only the value for Dec 2012.

Any ideas how to do it?

Thanks,

Katie

[CELAMBARASAN · Accepted solution]

Hi,

     Check with this

     =Sum({<DateField={"=$(=Max(DateField))"}>} Sales) use this type of expression in text box object

Celambarasan

[#3]

Thanks a lot, that works really perfect!