Suggestions Please!

I am doing a report on all inpatient admissions by dr within practice grp. Then I need to total by current yr MTD and Prior yr MTD find that varianve and then total Current yr YTD and Prior yr YTD and find that variance. Can this be done ina single report?