What is the best way to sort mass data through a pivot table. I'm fairly new to pivot tables and want to sort by ship-to's but there are so many that the pivot looks overwhelming. These are the columns I'm having to handle.
<colgroup><col span="6"><col><col><col><col span="6"></colgroup><tbody>
</tbody>
<colgroup><col span="6"><col><col><col><col span="6"></colgroup><tbody>
</tbody>