IBM Support

How do you display the top 10 records using the Rank function?

Troubleshooting


Problem

How do you display the top 10 records using the Rank function? Is there a way to connect the data item Product Line with sales people so you can get the Top 10 sales by PRODUCT LINE?

Resolving The Problem

Use the Rank function and then filter the top 10

Steps:Use the function Rank to obtain the ranking for each data item.

The rank column has this calculation: Rank([Revenue] for [Product line])

And then add a filter to the report: Rank <= 10

In the filter definition, set the application to After auto aggregation.

You will get the top 10 revenue generated by product line based on the sales Rep.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Studio","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2;10.1.1;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
27 May 2022

UID

swg21340642