Pivot Data Sorting

When you create a simple pivot table having for instance, Country, ID number, Date of issue and Cost.


The pivot is created with country and cost; when i double click on the cost for a specific country, the data is create in a new sheet. HOWEVER, the data is not sorted by the date. How can I amend this?

Other issues include coloumn widths which are sometimes small and therefore not showing the data; just ######

Regards
Sam