Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
my source like below..
How to get cont MeetingA and Meeting B
client | meetingcount | meetingtype |
ddd | 5 | MeetingA |
ddd | 6 | MeetingB |
ddd | 7 | MeetingC |
sss | 8 | MeetingA |
sss | 9 | MeetingB |
sss | 10 | MeetingC |
aaa | 11 | MeetingA |
aaa | 12 | MeetingB |
aaa | 13 | MeetingC |
i am excepted o/p is
client meetingtype meetingcount total
aaa MeetingA 11 24
aaa MeetingB 12 27
aaa MeetingC 13 13
ddd MeetingA 5 24
ddd MeetingB 6 27
ddd MeetingC 7 7
sss MeetingA 8 24
sss MeetingB 9 27
sss MeetingC 10 10
Perhaps this?
Sum(TOTAL <meetingtype> meetingcount)
Hi Anil,
Weneed only count in Meeting A,Meeting B.
Thanks,
May be this
If(Match(meetingtype, 'Meeting A', 'Meeting B'), Sum(TOTAL <meetingtype> meetingcount), Sum(meetingcount))
Like this?
Sum(TOTAL <meetingtype> {<meetingtype={'MeetingA','MeetingB'}>} meetingcount)
Hi,
It should be work,
PFA
This is a good way also and you can add this to the above expression (without needing to use an if statement)
Sum(TOTAL <meetingtype> {<meetingtype = {'MeetingA','MeetingB'}>} meetingcount) +
Sum({<meetingtype -= {'MeetingA','MeetingB'}>} meetingcount)
hi anil ,
After using ur expression only count Meeting,Metting B is commng Meeting C is gone.
I am expacted o/p MeetingA and Meeting B count and Meeting C asusal data.
Thanks,
Did you try one of these?
If(Match(meetingtype, 'Meeting A', 'Meeting B'), Sum(TOTAL <meetingtype> meetingcount), Sum(meetingcount))
Sum(TOTAL <meetingtype> {<meetingtype = {'MeetingA','MeetingB'}>} meetingcount) +
Sum({<meetingtype -= {'MeetingA','MeetingB'}>} meetingcount)
Hi
I am
i am excepted o/p is like this (Not for all sum )
client meetingtype meetingcount total
aaa MeetingA 11 24
aaa MeetingB 12 27
aaa MeetingC 13 13
ddd MeetingA 5 24
ddd MeetingB 6 27
ddd MeetingC 7 7
sss MeetingA 8 24
sss MeetingB 9 27
sss MeetingC 10 10