how to add and exclude row data in qlikview

[Anonymous]

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

[sasikanth]

HI,

try this expression

If(meetingtype='MeetingC',Sum(meetingcount), Sum({<meetingtype={'MeetingA','MeetingB'}>} TOTAL <meetingtype> meetingcount))

[Anonymous]

Thank you so much Sasi.

It's working fine

[Anil_Babu_Samineni]

I believe, Sunny's approach also reached this case. Or, Some change needed

If(Match(meetingtype, 'Meeting A', 'Meeting B'), Sum(TOTAL <meetingtype> {<meetingtype = {'MeetingA','MeetingB'}>} meetingcount), Sum(meetingcount))