Show only duplicate values in table chart

[Shahzad_Ahsan]

Hi Everyone

I need to show only duplicate values in table chart.

My table is like this

Id	Name
101	A
102	A
103	A
104	B
105	B
106	C
107	D
108	E
109	F
110	G
111	G
112	H
113	I

I need like this in table chart

Id	Name
101	A
102	A
103	A
104	B
105	B
110	G
111	G

[maxgro · Accepted solution]

try a straight table with

dimension

    Id

expression

    only({$ <Name={"=count(Name)>1"}>} Name)

[Shahzad_Ahsan]

Hi Massimo

This is what I needed

Thank you

[Shahzad_Ahsan]

Hi Massimo

I have one more question related to this.

Can we count number of duplicated rows as KPI , that means 7

[Shahzad_Ahsan]

Its ok

I got it

Count(Aggr( only({$ <Name={"=count(Name)>1"}>} Name),Id))