How to: Display the bottom 10 in a Cognos 8 Report Studio report

Use a rank() calculation on a calculated sort key column and then filter on the rank calculation. See attached GO Sales sample report spec.

Steps:

   Create a new List Report:

   1) Add Product Name, Product Line and Revenue
   2) Add a Detail Calculation = Revenue * -1 (to get the inverse ranking)
   3) Add a Detail Calculation = rank() on the calculation above
   4) Add a filter = rank <= "bottom" (a parameter to enter the number for bottom)