How to get repeted values only?

[jsingh71]

I have below Report in my application. I want to display only repeted PNumber Records.

How can I get this. Thanks in advance.

[tresesco]

if your original table is so, you can try calculated dimension:

If(Count(PNumber)>1, PNumber)

Edit: no DISTINCT

[jsingh71]

Hi tres,

Thanks for reply. I tried this but its not working.

[tresesco · Accepted solution]

PFA

[jsingh71]

Thank you very much tres.