| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing top ten and then "others" in a pivot table
I am able to show the top ten of a group of salespeople in my pivot table and
get their totals. Is there a way I can also show "all others" and their totals within the same pivot table? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Showing top ten and then "others" in a pivot table
How about not using the top ten function and sorting by whatever field you're
using to determine your top ten. Then group all of the non-top-ten folks and name them "All Others". From there you can remove the now unnecessary field with all the names in it. I hope that works! "sherobot" wrote: I am able to show the top ten of a group of salespeople in my pivot table and get their totals. Is there a way I can also show "all others" and their totals within the same pivot table? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find the "Show Pages..." Pivot table feature in 2007? | Excel Discussion (Misc queries) | |||
| Deleted the pivot table - continue to get the "overlap" error message | Excel Discussion (Misc queries) | |||
| "Show Field List" in Pivot Table Toolbar doesn't work | Excel Discussion (Misc queries) | |||
| Pivot Table "Include hidden items in totals" | Excel Discussion (Misc queries) | |||
| How to "blank" pivot table calculated fields if result = 0 | Excel Worksheet Functions | |||
Linear Mode
