Help with sorting and ranking data

[jrafaelm]

Hello,

Here how my main report looks like

status employee Type
A luis mr
A maria mr
A maria la
A luis d7
A luis mr

I want to create a formula that sorts by type and then returns top 3
employees name and results next to their names.

like this:

Name Type Totals
luis mr 2
maria mr 1

Name Type Totals
maria la 1
luis la 0

name type totals
luis d7 1
maria d7 0


Your help will be greatly appreciated