how to get count of a name that is appearing multiple times in a column

[pradeep30403]

hello,

i was trying to get count of a name that is repeating multiple times in a column 

Can anyone suggest me how to get below desire output in sap analytics cloud (SAC).

for example: 

Country
US
US
US
US
US
Canada
Canada
Canada
Canada
Brazil
Canada
Brazil
Brazil
Brazil
India
India
India
India
India
US
Brazil
US
Canada
US

Customer Group Code Name	Count of Customer Group Code Name
ATI ALLVAC LTD	2
CARRIER	8
CITIGROUP	180
GALLAGHER	6
L’OREAL	16
MMC	98
NXP	2
OTIS	1
PARAMOUNT	60
SCHINDLER HOLDING LTD.	25

[JBARLOW]

can you share an example xls file with data - can be any data as long as it ties in to your requirement.
I can provide a couple of solutions, but not fully clear on the ask.

[pradeep30403]

@JBARLOW

[Yogeshwar_M]

Hi User,

Please refer below answer via scripting it is possible to count which country repeated how many times.

https://community.sap.com/t5/technology-q-a/sap-analytics-cloud-property-count/qaq-p/13982095

Kindly upvote if you find it helpful!

Thanks.

[N1kh1l]

@pradeep30403 

Try creating a calculated measure of type Aggregation using Dimension Count. You can see an example in below thread.

https://community.sap.com/t5/technology-q-a/how-to-count-a-dimension/qaq-p/12650575

Nikhil

[pradeep30403]

@N1kh1l

I was trying to get the multiple count of the dimension value, the approach which you are suggesting me it is resulting in giving unique.