COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: gouravatalkar on 30 Jun 2010 10:52:30 PM

Title: Cognos 8.3 Report Studio - Customers list by their last transaction date
Post by: gouravatalkar on 30 Jun 2010 10:52:30 PM
I generated a report listing customers with their transaction dates. I would like to filter the transaction date column and keep only the most recent transaction date for each customer. Could you please help me set this filter?
Title: Re: Cognos 8.3 Report Studio - Customers list by their last transaction date
Post by: blom0344 on 01 Jul 2010 01:55:18 AM
Perform a search on how to use the rank function and you will find numerous post on how to achieve this..