| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
pivot tables using same heading to show multiple data information
I have a pivot table that lists the top 5 highest paid sales people on my
team. Now I want to be able to have the pivot table also show the remaining sales people (20 more people) and their grand total of what they made for the year. But it only shows the top 5. Does anyone know how I can get it to show both? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot tables show zeros | Excel Discussion (Misc queries) | |||
| how can I exclude a heading but show that heading in sheet. | Excel Discussion (Misc queries) | |||
| pivot tables-drop data in, how to make it show as columns instead | Excel Discussion (Misc queries) | |||
| show items with no data option in pivot tables | Excel Discussion (Misc queries) | |||
| Pivot Tables multiple data fields | Excel Worksheet Functions | |||
Hybrid Mode
