Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot table formatting | Excel Discussion (Misc queries) | |||
Pivot Table Formatting | Excel Discussion (Misc queries) | |||
Formatting of Pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) |