Rename Table Or Field In Pivottable Or. You can sort and order your data by pivot table row or column names or aggregated values. Or if you have multiple value fields in the pivot table.
In the Power Pivot window right-click the tab that contains the table that you want to rename and then click Rename. On your computer open a spreadsheet in Google Sheets. Type a new name.
To move a pivot table label to a different position in the list you can use commands in the right-click menu.
Click at the PivotTable then click Analyze tab and go to the Active Field textbox. Click the field or item that you want to rename. You can not rename to an existing column data in your data. In our example the Qty field is removed from the layout.