possibly not what you are looking for, but see attached QVW.
It is using a straight table as well. - was there another reason why you wanted to use a pivot?
This was done by creating an expression for each year - which isn't ideal if the data coming down can contain many years
You can see that it sorts though..
QVtest.qvw 120.0 K