| 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 |
| 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) | |||
Threaded Mode
