Log In
Unanswered
Home
March 10, 2016
Offline
I have a table of sales data. I have a separate table to filter the data the maximum of each salesperson
How do you do that?
THANK YOU!
November 8, 2013
Offline
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.
Dashboards
April 21, 2015
Offline
I think maybe our new member (who's name I can't read, sorry) has to make a kind of report where for every salesperson his/her maximum is visable. Can you confirm that? Then we can help you with the (not so difficult) solution!
March 10, 2016
Offline
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
November 8, 2013
Offline
Try uploading the file to our Help Desk instead, until the forum will be fully functional: Help Desk
Most Users Ever Online: 57
Currently Online:
1 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 504
Frans Visser: 157
mey tithveasna: 69
David_Ng: 64
rathanak: 58
yhooithin05: 54
A.Maurizio: 51
julian: 34
Anders Sehlstedt: 31
PaulFogel: 27
Newest Members:
LeAnn Mayden
Bill Rich
Cynthia Manor
hossam elhadydy
Amol Jaju
John Braslin
shoaib ali
khagendra pandey
Veronica Hawkins
henerietth edwards
Forum Stats:
Groups: 2
Forums: 18
Topics: 734
Posts: 3487
Member Stats:
Guest Posters: 1
Members: 40697
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
