Ian Bennett on 17 Feb 2017 08:50:54
At least as an option, allow fields to be ordered the same as the source query rather than alphabetical. This way they can be put in a logical and consistent order.
Obviously, a workaround is to prefix each column name with a number but this is clunky, unattractive and a pain if the columns change often.
- Comments (55)
RE: Customize fields list ordering
Let's go Microsoft.
RE: Customize fields list ordering
Please implement. Even the Pivot table in Excel has this basic feature.
RE: Customize fields list ordering
Please implement this. We need to organize the fields as per our business logic and not in alphabetic order
RE: Customize fields list ordering
Please add this. Absolutely essential!
RE: Customize fields list ordering
Currently the FIELDS area lists fields by alphabetic order within a data object (or EXCEL file). There is no option to display fields in the order they appear in the data object or in the EXCEL file. This makes it more difficult to find fields because they are out of order and scrambled when compared to an Excel workbook or data file.
Therefore, Provide the option to list fields by their order within worksheets and other objects OR alphabetically.
RE: Customize fields list ordering
This is a standard is just about every tool I've used. why microsoft is lagging on this? its a simple option.
RE: Customize fields list ordering
How has this still not been implemented 2.5 years after being requested?
RE: Customize fields list ordering
I also fully agree on that.
RE: Customize fields list ordering
Yes, please update this feature.
RE: Customize fields list ordering
This would be really useful and consistent with Excel Pivot Tables