distinct count customer up until the max date

[q11hhg]

Hi there,

I am trying to get the number of customers historically up until the date selection in the report.

Could you please help me?

Count(distinct{$<[Document Date] = {">=$(=Date(Max([Document Date]))"}>}[CustomerID])

[Taoufiq_Zarra]

@q11hhg  Maye be like :

=Count({1<[Document Date]={">=$(=getfieldselections([Document Date]))"}>} distinct [CustomerID])

if  iunderstood correctly

[q11hhg · Accepted solution]

HI @Taoufiq_Zarra  Thanks for the help, I have figured out:

Count(distinct{<[Document Date] = {"<=$(=Max([Document Date]))"}>}[CustomerID])