COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: vivek_vdc on 19 Aug 2015 02:55:46 PM

Title: Displaying quarters after month and year totals
Post by: vivek_vdc on 19 Aug 2015 02:55:46 PM
How do I get the following format on a list report? The quarterly totals need to appear after the yearly summary. Right now I have it after each quarter month (i.e. after March we have Q1, after June we have Q2). What's needed is  this format?   
        January   
   February   
   March   
   April   
   May   
   June   
   July   
   August   
   September   
   October   
   November   
   December   
Full Year   
   Q1   
   Q2   
   Q3   
   Q4   
Title: Re: Displaying quarters after month and year totals
Post by: bdbits on 19 Aug 2015 04:31:30 PM
I think the most straightforward solution is to separate this into two lists, one for the year and one for the quarters. Then "stack" them on the page.

There are other ways of course, but this will be easier to understand for the report writer who comes along in six months to modify your report.