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.
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])).
Date ,Client Name ,no of meeting, Rank
How to get RAnk with in Sort order in Dimension leve in Pivot table
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.