Pivot Table field names don't match

A

Access Joe

Office 2007 / Vista

Pivot Tables: I've added a field to the 'Row Labels' section called
"Assigned Instructor". But when I look at the title of the field in the
Pivot Table itself, it calls the field "Row Labels". Sometimes this happens
to the Column section to. For example, I'll add a field called 'Month' to
the Column Labels section of the PT, but when viewed in the table, it's
called "Column Labels".

Why is that? Why does the name of the field not accurately appear? (I've
gone into the Field Settings dialog box and have confirmed the name of the
field is accurate.)
 
D

Debra Dalgleish

Those headings appear when the pivot table is in compact form layout. To
change the layout:

Select a cell in the pivot table
On the Ribbon, click the Design tab
Click the Report Layout command
Click 'Show in Outline form' or 'Show in Tabular form'
 

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

Top