0 - 2 of 2 tags for ordered analytic functions

 

Hi.  Hoping you can help me with another issue.  I have some data similar to that shown below, and would like to rank the states - 1-50 based on their sales totals.

 

cust,state,sls,State_Sls_total,desired results,observed results

a,MN,1,6,2,5

b,MN,2,6,2,5

c ,MN,3,6,2,5

d,WI,1,10,1,1

While organizations store temporal data that is in effect over a period of time, efficiently querying that data to provide business insights can be a challenge.