RANKX by multiple group

HI   i have this table: Material tot value € sub-category Vendor a 100 CM1 x a 10 CM2 x b 20 CM2 g b 200 CM3 y c 30 CM1 r c 300 CM3 z   i would like ...