Pivot Table - changing the setup

Parks29

New Member
Joined
Dec 13, 2005
Messages
1
The below is a sample of a simple pivot table I have setup;

Test1 Sum of col 1 $57
------ Sum of col 2 2
Test2 Sum of col 1 $100
------ Sum of col 2 2
Test3 Sum of col 1 $80
------ Sum of col 2 1


The second row contains Test1, 2 & 3. The data Sum of col1 and Sum of col2 show up for each of the test1, 2 & 3.
What I am trying to do is pull info from the pivot table but I need to have the heading Test1, 2, 3 show up beside the Sum of Col2 (shown above with -----)

Any help would be appreciated - I have not been able to find the setting to allow this.

Thanks

J. Parks
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Watch MrExcel Video

Forum statistics

Threads
1,118,763
Messages
5,574,096
Members
412,567
Latest member
mm1
Top