dealing with mass data in pivot table

[Katym]

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. [TABLE="width: 1321"]
<colgroup><col span="6"><col><col><col><col span="6"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
​

 

[Katym]

here are examples what i'm using. field items are seller, sold-to, ship-to city, ship to state, material, deal id, deal id valid from, ship conditions, but I have over 50 ship to's I have put in the data.