Forum Discussion
How to sort calculated Field names in Pivot tables
Hello Community, I have a number of calculated fields in my Pivot table. In order to navigate easier through the list it would be helpful to sort the list by name rather by the sequence the calcula...
Right-click the field → select Sort → Custom Sort Rules. You can also preprocess the data source through Power Queryto achieve automatic sorting, or directly drag the field to manually adjust the display order. You can try any of these methods as you prefer.
BetAfter The question is not about sorting the field on values, it is about sorting the list of fields in the Insert Calculated Field dialog. As far as I know all you can do is sort the source data alphabetically by Field name. Even then, newly added calculated fields always end up at the bottom.