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 calculated fields have been created. Does anyone have an idea?
3 Replies
I'm afraid this is one of those "it cannot be done without code" things. Of course using VBA you could create your own User Interface and have full control :-)
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.
