Pivot Table Help with Column Headings

E

Ed C

I have used the Wizard to create a pivot table. I was unable to find how to
create two column headings. I can get the wizard to use either 'Account ID'
or 'Description' but NOT both. Can someone suggest the macro code that would
add 'Description' to an existing pivot table as the second line in each
column?

Something likeeither:

40100 Utilities
Utilities 40100

My existing pivot table has only the Account ID as a column heading.

Thanks,

EdC
 
D

Debra Dalgleish

Did you turn on the macro recorder as you ran the PivotTable Wizard
manually?
You should be able to add Account ID and Description to the Column area
in the PivotTable Wizard. What happened when you tried?
 

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

Unable to Group in Pivot Table 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Playing back a Pivot Table macros 2
modified pivot table using a macro 2
Automatically Update a Pivot Table Field Used as Column / Row 1
Pivot table help 6
How to refresh a pivot table that uses changing source data 1
VBA Pivot Table Error 1

Top