COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: avik1986 on 14 Aug 2020 08:36:51 AM

Title: How to get latest date out of so many records for each item
Post by: avik1986 on 14 Aug 2020 08:36:51 AM
How to get the latest date and time out of the so many records for each item
Title: Re: How to get latest date out of so many records for each item
Post by: kdorian on 17 Aug 2020 01:24:18 PM
Have you tried using the MAXIMUM summary function? I'd suggest something like:

MAXIMUM([Pickup Date] for [Item No])
Title: Re: How to get latest date out of so many records for each item
Post by: avik1986 on 18 Aug 2020 08:39:42 AM
Thanks it worked perfectly. :)