ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   pivot table column order (https://www.excelbanter.com/excel-discussion-misc-queries/227741-pivot-table-column-order.html)

Kelli[_2_]

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


All times are GMT +1. The time now is 02:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com