Author Topic: Summary calculation and setting page breaks  (Read 75 times)

Offline asmfloyd

  • Full Member
  • ***
  • Join Date: Jul 2018
  • Posts: 11
  • Forum Citizenship: +0/-0
Summary calculation and setting page breaks
« on: 11 Oct 2018 08:06:36 am »
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,

Offline asmfloyd

  • Full Member
  • ***
  • Join Date: Jul 2018
  • Posts: 11
  • Forum Citizenship: +0/-0
Re: Summary calculation and setting page breaks
« Reply #1 on: 11 Oct 2018 09:51:46 am »
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.

Offline cognostechie

  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 1,644
  • Forum Citizenship: +133/-7
    • Pervisol
Re: Summary calculation and setting page breaks
« Reply #2 on: 11 Oct 2018 01:31:13 pm »
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  >:(

Offline asmfloyd

  • Full Member
  • ***
  • Join Date: Jul 2018
  • Posts: 11
  • Forum Citizenship: +0/-0
Re: Summary calculation and setting page breaks
« Reply #3 on: 11 Oct 2018 02:17:16 pm »
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.

 


       
Twittear