Is it possible to sort a pivot table by a field that is included in the data source table but one that is not included in the pivot table itself? If the answer to this is 'no' then alternatively is their a way of including it (to be able to sort by it) and then hiding it as it is not needed in the pivot table (except only to be able sort by it - if you see what I mean)!
Solved by S. Q. in 27 mins