Totals by individual

W

wthoffman

I want to provide dollar sales totals by each salesperson for one product,
after sort by salesperson how do I get totals for each person?

Thank you
 
W

Wayne-I-M

Sort by product and then by salesperson
In the product header put the name/ID/details of the product.
In the salesperson put the details of the sales person and sum of sales etc
Use the details row to show sales (which are summed in the salesperson header)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dollar sales by salesperson 6
Sub-report total to main report 9
Date Format and Sumproduct 9
Excel 2007: Three comparisons 1
can't find the how-to steps for query results I need 1
averages without zero 6
Report and subreport pulling from same query. 2
totals for multiple fields 1

Top