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