Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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])
Don't create duplicate for single issue - Re: How to get Count in Pivot table
How to get rank?
Provide sample as request by Sunny
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])).
Won't know unless you share a sample or an image or something which can help us show your issue
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
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.
Hi Sunny ,
When i put above expression in Rank output getting like this.....
Rank
12
13-17
187-198
316-321
Thanks