Multiple Headings in Pivot Table

L

Liz

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!
 
G

Gary Brown

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Headings for Sum in Pivot Table. 5
Doughnut Chart linked with the slicer in the pivot table 0
Pivot table data layout - columns to rows 1
Arranging row titles in a Pivot Table 1
Pivot Table Sort 0
Sorting in Pivot table 0
Rank in Pivot Table 4
Pivot Table Set Up 2

Top