If I view information in a pivot table, I have the ability to sort the table based on a field that is not present in the pivot table view. I would like a similar capability in lists.
In my specific example, I have created a custom table to hold risks and issues. I want the ability to have the most important risks and issues at the top of the list, to give them the focus that they deserve. For reporting, the importance for a risk for me can come from a mixture of the probabitlity of the risk occuring, the possible impact and the urgency of implementing the mitigation. In order to simplify things, I added an order field to risks, which is a simple numeric list that I can then sort (in my case, sort ascending).
I simply want to be able to sort the list based on the order field, without showing the order field.
(In case you are wondering, when trying to present this data, I prefer to have a list with an order field rather than use a pivot table because I can get a slightly improved look and also I can edit the column heading in the list).
On the needed by field for this idea, I have put "Not sure", simply because I can operate as is. At the same time I would really love to see it implemented. Also, my use of the table is not customer facing. If it was, I might be more sensitive about showing the order field, based on wanting to provide customers with the cleanest view and not wanting to have to explain that column.
Thank you for the idea. This is possible today. The status of this idea was out of date.