Hi,
I am having a list report of 7 columns. First 4 are attribute columns and last 3 are measure columns. I have created groups and a sort order based on the first 4 columns.
Now I am trying to do a Total of last 2 measure columns (To get individual groups's sum's). I have 2 questions:
1. While doing sum, by default, Cognos places the aggregate sum for 6th column under 7th and aggregate sum of 7th under 8th column (outside list). Ofcourse there is a blue line indicator to mark the row as a summation.
How to align this so that 6th column sum comes under 6th column itself and 7th column sum comes under 7th column?
2. When I try to do a "set page break" option based on 2nd column, all my sorting is going away. How to fix this so that the sort I specify stay in tact?
I tried following below link but no luck.
http://www-01.ibm.com/support/docview.wss?uid=swg21370546
Thanks,
I think I got the issue with #1.
I had a column hidden (Box Type property as No) and hence is why I think it is pushing the result to next column. I created a new report without hidden columns and that looks ok.
Excellent ! Makes me feel good to realize that I am not the only one to ask a question and post the answer myself ;)
Some people (at my previous employer's place) had thought that I am whacky >:(
Good heavens :) Atleast feels happy to get things working :)
Found 2nd one too same way with some research. Thought of posting if it helps someone. Used the PageSet and added in Group by there and also sorted based on the column which I need.