Set Analysis Expression that displays the Count of Distinct names that appear more than once

[romeoek]

Hello I would like to write an expression that only displays the count of records that appear more than once.

i.e :-

Table
Number	Count
Anne	1
Mark	1
Anne	1
John	1
Peter	1
Peter	1
Peter	1

Result

Distinct Number	sum(count)>1
Peter	3
Anne	2

The script I am currently using is = Count ({<Value = {"= Sum (Count) > 1"}>} Distinct Name) but does not give the correct result

[romeoek]

I have also tried this script but still does not give the correct result

=Count( if( (aggr(Sum(count_names),name)) > 1, name ) )

[adrienL]

You could try this on maybe:

dimension : if(count(Names)>1, Names)
measure : count(Names)

[romeoek]

its's a measure and count(names) would count all the names that appear and not the ones that appear more than once