Register
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
Power BI
Power Query
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: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Susan Booze
Rita Hrez
David Innes
preeti bhulabhai
Charles Klasek
Patrick Isedu
Emma Hayward
Vamseedhar G
NA NA
Max Neumann
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
