Data issue - maximum logic

[cognosun]

Hi Gurus,

I have this data with 4 columns , there is no measure.


Product   Original Date   Dummy date   Rcode
56732   20/11/2013   2/4/2012            222
           20/11/2013   5/1/2013           333
           20/11/2013   7/8/2013           444
           8/11/2012   17/8/2012   543
           3/11/2011   27/8/2013   213
         
         

I need to fetch maximum(Original Date) so that I should get below 3 rows...other rows should be filtered out.
         
Product   Original Date   Dummy date   Rcode
56732   20/11/2013   2/4/2012             222
           20/11/2013   5/1/2013             333
           20/11/2013   7/8/2013             444
         

But I'm scared that I'm getting below output always, eventhough I removed grouping, i.e. one maximum date row

Product   Original Date   Dummy date   Rcode
56732   20/11/2013   2/4/2012           222

Can anyone help please....


Many thanks in advance,
         
Joys

[cognosun]

the filter expression i wrote was : Original Date = maximum(Original Date for Product)

[cognosun]

any ideas :-)

[cognosun]

the filter I used was correct :-)

Now it's working :-)

[TheCognosDave]

so you just filtered as you said and it worked right ?

Original Date = maximum(Original Date for Product)

?