Count distinct Customers

[#1]

In the Excel file the data is:

Customer

TypeDoc

Date

In 2 controls I select 2 dates: Initial date and Final date

I need to count how many different customers there are between the dates, and TypeDoc = 'TA'

Example:

Initial Date: May 02, 2012 <-- In variable VarDate1

Final Date: May 31, 2012 <-- In variable VarDate2

TypeDoc = 'TA'

The answer is 46 customers, but I can't create a aggr expresion that show it.

I have this but don't works:

Count(DISTINCT aggr(If(Date >= $(VarDate1) and Date <= $(Vardate2) and TypeDoc= 'TA',Customer), Customer))

Thanks.

[jagan · Accepted solution]

Hi,

Please find attached file for solution.  I used this expression

=Count({<CustomerDate={'>=$(=VarDate1)<=$(=VarDate2)'}, TypeDoc= {'TA'}>} DISTINCT Customer)

VarDate1 = MakeDate(2012, 5, 2)

VarDate2 = MakeDate(2012, 5, 31)

Regards,

Jagan.

[#3]

Thanks.!!.

[jagan]

HI,

Please close the discussion by clicking Correct Answer button to my post if it solves your purpose, it helps others to find the answer.

Regards,

Jagan.