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. |
All times are GMT +1. The time now is 11:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com