Another Rank Question

[Guest_imported]

Thanks for feedback with regards to my previous posting for rank functionality. I did use Running Total Field to get my rank for one field. How can I get multiple fields rank in a report? Below is the structure of the table:

I have a table that has following data:

Dept_ID; Expenses; Salary; Misc;
ACCT; 100; 5; 8;
ACCT; 200; 10; 8;
ACCT; 80; 70; 90;
MGMT; 500; 50; 50;
MGMT; 75; 35; 15;
MGMT; 90; 16; 20;
FIN; 50; 29; 5;
FIN; 20; 73; 99;

I would like the Crystal Report to rank these Expenses,Salary and Misc (Descending in Order) group by Dept_ID as follow:

Dept_ID; Expenses; RankExp; Salary; RankSal; Misc; RankMis;
ACCT; 100; 2; 5; 3; 8; 2;
ACCT; 200; 1; 10; 2; 8; 2;
ACCT; 80; 3; 70; 1; 90; 1;
MGMT; 500; 1; 50; 1; 50; 1;
MGMT; 75; 3; 35; 2; 15; 3;
MGMT; 90; 2; 16; 3; 20; 2;
FIN; 50; 1; 29; 2; 5; 2;
FIN; 20; 2; 73; 1; 99; 1;

Thanks!!!!!