It might be late, but here's a solution, that helped me with a similar problem:
in SQL view you can set the order by amending the code as below(highlighted part is the code to be added):
...
PIVOT YourTable.ColumnheaderFieldName IN (1stItem, 2ndItem...);