RANKX with condition

Hello experts! I need help with RANKX. I have a sales table :  Date Emp Group Sales 31-Dec-23 Lana Sales 650,000 31-Dec-23 Nick Sales 500,000 31-Dec-23 Mary Sales 400,000 ...