Is there any way to get row lables to repeat in a pivot table Grand Total
(Excel 2007)? For instance I have a pivot table that lists a row for
salaries and a row for expenses by department. I would like the grand total
to also breakdown the same categories instead of displaying just a 1 line
total.

Current Desired
Dept A Dept A
Salaries Salaries
Other Expenses Other Expenses
Total Dept A Total Dept A

Dept B Dept B
Salaries Salaries
Other Expenses Other Expenses
Total Dept B Total Dept B

Total Salaries
Other Expenses
Total

Thanks, Any insight you can enlighten me with is appreciated. Jill