Prev: Excel
Next: Extra characters appear in the formula bar but not in the cell
From: JChen on 10 Mar 2010 23:31
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
 | 
Pages: 1
Prev: Excel
Next: Extra characters appear in the formula bar but not in the cell