Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort top 50 in Pivot table
Hello I only want the pivot table to show me the top fifty products. this
is what I did - pivot - sort top 10 - descending - using field (Product Description ) - ON - show - top 50 - using field - sum of total - OK - table looks the same as before except that the font in the column entitled Product description is now blue all products show in descending order not just the first 50 thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort top 50 in Pivot table
Maybe you can assign a rank in your source table. I.e., "In top 50" and "Not
in top 50". Then, sort your pivot table to show only those items that are in the top 50. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Wanna Learn" wrote: Hello I only want the pivot table to show me the top fifty products. this is what I did - pivot - sort top 10 - descending - using field (Product Description ) - ON - show - top 50 - using field - sum of total - OK - table looks the same as before except that the font in the column entitled Product description is now blue all products show in descending order not just the first 50 thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort top 50 in Pivot table
How is the pivot table set up? Is product description the only field in
the row area? If not, you may be seeing the top 50 per region, or whatever other field you have in the row area. If that's the problem, and you just want to see the top 50 products, you could make another copy of the pivot table, and only show products in the row area. Wanna Learn wrote: Hello I only want the pivot table to show me the top fifty products. this is what I did - pivot - sort top 10 - descending - using field (Product Description ) - ON - show - top 50 - using field - sum of total - OK - table looks the same as before except that the font in the column entitled Product description is now blue all products show in descending order not just the first 50 thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display the source for a pivot table page field | Excel Worksheet Functions | |||
Custom field in Pivot Table? | Excel Discussion (Misc queries) | |||
Sort pivot table | Excel Discussion (Misc queries) | |||
Sort function on Pivot Table | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) |