Assuming you have a Calendar table with your months, and a Salesman table that lists your Salesmen and a Sales table that lists the sales, you should be able to put the month column from the calendar table, the salesman column from the salesman table and the sale amount from the sales table all on a matrix and set the sales amount column to "Sum". That will give you the total sales for the saleman for the month.
The first part of your question is trickier. First you have to define "new customer". Does it mean never had a purchase ? or didn't purchase last year ? there are many ways of defining it.
The next issue is do you mean "new customer" for a particular sales man... or "new customer" in terms of any sales to that customer by any salesman ? One way you will have to use CALCULATE to get ALL the sales and then filter for sales that happened before the current date, the other way you will have to add a filter for the salesman, so you can see if the customer ever bought from a particular salesman before.
Did this post answer your question? Mark it as a solution so others can find it!Help when you know. Ask when you don't!
Join the conversation at
We Talk BI find out more about me at
Slow BI
