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 |