I have come across a few instances where the manual sort order of a view will change when the data is updated.
This is because some of the fields have static headers and others are dynamic (for instance, a column heading may be a date string).
When the data is updated, the new headers will not be in the same order.
For instance, if the column headers are: | January 2012 | 1 Month | 3 Months | 6 Months | 12 Months | 36 Months |, then when January 2012 updates to February 2012 it will be placed at the end.
It is easy to manually re-order the data, but I was curious to see what methods (if any) other people use to keep the sort order with dynamic headers.
Retrieving data ...