how to group according to the asset type count

[tommyl]

Hello,

I have a data like:

customerid	assetType
1	pstn
2	pstn
3	pstn
4	adsl
1	adsl
2	adsl
3	pstn
4	adsl

i want to show grouping in a pie chart as below:

PSTN	PSTN and ADSL	ADSL
1	2	1

i cannot solve the dimension. In order to get this grouping what should i write in dimension? i did this but the counts does not match with db:

=aggr(concat(distinct assetType,' and '), customerid)

[Anil_Babu_Samineni]

Don't create 2 threads for same issue https://community.qlik.com/t5/New-to-Qlik-Sense/Grouping-assettypes-by-customer/m-p/1643589/highligh...