pivot table column order

K

Kelli

I have a pivot table re: the # of calls, and type that a person received.
I'd like to show the total number and % in columns next to each other.

What I have looks like this:
Reason Code Annette S. Deb J. Annette S. Deb J.
After Hours 2 1 2.00% 0.50%
Holiday 0 0 0.00% 0.00%

I'd like it to read
Reason Code Annette S Annette S Deb J Deb J
After Hours 2 2.00% 1 0.50%
Holiday 0 0.00% 0 0.00%
After Hours
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation referring to Pivot Table 0
Sorting in Pivot table 0
Pivot Table - Row Label Combination 0
Pivot table bottom ten filter with conditions 2
Querying a list with Excel 2
Custom Counter Question (Repost) 4
Pivot table group help 2
Pivot Table Filter Formula 1

Top