Help!

07 Pivot Table side by side row labels

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  Unstable Fonts in a "Forms" Document  
Author Message
ToddEZ
External


Since: Jan 26, 2007
Posts: 14



PostPosted: Mon Jan 19, 2009 11:50 am    Post subject: 07 Pivot Table side by side row labels
Archived from groups: microsoft>public>excel>misc (more info?)

In Excel 2003 I could add 2 data elements to the Row label area of the pivot
table and both items would show up on each row in a different column, in 2007
all items in the row label box show up in the same column.

I'd like to go back the 03 way, any suggestions?

Example Excel 03:
SSN Name Source
123-45-6789 Bob Smith 1
123-45-6789 Bob Smith 2
123-45-6789 Bob Smith 3

Eample Excel 07:

123-45-6789
Bob Smith
1
2
3
Back to top
ToddEZ
External


Since: Jan 26, 2007
Posts: 14



PostPosted: Mon Jan 19, 2009 12:16 pm    Post subject: RE: 07 Pivot Table side by side row labels [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I found the Classic View option gets me closer, yet the labels don't copy
down to all rows.

Still seeking assistance,

Thanks

"ToddEZ" wrote:

> In Excel 2003 I could add 2 data elements to the Row label area of the pivot
> table and both items would show up on each row in a different column, in 2007
> all items in the row label box show up in the same column.
>
> I'd like to go back the 03 way, any suggestions?
>
> Example Excel 03:
> SSN Name Source
> 123-45-6789 Bob Smith 1
> 123-45-6789 Bob Smith 2
> 123-45-6789 Bob Smith 3
>
> Eample Excel 07:
>
> 123-45-6789
> Bob Smith
> 1
> 2
> 3
>
Back to top
Debra Dalgleish
External


Since: Dec 17, 2003
Posts: 3389



PostPosted: Tue Jan 20, 2009 12:21 am    Post subject: Re: 07 Pivot Table side by side row labels [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

The row labels don't fill in for each row, nor did they in Excel 2003,
and there's no way to change that behaviour.

To create a table with a heading on each row, you could copy the pivot
table, paste it as values in another location, and fill in the blanks,
using the technique shown here:

http://www.contextures.com/xlDataEntry02.html

ToddEZ wrote:
> I found the Classic View option gets me closer, yet the labels don't copy
> down to all rows.
>
> Still seeking assistance,
>
> Thanks
>
> "ToddEZ" wrote:
>
>
>>In Excel 2003 I could add 2 data elements to the Row label area of the pivot
>>table and both items would show up on each row in a different column, in 2007
>>all items in the row label box show up in the same column.
>>
>>I'd like to go back the 03 way, any suggestions?
>>
>>Example Excel 03:
>>SSN Name Source
>>123-45-6789 Bob Smith 1
>>123-45-6789 Bob Smith 2
>>123-45-6789 Bob Smith 3
>>
>>Eample Excel 07:
>>
>>123-45-6789
>>Bob Smith
>>1
>>2
>>3
>>
>


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com
Back to top
JChen
External


Since: Mar 10, 2010
Posts: 1



PostPosted: Thu Mar 11, 2010 1:31 am    Post subject: Display fields side by side on the Pivottable [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I had the same problem, and it took me a while to find how to fix it...

Here is the steps of how,

- Click on the field that is the upper level to the one that you want to move across
- Go to PivotTable Tools, then Options
- in the Active Field, select Field Settings
- In the Field Settings box, select the 2nd tab 'Layout & Print'
- Under 'Show item labels in outline form', Untick the box 'Display labels from the next field in the same column'and Ok.

This should bring the fields side by side on the table.




ToddE wrote:

07 Pivot Table side by side row labels
19-Jan-09

In Excel 2003 I could add 2 data elements to the Row label area of the pivot
table and both items would show up on each row in a different column, in 2007
all items in the row label box show up in the same column.

I'd like to go back the 03 way, any suggestions?

Example Excel 03:
SSN Name Source
123-45-6789 Bob Smith 1
123-45-6789 Bob Smith 2
123-45-6789 Bob Smith 3

Eample Excel 07:

123-45-6789
Bob Smith
1
2
3

Previous Posts In This Thread:

On Monday, January 19, 2009 9:50 AM
ToddE wrote:

07 Pivot Table side by side row labels
In Excel 2003 I could add 2 data elements to the Row label area of the pivot
table and both items would show up on each row in a different column, in 2007
all items in the row label box show up in the same column.

I'd like to go back the 03 way, any suggestions?

Example Excel 03:
SSN Name Source
123-45-6789 Bob Smith 1
123-45-6789 Bob Smith 2
123-45-6789 Bob Smith 3

Eample Excel 07:

123-45-6789
Bob Smith
1
2
3

On Monday, January 19, 2009 10:16 AM
ToddE wrote:

I found the Classic View option gets me closer, yet the labels don't copy down
I found the Classic View option gets me closer, yet the labels do not copy
down to all rows.

Still seeking assistance,

Thanks

"ToddEZ" wrote:

On Monday, January 19, 2009 7:21 PM
Debra Dalgleish wrote:

The row labels don't fill in for each row, nor did they in Excel 2003, and
The row labels don't fill in for each row, nor did they in Excel 2003,
and there's no way to change that behaviour.

To create a table with a heading on each row, you could copy the pivot
table, paste it as values in another location, and fill in the blanks,
using the technique shown here:

http://www.contextures.com/xlDataEntry02.html

ToddEZ wrote:


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com


Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint Video Library Template Available For Download
http://www.eggheadcafe.com/tutorials/aspnet/223c6e57-f81f-44b3-ab05-5995f2b0ab63/sharepoint-video-library.aspx
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum