rank and sort in a straight table

[jpsathya]

Hello,

I have a requirement where I have to show top 3 requests ,for top 3 requests the table should display top 3 response title depending on the top 3 requests only(if there are 2 requests with same value then it should show by alphabetical order), here is the screenshot of the which I am unable to sort with the top values and group by requests:

I gave for the

1st dimension:

aggr(if(rank(sum ({<$(vAux.Quarter),CASE_TYPE={'Canada MIR'}>}CASE_COUNTER),4)<=3,[Response Category]),[Response Category])

2nd dimension:

=aggr(if(rank(sum ({<$(vAux.Quarter),CASE_TYPE={'Canada MIR'}>}CASE_COUNTER),4)<=3,Response_Title),[Response Category],Response_Title)

expression:

sum({<$(vAux.Quarter),CASE_TYPE={'Canada MIR'}>}CASE_COUNTER)