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.
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
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.
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?