Distint count

[#1]

Hi All,

I have following requirement.

I have field name Customer. when I select three month Jan, Feb, Mar I want to list down the customers common in three months and count for the same.

i.e customer common in all selected three month

[Jason_Michaelides]

Just create a listbox for customer which will show the common customers in white when you select the months.  To show a count add an expression to the listbox (v10 and later) with COUNT(DISTINCT CustomerID).  Bear in mind that Distinct Counts are pretty inefficient so if you have a very large dataset you may notice performance issues.

Hope this helps,

Jason

[#3]

Hi Jason,

I know that but this will give me count off all the customer..

I want count of only common..i.e suppose there is customer A which is present in all selected months.. so my count should be 1 i.e A