Yes, it is possible. Mock up a packaged workbook using your dataset, and look into the RANK() functions (Table Calculations). If you're not familiar with Table Calcs, I can help you get it started/set up once a workbook is posted. Cheers!
You may just use the same calculation twice, with different scopes/directions via the "Compute Using" or specific dimensions selected when editing the table calculation.