how to sort top 5 within Pivot table

[Anonymous]

Group	Vendor	ID Counts
A	1	46
A	2	13
A	3	200
A	4	12
A	5	2

I have a pivot table where I am counting IDs (3rd column above) for top 5 vendors grouping by Group. Within Groups, only A is shown here, I want the ID Counts to sort in descending order. So in the table above it sud be in 200,46,13,12,2 order.

I am using the following expn to count IDs: sum(aggr(if((rank(count({ fieldA = {1}>} ID))) <=5,count({<FieldA = {1}>} ID)),Group, Vendor))

How do I make it to sort within the group with max count at the top?

[Anonymous]

Thank you sunindia‌  and swuehl‌ for helping out. I will implement these in my app and update.

[Anonymous]

Swuehl,

It works almost perfectly. But my actual app has one more condition; the order of the Group is not "Normal".

from the image below: The user wants the sort order to be B -101, A -102, D -103, C -104. How to make this possible.

I thought we had this under control. Thanks for your help again.

[swuehl · Accepted solution]

Maybe use a $Sort expression like

Pick(Dimensionality(),

Subfield([$(=GetObjectField(0))],'-',2),

-Column(2)

)