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 TOP 10 and 20

Started by Cognos24id, 19 Jan 2024 06:57:19 AM

Previous topic - Next topic

Cognos24id

Hi Folks,

I have a question regarding the case to show top 10 and 20. I tried several ways based on the information in this forum, still didnt works yet.

The goal is I wanna show top 10 and 20 products based on the YTD data and Profit center.

I used this function :

if (?p_prd? ='TOP 10') then (topCount([list of products],10,[YTD])) else if
(?p_prd? ='TOP 20') then (topCount([list of products], 20,[YTD])) else ([list of products)


it works tho, if I choose prompt TOP 10, Cognos only show 9 list of products and if I choose top 20 Cognos only show top 13 and the rest Cognos show random rows.

could you help how I can show the top 10 and 20 with topCount() function?
Fyi,  [list of Products] ---> calculated data item
       [YTD] ---> Calculated measure
       [Profit center] ----> calculated data item

Thanks in advance

I attached the illustration of my report.   

[/list][/list][/list][/list]