Field and Value Settings in Excel Pivot Tables
Are you aware of this feature of the pivot table that you can edit your field and value settings in multiple places of your pivot table? Alright if you don’t know about this then here I will share different shortcuts so that you can do it in your Pivot Table.
FIELD SETTINGS IN EXCEL PIVOT TABLES
OPTION1. Under PivotTable Fields > Rows > Field Settings
OPTION2. Also, you can do the right click on a Row Label and select there your Field Settings.
OPTION3. Go to PivotTable Analyze > Active Field > Field Settings
You have got your open Field Settings.
VALUE SETTINGS IN EXCEL PIVOT TABLES
OPTION1. Go to PivotTable Fields > Values> Value Field Settings
OPTION2. You can also do a right-click on a Value and select your Value Field Settings there.
There you go with your Value Field Settings!