View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kelli[_2_] Kelli[_2_] is offline
external usenet poster
 
Posts: 2
Default pivot table column order

I have a pivot table 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