New customers

[PapaJapa]

Hello, I'm having trouble counting new customers. The chart script only shows data for the current month. Formula: "Number of new customers" below:

=count({<Year=, Month=, [CustomerID]= E({<MonthField={"$(=max(MonthField)-1)"}>}), MonthField={"$(=max(MonthField))"} >}distinct [CustomerID])

I would like the table to be updated with each selection of the month / year range.

Please help.

PapaJapa

[jwjackso]

Try the Above  function.  If Count(Distinct [CustomerID]) is the number of customers, then Count(Distinct [CustomerID]) - Above(Count(Distinct [CustomerID])) should be the new customers.

[sunny_talwar]

May be this

Sum(Aggr(
    If([CustomerID] <> Above([CustomerID]), 1, 0)
, [CustomerID], YearField, MonthField))