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

HOw to roll up a top ten?

Started by thedon_1, 16 Dec 2011 11:02:31 AM

Previous topic - Next topic

thedon_1

I have a report that has the following

Manufacturer    Rank     Profit   Value as % of total
A                       1           100      12%
B                       2           150     10%   
..............
..............
..............


I have this filtered for one period and it only shows top 10.

What I really need is the following

Period       Profit      Profit of top 10
01             1000        500


I don't really know how to translate the profit from top 10 into the second report.

How would I write the data item for that? I assume there is a way as I have rank and the other required fields in the query.

I assume it would be Total [profit] for [period], [Rank] <1
I don't really know how to write that in Cognos though.           

blom0344

1. Copy the list to new report page
2. Associate Manufacturer with the list (add it to list properties)
3. Remove Manufacturer from list design

thedon_1

Hi

This method gives me a seperate line for every profit figure. The period field has the same value. Any reason why it doesn't aggregate?

The query has been set to auto summarise and aggregate as yes.

blom0344

Hmm, I was a bit too fast here. Trouble is that later 8 versions automatically remove dataitems from queries when they are not used in the layout or associated otherwise. You CAN overrule this in report studio (Options --> Report), but it is probably better to leave this as is and try to keep Manufacturer in the query by refering to it. So if you have another report page showing the detail lines (with manufacturer) I would expect the proper result without adding it to the list properties.  Is that the case?