Not a perfect solution but better than nothing. First I have formed the
pivot based on one raw and performed the sorting. Then entered the pivot
table wizard againg and added the other rows in the raw sction. The order has
not changed and the data turned into sorted by this way.