need expression

[#1]

Hi,

  I need expression,suppose  i have one order number as 100 and it is having multiple items as 'A' ,'B','C' and this multiple items have

multiple promise dates like

order  item   date

101    -A-    1-1-2013

          B    -2-2-2013

         C     -3-3-2013

now i want to show this particular order in max month

[CELAMBARASAN]

Try with Date(Max(DateField))

[tresesco]

May be like this?

=Aggr(FirstSortedValue(item, -Month(date)),order)

assuming that you want to find the maxdate item

if you select an order, with this expression, you would get the max date item; if you have one dimension as order, then AGGR part would not be required.