display top3 owners defect counts

[Anonymous]

Hi All,

I have defect table and displaying top3 defect owners name list in single text object.

Now I want to display top3 owners defect counts also in the same text object.

below one currently using for displaying owners name list,

Concat(IF(aggr(Rank(Sum(passed)),executedby)<=4,executedby & chr(10)))

IF ANYONE HAVE IDEA TO MODIFY THE ABOVE EXPRESSION,PLS SHARE

THANKS,

Prakash

[jagan]

Hi,

Try like this

Concat(IF(aggr(Rank(Sum(passed)),executedby)<=4,Sum(passed) & chr(10)))

Concat(IF(aggr(Rank(Sum(passed)),executedby)<=4,executedby & ' ' & Sum(passed) & chr(10)))

Hope this helps you.

Regards,

Jagan.

[MK_QSL]

=CONCAT(IF(Aggr(Rank(SUM(passed),4),executedby)<=3,executedby &CHR(10)),'',-Aggr(SUM(passed),executedby))