AnsweredAssumed Answered

Filtering Sales By Salesperson

Question asked by mgxdigital on Apr 8, 2009
Latest reply on Apr 8, 2009 by philmodjunk

Title

Filtering Sales By Salesperson

Post

I have 5 fields.

One is called "Billed Total" and it is in a db called "Packing Slips"

 

4 are in a db called "Customers" and  they are our salespeople

Salesperon_Doug

Salesperon_Dan

Salesperson_Sharon

Salesperson_Justin

 

These 2 databases are related through a common feild of "Company" and according to what salesperson is assigned to the company, the salesperson's name shows up on the invoice.

 

The Billed Total does not have anything to do with the salesperson, it is just a calculation based on how much product shipped out x the price per unit.

 

I've set up calculations before that shows our sales per week and per month, but is it possible to show an indidual salesperons sales per day, week, month through a calcualtion?

Outcomes