Description - Would like to have the ability to 'sort' report data, specifically data from a field that allows for more than 1 selection so that further excel work could be streamlined.
Why is this feature important to you - This is important for our budgeting system that we built in Workfront. The data captured in Workfront is exported to excel frequently and further looked at/put into pivot tables, charts, etc.
How would you like the feature to work - To have an "advanced option" in that column of data to sort the data in a specific order, or even order of how the field values are displayed in the field would be great. Example: we have apple, orange, banana, peach and plum as field values. Adam selects apple and plum and his data shows as Apple, Plum. Lucy select apple, orange, banana and her data shows as Banana, Orange and Apple. While looking at Adam and Lucy's data in our report, Apple is not aligned as the first option therefore when exporting to excel it makes it more difficult to continue reviewing the data.
Current Behaviour - Workfront currently displays the data in a report in the order it was selected by the user.
