Print Page - List and Date column

Title: List and Date column
Post by: barrysaab on 10 Sep 2011 04:32:36 AM

I have a list report and i need to show data like below format:
Date Column| Day Column
03/sep/2011 WEd
04/sep/2011 Thurs....
......
-----------------
Week38 Subtotals
------------------
05/sep/2011 mon
06/sep/2011 tues.....
.......

----------------
Week 39 subtotals

-------------
Month subtotals
---------
Qtr
-------------
Year 2011 Totals

I have tried but couldn't able to find solution.Could gurus help.Thanks.
----------------------

Title: Re: List and Date column
Post by: leahmarie on 12 Sep 2011 09:08:08 AM

Have you tried a custom calculation? For example total([measure] for [week 38])?

Title: Re: List and Date column
Post by: barrysaab on 16 Sep 2011 07:02:46 AM

Thanks,very much.but if you notice there are 4 kinds of subtotals,weekwise,monthwise,qtr wise,and year wise.

Title: Re: List and Date column
Post by: leahmarie on 16 Sep 2011 12:28:17 PM

Yeah so you would do a custom calculation for each of them. You just select the measure and select custom from the menu (if this is relational which I am assuming it is if you are using a list.) and make the measure a total for each of the items that you want a subtotal for. If it is dimensional make a calculated measure and use the dimensional functions that they provide. It takes some figuring but you can add them together pretty easily once you figure out how to use them well.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: barrysaab on 10 Sep 2011 04:32:36 AM