ranking

[SomeDudeAtWork]

Hi all,

I'm trying to set up a ranking system. So as you can see below I have each employees sales mapped to each hour of the day, to gather which hour they are most effective in and also to gauge which hour our highest in flow of customers are in. 
I have tried =max([Sales.Employee_Name],'Green'). but to no avail. 

Any help on this would be greatly appreciated. 

[sunny_talwar]

May be this

If([Sales.Employee_Name] = Max(TOTAL <Employee_Name> [Sales.Employee_Name]), Green())