GETPIVOTDATA formula to return highest rank

[ronicaroman]

I have a pivot table with a parent and children rows. I need a formula to return the highest, 2nd highest, 3rd - 10th highest ranks from from columns A-C

Pivot Example:

Business 1	Transaction Count %	Approval Rate	Transaction Count Ranking
Bank A	25%	80%	1
Bank B	22%	85%	2
Bank C	10%	45%	3
Bank D	5%	75%	4
Bank E	3%	90%	5
Business 2
Bank A	45%	90%	1

GETPIVOTDATA Requested results for Bank, Transaction Count %, and approval rate on a separate excel sheet for "Business 1"

Ranking	Bank	Transaction Count%	Approval Rate
1	Bank A	25%	80%
2	Bank B	22%	85%

Appreciate you help!