Member name equals closed by Name

[#1]

Hi All,

I want to show sum of only those member whose name is equal to closed by name.

Expected Output:

Supervisor	Member	sum(Count)
		280
GO	A	10
GO	B	20
GO	D	30
GO	E	70

Note: we can't make any changes to the script

PFA qvw for Reference

Thanks in Advance

[sunny_talwar]

May be this

Sum(If(Member = [Colsed By], Count))

[sunny_talwar]

or create a flag

LOAD *,

  If(Member = [Colsed By], 1, 0) as Flag;

LOAD * INLINE [

    Supervisor, Member, Colsed By, Count

    GO, A, A, 10

    GO, B, B, 20

    GO, D, D, 30

    GO, D, B, 40

    GO, E, G, 50

    GO, E, F, 60

    GO, E, E, 70

];

and use this expression

Sum({<Flag = {1}>} Count)

[#4]

Thanks for the Quick reply but i also have some Set analysis written in the expression and i cant make any changes in the Script

[#5]

Thanks for the Quick reply but i also have some Set analysis written in the expression .

like

Sum({<Supervisor= {'GO'}>}Count)

[sunny_talwar · Accepted solution]

This

Sum({<Supervisor= {'GO'}>} If(Member = [Colsed By], Count))

or

Sum({<Flag = {1}, Supervisor= {'GO'}>} Count)

[Anil_Babu_Samineni]

How you are expecting 280 for Total Sum?? Is that is type error

[#8]

Thanks a lot