How to get Rank in Dimension level

[Anonymous]

HIi,

I have a count of meetinigId and ClientName and Date fields .

How to get rank Based on the meetingId and Client Name in Dimension level.

Thanks,

[sunny_talwar]

Your requirement isn't very clear... would you be able to share a sample? Or try something like this

Aggr(Rank(Count(meetingId)), meetingId, [Client Name])

[Anil_Babu_Samineni]

Don't create duplicate for single issue - Re: How to get Count in Pivot table

[Anonymous]

How to get rank?

[Anil_Babu_Samineni]

Provide sample as request by Sunny

[Anonymous]

When i was trying above expr in dimension level it's getting all Clintname is 'First rank 'only.

And How to sort in Ranks in Dimension level in pivot table.

I tried (=aggr(rank(Count([Meeting Id]),1,1),[Client Name])).

[sunny_talwar]

Won't know unless you share a sample or an image or something which can help us show your issue

[Anonymous]

Hi Sunny,

Sample Data

Date ,Client Name ,no of meeting, Rank

12/12/2016, XYZ,100,2

12/01/2017, YXZ,200,1

01/02/2017,ABC,75,3

Like this.....

How to get RAnk with in Sort order in Dimension leve in Pivot table

Thanks

[sunny_talwar]

Your calculated dimension looks okay to me

Here, I am guessing that you gave me a no of meeting as a field, where as you should have it as count(meetingid)... so if that is true, the calculated dimension looks good to me.

[Anonymous]

Hi Sunny ,

When i put above expression in Rank output getting like this.....

Rank

12

13-17

187-198

316-321

Thanks