pivot tables using same heading to show multiple data information

S

sherobot

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to make grand total to show up on pivotchart? 0
Pivot Data Consolidation 0
Pivot tables 2
Problem - Show values as % of Grand total 0
Selecting Date Range in a Pivot using VBA 0
Multiple Tables and Multiple Pivot Tables Help 0
Assistance need to populate "GRAND TOTAl" "MSpivottable11" in Microsoft web component 0
Limit Pivot Table by date 0

Top