Pivot Table Formatting
After creating a pivot table that shows a summary like this below:
john sum of calls 45 sum of contacts 5 sum of sales 3 Mary sum of calls 30 sum of contacts 4 sum of sales 2 .... How do I reformat or reconfigure the pivot table so is looks like a traditional column report: Sum of calls Sum of Contacts Sum of sales John 45 5 3 Mary 30 4 2 Thanks! Scott |
Take a look at Debra Dalgleish's site.
http://www.contextures.com/xlPivot02.html You'll be pleasantly surprised at how easy it is. Scott wrote: After creating a pivot table that shows a summary like this below: john sum of calls 45 sum of contacts 5 sum of sales 3 Mary sum of calls 30 sum of contacts 4 sum of sales 2 ... How do I reformat or reconfigure the pivot table so is looks like a traditional column report: Sum of calls Sum of Contacts Sum of sales John 45 5 3 Mary 30 4 2 Thanks! Scott -- Dave Peterson |
All times are GMT +1. The time now is 05:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com