Duplicate Count on the basis of select list of required field

[Anonymous]

Dear All,

Can anyone help me in getting the duplicate count on the basis of the select list of a field?

1) Used Straight Table

2) Dimension: =if(Match(CREATED_SYSTEM,'CLA','GOL','LOI','QUT','SEM','SITE-BULK'),CREATED_SYSTEM)

3 Expression: I want duplicate count only of above list        [ =Count(GID3)-Count(DISTINCT GID3)  ]-- Duplicate Count

For example

CLA---- Duplicate Count

Gol----- Duplicate Count

LOI-----Duplicate Count etc....

[Anonymous]

Thanks Stefan,

Little trick but a great help to me.

[shanky1907]

Please mark the solution as correct to end the thread.

[Anonymous]

Can you please tell me the way , How it can be done

[shanky1907]

There should be a Star mark as 'Correct Answer' on my reply. Please press that

[Anonymous]

Hi Shashank ,

Yours ans is not showing correct symbol .

I think Stefan answered first and i marked as helpful .

Might be for this reason you star symbol is not reflecting .

Although, Thanks very much for the help.