Date and other columns

[barrysaab]

I have columns year, qtr, month, week, date columns and my requirement is like this

Date
week
subtotals
month
subtotals
Qtr
subtotals
year
subtotal

What I have done is grouped year, qtr, month, week and added footers for them, but it is getting bit clumsy and wayward. Could gurus please give some ideas to how to go about this one?

[leahmarie]

is this dimensional or relational?  Also- are you using one week, month, year, etc or will it be multiple or filtered?