How to get Count in Pivot table

[Anonymous]

Hi ,

I hve a MeetinId, Clint name ,Event Date is there,I neeed want to Count of meetingId based on Client name .

How it will you get in Dimension level.

Thanks,

[Anil_Babu_Samineni]

Does it mean this as Calc. Dimension?

Aggr(Count(MeetingId), [Client Name])

[Anonymous]

could you please elaborate more on this..

[darrell_tobin]

Just count will count meetingid by the two dimensions Client name ,Event Date

EXAMPLE

count(meetingId )

Using aggr function you can count the total meetingids for the Client name field

EXAMPLE

=aggr(count(meetingId), [Clint name])

Please set as correct if this is useful

[Anonymous]

Thank you Anil .It's working Good

[Anil_Babu_Samineni]

Please close this thread by flag "Correct Answer"