Pivot Table question

jduluc12 — Fri, 08 Dec 2017 13:38:04 GMT

Hi,

My data set looks like this

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

Re: Pivot Table question

sunny_talwar — Fri, 08 Dec 2017 13:46:52 GMT

May be this

Dimension

Aggr(Month(Min([Sales Date])), Customer)

Expression

Count(DISTINCT Customer)

sunny_talwar — Fri, 08 Dec 2017 13:48:21 GMT

Check attached