Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Pivot Table Sort & Top List
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
How do I remove items listed in a pivot table drop down list box | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
convert excel list to pivot table | Excel Discussion (Misc queries) |