I am working with a table where I need to sort and subtotal by employee and
department. I'm trying to figure out a way to either use subtotal or a pivot
table to do this. With the pivot table, I get the data sorted correctly but
the name doesn't carry to each line. If I subtotal, I get the sort by field
on the total line but not the department name. Any ideas?