Hi,
My data set looks like this
| Customer | Sales Date |
|---|
| Cust1 | 02/12/2017 |
| Cust1 | 03/12/2017 |
| Cust2 | 03/14/2017 |
| Cust2 | 02/15/2017 |
| Cust3 | 05/12/2017 |
| Cust3 | 06/12/2017 |
What i need to find out is
the first sales date of each customer and and then find the count of customer in each month to which their first sales date belongs to.
for example:
The first sales date of Cust1 and Cust2 are 02/12 and 02/15 respectively.
So the chart should say something like this.
Similarly the first sales date of Cust3 is 05/12 so May will have count of 1
| Month | Number of customer |
|---|
| Feb | 2 |
| May | 1 |
There is also a master calendar on Sales date available in the data model.
Thanks,
Jean
