Aggregation issue in expression.

[infosense_devel]

Hello,

     my desire result given in below table.

Customer Name	Customer Number	Country	Country Count
a	1001	USA	2
a	1001	China	2
b	1002	USA	1
c	1003	Spain	4
c	1003	USA	4
c	1003	China	4
c	1003	Italy	4

for Country Count i am using below expression but it is not working for me.

=Aggr(Count(Country ),Customer Name,Customer Number)

it is showing data as below for customer "a".

Customer Name	Customer Number	Country	Country Count
a	1001	USA	0
a	1001	China	2

Thanks in advance.

[sunny_talwar · Accepted solution]

Try this

Count(DISTINCT TOTAL <[Customre Name]> Country)

or this

=Aggr(NODISTINCT Count(DISTINCT Country),Customer Name,Customer Number)