Hello, I known that is a question already aswered but we loss time with it and future maintenance won't be easy. I use pivot to calculate name of dynamics column name. With pivot, columns order are alphabetical. Why pivot don't have option to choose order ? On this point Excel is much more power…

+1 Maintaining column order in pivot would be great!

[image] Florent: With pivot, columns order are alphabetical. Not alphabetical, just sorted left to right in ascending order. [image] Florent: Why pivot don’t have option to choose order ? How would you envision such an option? [image] roberto: Maintaining column order in pivot wo…

[image] dgudkov: Not alphabetical, just sorted left to right in ascending order. It is equivalent to an alphabetical sorting. [image] dgudkov: How would you envision such an option? Pivot function should create the columns in row order. The first on the left and the last on the right. …

I usually keep an empty table with column order separately then append the table after using pivot action.

EasyMorph Community - Data preparation professionals and enthusiasts

Why the pivot function has no option to manage the order?

To learn more about EasyMorph visit easymorph.com.