So my boss has asked me to make him a database so we can sort our Agents by ranking based on their sales. I have managed to get the database to import all the data needed correctly, the issue is now how best to utilize this data.
Essentially we have 2 reports that are reporting each product the agent sold. Each product is broken up into at least 2 categories on each report for example: Digi Cable U, Digi Cable I (U-upgrade, I install), would both be considered Video. Each individual sale for each agent is its own seperate row, so the same Agent could have 10 rows of data.
Here is what I'm having trouble wrapping my brain around. Essentially I need this condensed to do a total count for each product type for each agent (essentially each agent has one row with thier sales totaled for each product type for the month), and then the ability to sort this same data so that the person with the highest sell in percentage wins.
I have a feeling I'm going to need to utilize several queries to accomplish this, but I'm unsure of where to start. A push in the right direction would be helpful! Thanks so much!
1 1181
So my boss has asked me to make him a database so we can sort our Agents by ranking based on their sales. I have managed to get the database to import all the data needed correctly, the issue is now how best to utilize this data.
Essentially we have 2 reports that are reporting each product the agent sold. Each product is broken up into at least 2 categories on each report for example: Digi Cable U, Digi Cable I (U-upgrade, I install), would both be considered Video. Each individual sale for each agent is its own seperate row, so the same Agent could have 10 rows of data.
Here is what I'm having trouble wrapping my brain around. Essentially I need this condensed to do a total count for each product type for each agent (essentially each agent has one row with thier sales totaled for each product type for the month), and then the ability to sort this same data so that the person with the highest sell in percentage wins.
I have a feeling I'm going to need to utilize several queries to accomplish this, but I'm unsure of where to start. A push in the right direction would be helpful! Thanks so much!
Hi,
Here's the telling point
the same Agent could have 10 rows of data
Please read this very useful article, then walk around the block and read it again. No, seriously, it takes a couple of readings (unless you're Einstein).
It'll be worth it though.
Jim
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Neil Ginsberg |
last post by:
We're using SQL Server 7 with an Access 2000 MDB as a front end with ODBC
linked tables. I recently created a new set of tables for the app, and users
are complaining that unsaved data is being...
|
by: Shelly |
last post by:
(posted previously on comp.lang.php but no response received. Cross-posted
in the dreamweaver forum)
I am confused about what goes on with method POST. Here is an overview of a
my code,...
|
by: Glenn |
last post by:
Hi!
I've developed an app that displays multiple textbox and
combobox fields (most of which are autopostback) on a form
along with a submit button. My users find it confusing
when they change...
|
by: John J. Hughes II |
last post by:
I have a SqlDataAdapter.Fill filling a standard dataset and my code is
returning the below error. The "Error Loading data" is just a message my
code displays. "Error:" is the Exception.Message...
|
by: Justin |
last post by:
Here's a quick rundown of what I'm doing.
I'm filling an arraylist with data. Then I loop through a dataset and grab
a field to perform a search on the arraylist. Every time I find a match I...
|
by: Zytan |
last post by:
I have public methods in a form. The main form calls them, to update
that form's display. This form is like a real-time view of data that
is changing.
But, the form may not exist (it is...
|
by: James R. Davis |
last post by:
Yes, a newbie here.
Though I am making progress, slowly, I am also getting more and more
confused.
With ASP, when I wanted to do something as trivial as updating a visitor
counter, I...
|
by: APA |
last post by:
I have a ASP.NET 20 application that is suffering some pretty poor performance. I'm using the Web Application Stress tool to run a script and I see
some confusing performance data. As expected the...
|
by: Andy B |
last post by:
I saw this in the set accessor of a property:
Set(ByVal value As DataSet)
What exactly does the stuff in the () mean? VS complained about it not being
there when I took it out not knowing...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |