Aggregation issue in expression.

infosense_devel — Tue, 22 Aug 2017 15:32:26 GMT

Hello,

my desire result given in below table.

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".

Thanks in advance.

Re: Aggregation issue in expression.

sunny_talwar — Tue, 22 Aug 2017 15:36:29 GMT

Try this

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

or this

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