Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
This is what you need?
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
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
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