I have a list of 6000 rows with many columns. I built a pivot table from
this data and wanted to perform a sort. The pivot table has five or six
fields with one piece of data. One of the fields only has two values (one of
two distribution center locations). I want to identify the top 450 pieces of
data (sorted decending) for each of the distribution centers and have the
pivot table display. The desired end result would display 900 lines...450
for each DC. How do I do this?

In trying to accomplish this I also ran into another problem. I created a
very simple pivot table from the data mentioned above and wanted to see the
top 450 pieces of data from only one of the distribution centers. Every time
I did the top 450 request I only received 183. I couldn't get the pivot
table to return the number of requested top pieces of data. When I added the
additional distribution center (by checking the check box in the field list
to get all the data), I got back 238.....not the 450 or 900.