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

Displaying quarters after month and year totals

Started by vivek_vdc, 19 Aug 2015 02:55:46 PM

Previous topic - Next topic

vivek_vdc

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   

bdbits

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.