If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

show total revenue divided by top 5 revenues

Started by cognos.cognosbi@gmail.com, 19 Oct 2011 01:25:33 AM

Previous topic - Next topic

cognos.cognosbi@gmail.com

i have a list report with some columns.example.Product Type,Product Line,Revenue.i want to show total revenue divided by top 5 revenues.for this we should use rank function.how can achieve this.

Thanks in advance.

Thanks
Cool

annareddy

hello cool,
I have taken the Product line,product type,Revenue in list report
go to Query explorer, select the query 1
go to insertable objects and drag the dataitem in query1.
rank ([Revenue]) and change the dataitem name Rank.
rank data item drag the Detail filter,will give the Expression
[Rank]<=5.

will show the only top 5 records ...
thanks,
Annareddy