Editing calculated fields from the PivotTable Fields pane & renaming calculated fields
It has always confused me that I can see my calculated fields in the PivotTable Fields pane but cannot edit them from there. Instead, I have to go "Analyze" tab, "Fields, Items, & Sets", "Calculated Field", and choose the calculated field from the dropdown list. We should be able to add, modify, and delete calculated fields from the PivotTable Fields pane, perhaps through a right-click menu.
We should also be able to rename a calculated field. Currently, if you "rename" a calculated field, the "Modify" button becomes "Add". In other words, to rename a calculated field, you have to add a new calculated field with the same formula, delete the old calculated field, and then reapply this new field to every PivotTable where the old one was used. That makes no sense.