I am trying to design a report that shows the dollar amounts of write offs approved by individuals in particular departments. Ex. Dept. Authorized Total Admin Dana $192.00 Lyzz $265.00 My problem is, I need to also add in a total for the department; I want to see: Dept. Authorized Total Admin Dana $192.00 Lyzz $265.00 Dept Total $457.00 However, when adding in the calculated field "Dept Total", I have to place it in the header for the "Dept" field (in design view). If I move the field anywhere else, I get the wrong totals. This makes it appear like this: Dept Total $457.00 Dept. Authorized Total Admin Dana $192.00 Lyzz $265.00 I have gotten this data to display as a pivot table by creating a form instead of a report; however I cannot figure out how to format the pivot table the way I need it to look. This report has to go to upper-level management, so I want it to look pretty.