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.

Sample Data
Col A Col B Col C (Rank)
orange 12/31/2016 1
orange 12/31/2016 1
orange 12/31/2016 1
orange 06/24/2015 4
orange 06/24/2015 4

 

Login