How to give Date wise Rank

[Anonymous]

Hi ,

I hvea meeting id, client name, Date dimension is there.

I need want to do date and client name and meetin id  wise rank.

How it will get?

[Anonymous]

Hi

try this :

RANK(ONLY({1} meeting id))  

or

do you have any field to be aggregated (numerical ) ?

[Anonymous]

aggr (RANK(count(meeting id)),date) 

[Anonymous]

I have already meeting id count based on the client name.

And i am using the two calendar objects (Date range purpose).

When i give date range cmng the rank only in between.

How it will get in pivot table