Set analysis - Date Ranges

[Anonymous]

Hello,

I am looking to create a table that will include accounts opened starting at specified date and including all accounts opened after that (to the current period).

Currently the user would select a range of the field [OpenDate] to include and the following set analysis provides the counts of accounts.

=Num(count(DISTINCT{<[SalesManager]={'Jon Doe'}>} [Account Number]),'#,##0')

I would like to have the user only need to select the first date and by default all other would be include - for example instead of selecting every date from 12/13/2012 to current - they would only select 12/13/2012 and by default any account opened after than until the current period would be included.

[sunny_talwar]

May be like this

=Num(count(DISTINCT{<[SalesManager] = {'Jon Doe'}, OpenDate = {"$(='>=' & Date(Min(OpenDate), 'MM/DD/YYYY'))"}>} [Account Number]), '#,##0')

[Anonymous]

Thank you for the quick response.  I was able to get the following to work where VStartDate = the [Open Date]:

[Open Date] = {'>=$(vStartDate)'}