count repeated value

[sagarrahul]

hii need a help

just tell me how to count repeated value in below table .

ICD_CODE_LEVEL1_org

N41.0

N41.0

N41.0

R50.9

R50.9

R50.9

B54

B54

S82.1

B54

plesase help me in this

[sunny_talwar]

In script? or front end?

[Kushal_Chawda]

what is expected output?

[sagarrahul]

in expression

[sagarrahul]

this i want my output

ICD_CODE_LEVEL1_org	output
N41.0	3
N41.0	3
N41.0	3
R50.9	3
R50.9	3
R50.9	3
B54	3
B54	3
S82.1	1
B54	3

[elakkians]

Hi,

If its Front end Formula you can use

'=if(Count(test)>1,Count(DISTINCT test))'

if you need to do in script plz check the demo app which i have attached. !

[MK_QSL]

Something like this?

[sunny_talwar]

Why do you want the ICD_CODE_LEVEL1_org to be repeated? Why not this?

ICD_CODE_LEVEL1_org	output
N41.0	3
R50.9	3
S82.1	1
B54	3

If the above work, then this should do it:

Dimension: ICD_CODE_LEVEL1_org

Expression: Count(ICD_CODE_LEVEL1_org)

[sagarrahul]

i want just output bro 

[sagarrahul]

sunny thanks for ur help n time

but this ICD_CODE_LEVEL1_org are given in wildmatch then how to count repeated values