Pivot Table field names don't match
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.) |
Pivot Table field names don't match
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' Access Joe wrote: 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.) -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
All times are GMT +1. The time now is 05:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com