Print Page - Top 20 Bottom 20

Title: Top 20 Bottom 20
Post by: theroc on 09 Nov 2007 02:07:32 PM

Trying to id the top 20 parts based of sales $, which I can do with the rank function, having a hard time getting the bottom 20 base off $.....any help would be great thanks.

Title: Re: Top 20 Bottom 20
Post by: rockytopmark on 09 Nov 2007 02:12:44 PM

Add a calculated column; [Sales $] * -1 ...then apply rank to that. for the bottom 20

Title: Re: Top 20 Bottom 20
Post by: theroc on 09 Nov 2007 02:19:41 PM

Thanks makes sense....it has been a long day and that is so obvious now >:(

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: theroc on 09 Nov 2007 02:07:32 PM