HOw to get No of meetings Based on the Client

[Anonymous]

Hi Experts,

My source like below...    

Client Name	Event Type	Meeting Type Code	Meeting id
xxx	Roadshow	1X1	1000H
aaa	NDM	2X1	1001H
yyy	Office	1X1	100H
aaa	Non Deal Management	3X1	1002H
xxxx	Roadshow	1X1	10004H
yyy	office	Grp	1000H

I need No of meeting based on the Client ...i

[Chanty4u]

Use Dim: ClinetName

Measure: count(MeetingID)   or count(MeetingTypeCode)

[tresesco]

Straight table:

Dimension: [Client Name]

Exp: Count(Distinct [Meeting id] )

[Anonymous]

But here All Event types is not calculated(Roadshow)

[Chanty4u]

what is the exact output you want to see?

[Anonymous]

i tried below logic

=Aggr( Count({<[Event Date]={">=$(=Date(vStartDate,'MM/DD/YYYY'))<=$(=Date(vEndDate,'MM/DD/YYYY'))"},[Event Type]={'Non Deal Management',Office', 'Road show'}>} [Meeting Id]),[Client Name])

but i am not getting excatly count based on the client

but some client meeting count is matched.

[Anil_Babu_Samineni]

Provide some data

[sunny_talwar]

Is this in a text box object? May you need to add an outer aggregation?

Sum({<[Event Date]={">=$(=Date(vStartDate,'MM/DD/YYYY'))<=$(=Date(vEndDate,'MM/DD/YYYY'))"},[Event Type]={'Non Deal Management',Office', 'Road show'}>} Aggr(Count({<[Event Date]={">=$(=Date(vStartDate,'MM/DD/YYYY'))<=$(=Date(vEndDate,'MM/DD/YYYY'))"},[Event Type]={'Non Deal Management',Office', 'Road show'}>} [Meeting Id]),[Client Name]))