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
the filter expression i wrote was : Original Date = maximum(Original Date for Product)
any ideas :-)
the filter I used was correct :-)
Now it's working :-)
so you just filtered as you said and it worked right ?
Original Date = maximum(Original Date for Product)
?