How to have sub totals in a Matrix

[jymm]

I have a report in Crystal (that I need to re-do in SSRS) where I put out one line per month and had a subtotal for each quarter - then a total for the year.
similar to this
Jan $100
Feb $200
Mar $300
Q1 avg $200
Apr $400
May
Jun
Q2 avg
Jul
Aug
Sep
Q3 avg
Oct
Nov
Dec
Q4 avg
YTD TOTAL $1,000

realistically I have more than one column and have started this as a Matrix.

So the question is - how do I put in another row to average the value by quarter? and also - how do I get 'empty' rows for months that have yet to occur (I could put them out with SQL - just making sure there is not a better way).

Thanks in advance - j

 

[jymm]

never mind - was not clicking on the right field - so things were not working as planned - I feel like I had a case of anal cranial insertion (sorry)