Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this
Count(DISTINCT TOTAL <[Customre Name]> Country)
or this
=Aggr(NODISTINCT Count(DISTINCT Country),Customer Name,Customer Number)
Try this
Count(DISTINCT TOTAL <[Customre Name]> Country)
or this
=Aggr(NODISTINCT Count(DISTINCT Country),Customer Name,Customer Number)