Defect Created by and Closed by count for Each Member

[#1]

Hi All,

i have a straight table in which Dimension is Member

and i want to show the number of defects created by and number of defects closed by each member in that table

PFA files for reference.

[sunny_talwar]

This is what you need?

[#3]

Hi the output is correct but i cant make any changes to the script i want to perform it on the frond end itself.

Thanks

[Kushal_Chawda]

may be

Dimension:

Member

Expression:

1) Created by

Count({<Member=p([Created By])>}[Defect ID])

2) Closed by

Count({<Member=p(Closed by)>}[Defect ID])

Link both your table on Defect ID

[#5]

In the above case if i select a member in the list box it is giving me 2 rows instead it should give me a single row for which i have selected in member.

Thanks