| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Headings in Pivot Table
How would I create a pivot table when rows 1 - 3 are the same but for months
December - June and for several accounts in column A? December Corporate Employee Ending Customers Gross Adds Ending Customers Gross Adds 3M COMPANY 123 0 854 22 Any assistance would be appreciated! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Headings in Pivot Table
To start with, you need to fix up your database.
Month should be in a single colum for each record (for example in col 'A') NOT as a column heading. Column Headings (IN ROW 1) should be 'Corporate Ending Customers', 'Corporate Gross Adds', 'Employee Ending Customers', 'Employee Gross Adds'. Now your data is fit for pivot tables. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Liz" wrote: How would I create a pivot table when rows 1 - 3 are the same but for months December - June and for several accounts in column A? December Corporate Employee Ending Customers Gross Adds Ending Customers Gross Adds 3M COMPANY 123 0 854 22 Any assistance would be appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make manually changed pivot table column headings work for other u | Excel Worksheet Functions | |||
| Excel 2002: Can Pivot Table show headings beside the row labels ? | Excel Discussion (Misc queries) | |||
| elucidating grouped headings in pivot table | Excel Discussion (Misc queries) | |||
| Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions | |||
| pivot table row vs column headings | Excel Worksheet Functions | |||
Linear Mode
