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
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: 402
Frans Visser: 144
rathanak: 58
yhooithin05: 54
mey tithveasna: 53
David_Ng: 44
A.Maurizio: 41
julian: 34
Blanka Blair: 26
Hava Yassin: 21
Newest Members:
aqeel ahmed
Rebecca Chen
Paul Giles
mike pickle
Tamra Turpin
Hanna Janvier
Rebekah Haynes
Anna Sullivan
Madhusudan reddy Reddy
Muhammad Uzair Vohra
Forum Stats:
Groups: 2
Forums: 18
Topics: 568
Posts: 2783
Member Stats:
Guest Posters: 1
Members: 39373
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
