COGNOiSe.com - The IBM Cognos Community

Hi all

  I want to fine out top 3 product lines according to number of quantity got sold month wise.

any idea

Thanks

Ari

Create a list report with Month, Product Line and Quantity as columns.  Group on the Month column.  Add a Query Calculation to your report called Rank with the expression rank([Quantity] for [Month]) then filter on this with the expression [Rank] <= 3

MF.

Thanks , it works