I have a standard pivot table with departments (column labels) listed out on the left and the sum of sales and expenses (row labels) in the data section next to the corresponding department. Is there a way to have the departments listed in one column and then the word sales and expenses listed next to the department name and then just one column of the sum of sales and expenses? Ideally I want the below from my pivot table:
Dept 1 Sales Dollar Amount
Expense Dollar Amount
Dept 2 Sales Dollar Amount
Expense Dollar Amount
Dept 3 Sales Dollar Amount
Expense Dollar Amount
Thanks