Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Can you please clarify what do you have in the second table? Or you mean that you need to create a report in a new sheet with sales by salesperson?
A simple pivot tale with a Value filter applied should be what you need, you can see a tutorial here: filter-excel-pivot-tables-by-values
Instead of Top 10, you can adjust the filter to show only top 3, or top 1, if you want just the highest values.
VIP
April 21, 2015
March 10, 2016
Thank you for your desire to help and give a solution,
Showing pivot given me the maximum
and I want to know all the data of this figure.
See table of all sales agents and any other agent in a series of shows all its data.
(As the attachment - sheet)
I can not attach a file it writes that
104 Error - You do not have permission to upload files
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Try uploading the file to our Help Desk instead, until the forum will be fully functional: Help Desk
1 Guest(s)