List and Date column

[barrysaab]

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.
----------------------

[leahmarie]

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

[barrysaab]

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

[leahmarie]

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.