Oracle Rank Over Order function in Spotfire

Hi All,

I am trying to implement  rank() over (partition by col A order by col B desc nulls last) in spotfire. Any help here?

Below is the data format and col C is what I want to achieve in Spotfire.