Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This
Sum({<Supervisor= {'GO'}>} If(Member = [Colsed By], Count))
or
Sum({<Flag = {1}, Supervisor= {'GO'}>} Count)
May be this
Sum(If(Member = [Colsed By], Count))
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)
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
Thanks for the Quick reply but i also have some Set analysis written in the expression .
like
Sum({<Supervisor= {'GO'}>}Count)
This
Sum({<Supervisor= {'GO'}>} If(Member = [Colsed By], Count))
or
Sum({<Flag = {1}, Supervisor= {'GO'}>} Count)
How you are expecting 280 for Total Sum?? Is that is type error
Thanks a lot