Task:

List the orders for the year 2013. Include the percentage rank of the order amounts within each month sorted by amount.
Click here for details on PERCENT_RANK.
 
 408 Records
Month Customer TotalAmount Percent Rank
1 dupa Accorti 49.80 0
1 dupa Latimer 102.40 0.03125
1 dupa Moroni 192.00 0.0625
1 dupa Cruz 231.40 0.09375
1 dupa Moncada 319.20 0.125
1 dupa Saavedra 338.20 0.15625
1 dupa Koskitalo 372.00 0.1875
1 dupa Izquierdo 400.00 0.21875
1 dupa Roulet 480.00 0.25
1 dupa Braunschweiger 485.00 0.28125
1 dupa Pipps 651.00 0.3125
1 dupa Koskitalo 720.00 0.34375
1 dupa Lincoln 802.00 0.375
1 dupa Mendel 1005.90 0.40625
1 dupa Fonseca 1020.00 0.4375
1 dupa Pfalzheim 1194.00 0.46875
1 dupa Lincoln 1208.50 0.5
1 dupa Batista 1273.20 0.53125
1 dupa Rancé 1622.40 0.5625
1 dupa Rovelli 1675.00 0.59375
1 dupa McKenna 1748.50 0.625
1 dupa Kloss 1814.80 0.65625
1 dupa Parente 1897.60 0.6875
1 dupa Carvalho 2018.20 0.71875
1 dupa Roulet 2123.20 0.75
1 dupa Holz 2208.00 0.78125
1 dupa Lincoln 2523.00 0.8125
1 dupa Mendel 2713.50 0.84375
1 Black Devon 3063.00 0.875
1 dupa Wilson 3868.60 0.90625
1 dupa Mendel 5796.00 0.9375
1 dupa Fresnière 11493.20 0.96875
1 dupa Petersen 14000.00 1
2 dupa Berglund 174.90 0
2 dupa Larsson 234.80 0.03571428571428571
2 dupa Josephs 273.60 0.07142857142857142
2 dupa Larsson 360.00 0.10714285714285714
2 dupa Koskitalo 393.00 0.14285714285714285
2 dupa Roulet 414.00 0.17857142857142858
2 dupa Gutiérrez 443.40 0.21428571428571427
2 jhon Hardy 453.00 0.25
2 dupa Saveley 531.40 0.2857142857142857
2 dupa Moroni 537.60 0.32142857142857145
2 dupa Josephs 567.50 0.35714285714285715
2 Black Brown 631.60 0.39285714285714285
2 dupa Cramer 656.00 0.42857142857142855
2 dupa de Castro 851.20 0.4642857142857143
2 dupa Limeira 914.40 0.5
2 dupa Berglund 1031.70 0.5357142857142857
2 dupa Fresnière 1078.00 0.5714285714285714
2 dupa Cramer 1584.00 0.6071428571428571
2 dupa Saveley 1688.00 0.6428571428571429
2 dupa Phillips 1755.00 0.6785714285714286
2 dupa Mendel 1792.00 0.7142857142857143
2 dupa Citeaux 1838.20 0.75
2 dupa González 2051.60 0.7857142857142857
2 dupa Pavarotti 2096.00 0.8214285714285714
2 dupa Citeaux 2210.80 0.8571428571428571
2 dupa Koskitalo 2684.00 0.8928571428571429
2 dupa Cartrain 3891.00 0.9285714285714286
2 dupa Kloss 4277.40 0.9642857142857143
2 dupa Pavarotti 5793.10 1
3 dupa Steel 147.00 0
3 Black Brown 156.00 0.034482758620689655
3 dupa Hernández 182.40 0.06896551724137931
3 dupa Afonso 216.00 0.10344827586206896
3 Black Bennett 230.40 0.13793103448275862
3 dupa Rovelli 235.20 0.1724137931034483
3 dupa Rodriguez 305.30 0.20689655172413793
3 muter Ashworth 386.20 0.2413793103448276
3 dupa Saveley 496.00 0.27586206896551724
3 dupa Pipps 502.20 0.3103448275862069
3 dupa de Castro 672.00 0.3448275862068966
3 dupa Jablonski 704.00 0.3793103448275862
3 dupa Cartrain 713.30 0.41379310344827586
3 dupa Cramer 717.60 0.4482758620689655
3 dupa Rancé 756.00 0.4827586206896552
3 dupa Carvalho 925.10 0.5172413793103449
3 Black Kumar 1051.20 0.5517241379310345
3 dupa Jablonski 1125.50 0.5862068965517241
3 dupa Fernández 1249.10 0.6206896551724138
3 dupa Hernández 1272.00 0.6551724137931034
3 muter Ashworth 1328.00 0.6896551724137931
3 dupa Limeira 1472.00 0.7241379310344828
3 dupa Franken 1560.00 0.7586206896551724
3 dupa Izquierdo 1760.00 0.7931034482758621
3 dupa Cartrain 1770.80 0.8275862068965517
3 dupa Lebihan 1820.80 0.8620689655172413
3 dupa Rodriguez 1848.00 0.896551724137931
3 dupa Ibsen 2719.00 0.9310344827586207
3 dupa Hernández 3163.20 0.9655172413793104
3 dupa Wilson 10495.60 1
4 dupa Moos 136.80 0
4 dupa Fresnière 147.90 0.03333333333333333
4 dupa Moos 149.00 0.06666666666666667
4 dupa Bergulfsen 200.00 0.1
4 dupa Domingues 200.00 0.1
4 dupa Simpson 225.50 0.16666666666666666
4 dupa Pfalzheim 240.00 0.2
4 dupa Tannamuri 278.00 0.23333333333333334
4 Black Crowther 352.00 0.26666666666666666
4 dupa Cramer 462.00 0.3
4 dupa Roulet 550.80 0.3333333333333333
4 dupa Hernández 575.00 0.36666666666666664
4 dupa Cruz 618.00 0.4
4 dupa Roulet 676.00 0.43333333333333335
4 dupa Fernández 816.30 0.4666666666666667
4 dupa kraków 881.25 0.5
4 dupa Lincoln 896.00 0.5333333333333333
4 dupa Afonso 912.00 0.5666666666666667
4 dupa Messner 1380.60 0.6
4 dupa Jablonski 1388.50 0.6333333333333333
4 dupa González 1412.00 0.6666666666666666
4 dupa McKenna 2048.50 0.7
4 dupa Wang 2356.00 0.7333333333333333
4 dupa Müller 2427.50 0.7666666666666667
4 dupa McKenna 2614.50 0.8
4 dupa Messner 2657.80 0.8333333333333334
4 dupa Lebihan 3000.00 0.8666666666666667
4 dupa Angel Paolino 4150.05 0.9
4 dupa Pavarotti 4735.44 0.9333333333333333
4 dupa Mendel 8623.45 0.9666666666666667
4 dupa Kloss 10588.50 1
5 dupa Moncada 110.00 0
5 muter Ashworth 139.80 0.03225806451612903
5 dupa Steel 210.00 0.06451612903225806
5 dupa Josephs 275.10 0.0967741935483871
5 muter Ashworth 355.50 0.12903225806451613
5 dupa Snyder 396.20 0.16129032258064516
5 dupa Wilson 417.20 0.1935483870967742
5 dupa Cramer 493.80 0.22580645161290322
5 dupa Messner 517.40 0.25806451612903225
5 dupa Pedro Freyre 749.00 0.2903225806451613
5 Black Devon 796.35 0.3225806451612903
5 dupa Lebihan 846.00 0.3548387096774194
5 dupa Hernández 880.50 0.3870967741935484
5 dupa Dewey 946.00 0.41935483870967744
5 dupa Koskitalo 1344.00 0.45161290322580644
5 dupa Koskitalo 1546.30 0.4838709677419355
5 dupa Kloss 1670.00 0.5161290322580645
5 dupa González 1770.00 0.5483870967741935
5 dupa Pfalzheim 1819.50 0.5806451612903226
5 dupa Holz 1823.80 0.6129032258064516
5 dupa Rodriguez 1836.00 0.6451612903225806
5 Black Kumar 1908.00 0.6774193548387096
5 dupa Messner 2085.00 0.7096774193548387
5 dupa kraków 2156.50 0.7419354838709677
5 dupa Pontes 2162.80 0.7741935483870968
5 dupa Larsson 2295.20 0.8064516129032258
5 Black Kumar 2715.90 0.8387096774193549
5 dupa Saveley 2812.00 0.8709677419354839
5 dupa Berglund 3192.65 0.9032258064516129
5 dupa Pipps 4180.00 0.9354838709677419
5 dupa Kloss 4181.50 0.967741935483871
5 dupa Kloss 10191.70 1
6 dupa Saavedra 155.00 0
6 dupa Yorres 317.75 0.034482758620689655
6 dupa Moos 330.00 0.06896551724137931
6 dupa Cruz 387.50 0.10344827586206896
6 muter Ashworth 477.00 0.13793103448275862
6 dupa Moroni 543.00 0.1724137931034483
6 dupa Citeaux 547.80 0.20689655172413793
6 dupa Nagy 569.00 0.2413793103448276
6 dupa Citeaux 625.00 0.27586206896551724
6 dupa Mendel 647.75 0.3103448275862069
6 dupa Fresnière 711.00 0.3448275862068966
6 dupa Nagy 764.30 0.3793103448275862
6 dupa Petersen 835.20 0.41379310344827586
6 dupa Angel Paolino 838.45 0.4482758620689655
6 dupa Limeira 965.00 0.4827586206896552
6 dupa Wilson 977.50 0.5172413793103449
6 dupa Pfalzheim 1067.10 0.5517241379310345
6 dupa Messner 1152.50 0.5862068965517241
6 dupa Franken 1257.30 0.6206896551724138
6 dupa Wilson 1299.00 0.6551724137931034
6 dupa Berglund 1565.65 0.6896551724137931
6 dupa Citeaux 2040.00 0.7241379310344828
6 dupa kraków 2082.00 0.7586206896551724
6 jhon Hardy 2142.90 0.7931034482758621
6 dupa Feuer 2147.40 0.8275862068965517
6 dupa Koskitalo 2413.90 0.8620689655172413
6 dupa Fresnière 2595.00 0.896551724137931
6 dupa Larsson 2844.50 0.9310344827586207
6 dupa McKenna 3109.00 0.9655172413793104
6 dupa Pavarotti 3680.50 1
7 dupa Moroni 28.00 0
7 dupa Ibsen 65.00 0.03125
7 dupa Snyder 72.00 0.0625
7 dupa Karttunen 120.00 0.09375
7 dupa Parente 142.50 0.125
7 dupa Rodriguez 256.50 0.15625
7 dupa Hernández 358.00 0.1875
7 dupa Roulet 399.00 0.21875
7 dupa Labrune 424.00 0.25
7 dupa Moos 464.00 0.28125
7 dupa Latimer 479.80 0.3125
7 muter Ashworth 493.00 0.34375
7 dupa Messner 543.65 0.375
7 dupa Phillips 565.50 0.40625
7 dupa Pipps 800.10 0.4375
7 dupa Batista 807.38 0.46875
7 dupa Piestrzeniewicz 808.00 0.5
7 dupa Ibsen 812.50 0.53125
7 dupa Josephs 1064.00 0.5625
7 dupa Fresnière 1140.00 0.59375
7 dupa Domingues 1413.00 0.625
7 dupa Jablonski 1476.10 0.65625
7 dupa Pavarotti 1508.00 0.6875
7 dupa Snyder 1650.00 0.71875
7 dupa Hernández 2285.00 0.75
7 dupa Wilson 2388.50 0.78125
7 dupa Messner 2493.00 0.8125
7 dupa Kloss 3900.00 0.84375
7 dupa Fresnière 4326.00 0.875
7 dupa Snyder 5032.00 0.90625
7 dupa Mendel 6300.00 0.9375
7 dupa Pavarotti 6375.00 0.96875
7 dupa Pavarotti 6475.40 1
8 dupa Tannamuri 57.50 0
8 dupa Roulet 62.00 0.03125
8 dupa Limeira 382.50 0.0625
8 dupa Citeaux 450.00 0.09375
8 dupa Trujillo 479.75 0.125
8 dupa Bergulfsen 500.00 0.15625
8 dupa Limeira 605.00 0.1875
8 dupa Müller 620.00 0.21875
8 dupa Koskitalo 629.50 0.25
8 dupa Batista 636.00 0.28125
8 Black Bennett 758.50 0.3125
8 dupa Petersen 870.00 0.34375
8 dupa Cramer 918.00 0.375
8 dupa Müller 945.00 0.40625
8 dupa Anders 1086.00 0.4375
8 dupa Fresnière 1260.00 0.46875
8 dupa Pavarotti 1264.50 0.5
8 dupa Rovelli 1380.25 0.53125
8 dupa Wong 1393.24 0.5625
8 dupa Parente 1422.00 0.59375
8 dupa Franken 1429.75 0.625
8 dupa Dewey 1434.00 0.65625
8 dupa Berglund 1503.60 0.6875
8 dupa Pontes 1535.00 0.71875
8 dupa Cruz 1820.20 0.75
8 dupa McKenna 1928.00 0.78125
8 dupa Hernández 2054.00 0.8125
8 dupa Fresnière 2697.50 0.84375
8 dupa Izquierdo 2720.05 0.875
8 dupa Pedro Freyre 2775.05 0.90625
8 dupa Carvalho 2896.25 0.9375
8 dupa Rancé 4985.50 0.96875
8 dupa Mendel 6483.05 1
9 Black Bennett 45.00 0
9 dupa Labrune 63.00 0.027777777777777776
9 dupa Wilson 125.00 0.05555555555555555
9 dupa Moroni 193.00 0.08333333333333333
9 dupa Fonseca 331.78 0.1111111111111111
9 dupa kraków 375.50 0.1388888888888889
9 dupa Karttunen 412.35 0.16666666666666666
9 dupa Müller 530.40 0.19444444444444445
9 dupa Angel Paolino 534.85 0.2222222222222222
9 dupa Petersen 570.00 0.25
9 dupa Citeaux 660.00 0.2777777777777778
9 dupa Berglund 668.70 0.3055555555555556
9 dupa Snyder 671.35 0.3333333333333333
9 dupa Müller 694.75 0.3611111111111111
9 dupa McKenna 703.25 0.3888888888888889
9 dupa Fonseca 801.10 0.4166666666666667
9 dupa Schmitt 920.10 0.4444444444444444
9 dupa kraków 956.90 0.4722222222222222
9 dupa Franken 1203.50 0.5
9 dupa Carvalho 1291.60 0.5277777777777778
9 dupa Wilson 1295.00 0.5555555555555556
9 dupa Snyder 1327.00 0.5833333333333334
9 dupa Franken 1423.00 0.6111111111111112
9 dupa Rodriguez 1515.75 0.6388888888888888
9 dupa Pipps 1638.45 0.6666666666666666
9 dupa Phillips 1682.50 0.6944444444444444
9 dupa Latimer 1701.00 0.7222222222222222
9 dupa Pfalzheim 1768.00 0.75
9 dupa Mendel 1921.00 0.7777777777777778
9 dupa Lebihan 2032.00 0.8055555555555556
9 dupa Franken 2301.75 0.8333333333333334
9 dupa Berglund 4210.50 0.8611111111111112
9 dupa Pavarotti 4371.60 0.8888888888888888
9 dupa Holz 4666.94 0.9166666666666666
9 dupa Kloss 4668.00 0.9444444444444444
9 dupa Pavarotti 5256.50 0.9722222222222222
9 dupa McKenna 6201.90 1
10 dupa Accorti 93.50 0
10 dupa Feuer 114.00 0.02702702702702703
10 dupa Nixon 180.40 0.05405405405405406
10 dupa Cruz 287.80 0.08108108108108109
10 dupa Anders 330.00 0.10810810810810811
10 dupa Hernández 378.00 0.13513513513513514
10 dupa Jablonski 468.45 0.16216216216216217
10 dupa Batista 550.00 0.1891891891891892
10 dupa Carvalho 595.50 0.21621621621621623
10 dupa Berglund 630.00 0.24324324324324326
10 dupa Fresnière 638.50 0.2702702702702703
10 dupa Karttunen 642.00 0.2972972972972973
10 dupa Gutiérrez 706.00 0.32432432432432434
10 dupa Anders 878.00 0.35135135135135137
10 dupa Kloss 972.50 0.3783783783783784
10 dupa Jablonski 996.00 0.40540540540540543
10 dupa Izquierdo 1073.90 0.43243243243243246
10 dupa Yorres 1125.67 0.4594594594594595
10 dupa Pontes 1150.00 0.4864864864864865
10 dupa McKenna 1238.40 0.5135135135135135
10 dupa Lebihan 1296.00 0.5405405405405406
10 dupa Franken 1331.75 0.5675675675675675
10 dupa Pavarotti 1570.00 0.5945945945945946
10 jhon Hardy 1704.00 0.6216216216216216
10 dupa Phillips 1893.00 0.6486486486486487
10 dupa Pavarotti 2048.00 0.6756756756756757
10 dupa Jablonski 2334.00 0.7027027027027027
10 dupa Larsson 2545.00 0.7297297297297297
10 dupa Pavarotti 2827.90 0.7567567567567568
10 dupa Pavarotti 2941.00 0.7837837837837838
10 dupa McKenna 3370.00 0.8108108108108109
10 dupa Fonseca 3424.00 0.8378378378378378
10 dupa Cramer 3463.00 0.8648648648648649
10 dupa Ibsen 3490.00 0.8918918918918919
10 dupa Mendel 3600.73 0.918918918918919
10 dupa Pavarotti 4451.70 0.9459459459459459
10 dupa Kloss 4825.00 0.972972972972973
10 dupa Kloss 10164.80 1
11 dupa Perrier 52.35 0
11 dupa Rovelli 55.20 0.030303030303030304
11 dupa Accorti 88.00 0.06060606060606061
11 dupa Henriot 139.80 0.09090909090909091
11 dupa Henriot 240.00 0.12121212121212122
11 Black Crowther 252.00 0.15151515151515152
11 jhon Hardy 285.00 0.18181818181818182
11 dupa Trujillo 320.00 0.21212121212121213
11 jhon Hardy 336.00 0.24242424242424243
11 dupa Lebihan 360.00 0.2727272727272727
11 dupa Lebihan 509.75 0.30303030303030304
11 dupa Yorres 596.00 0.3333333333333333
11 Black Devon 655.00 0.36363636363636365
11 dupa Ibsen 920.00 0.3939393939393939
11 dupa McKenna 997.00 0.42424242424242425
11 Black Bennett 1080.00 0.45454545454545453
11 dupa Carvalho 1296.75 0.48484848484848486
11 dupa Berglund 1459.00 0.5151515151515151
11 dupa Fonseca 1498.35 0.5454545454545454
11 dupa Holz 1644.60 0.5757575757575758
11 dupa Holz 1701.46 0.6060606060606061
11 dupa Moroni 1710.00 0.6363636363636364
11 dupa Jablonski 1770.00 0.6666666666666666
11 dupa Izquierdo 1850.00 0.696969696969697
11 dupa Koskitalo 1871.25 0.7272727272727273
11 dupa Pipps 1912.85 0.7575757575757576
11 dupa Wang 1990.00 0.7878787878787878
11 dupa Pavarotti 2196.00 0.8181818181818182
11 dupa Wang 2311.70 0.8484848484848485
11 dupa Braunschweiger 2487.50 0.8787878787878788
11 dupa Lebihan 2598.00 0.9090909090909091
11 dupa Pavarotti 3082.00 0.9393939393939394
11 dupa Lincoln 3118.00 0.9696969696969697
11 dupa Kloss 4529.80 1
12 dupa Simpson 12.50 0
12 dupa Accorti 18.40 0.02127659574468085
12 dupa Cartrain 28.00 0.0425531914893617
12 dupa Berglund 96.50 0.06382978723404255
12 jhon Hardy 191.10 0.0851063829787234
12 dupa Wong 228.00 0.10638297872340426
12 dupa Fonseca 280.00 0.1276595744680851
12 dupa Pontes 315.00 0.14893617021276595
12 dupa Mendel 344.00 0.1702127659574468
12 dupa Pereira 387.50 0.19148936170212766
12 dupa Batista 393.45 0.2127659574468085
12 dupa Piestrzeniewicz 399.85 0.23404255319148937
12 dupa Ottlieb 420.00 0.2553191489361702
12 Black Bennett 446.60 0.2765957446808511
12 dupa Saveley 572.10 0.2978723404255319
12 dupa Rancé 616.00 0.3191489361702128
12 dupa Wilson 629.50 0.3404255319148936
12 dupa González 720.00 0.3617021276595745
12 dupa Kloss 770.00 0.3829787234042553
12 dupa Fonseca 850.00 0.40425531914893614
12 dupa Larsson 875.00 0.425531914893617
12 dupa Koskitalo 1132.35 0.44680851063829785
12 dupa Parente 1255.80 0.46808510638297873
12 dupa Feuer 1335.00 0.48936170212765956
12 dupa Pontes 1442.50 0.5106382978723404
12 jhon Hardy 1477.00 0.5319148936170213
12 dupa Cramer 1585.00 0.5531914893617021
12 Black Kumar 1632.15 0.574468085106383
12 dupa Rovelli 1650.00 0.5957446808510638
12 dupa Kloss 1684.00 0.6170212765957447
12 dupa Ibsen 1704.00 0.6382978723404256
12 dupa Carvalho 1913.85 0.6595744680851063
12 dupa Franken 1926.06 0.6808510638297872
12 dupa Mendel 2216.25 0.7021276595744681
12 Black Kumar 2290.40 0.723404255319149
12 dupa Pfalzheim 2310.00 0.7446808510638298
12 dupa Mendel 2499.25 0.7659574468085106
12 dupa Mendel 2540.00 0.7872340425531915
12 dupa Roulet 2760.80 0.8085106382978723
12 dupa Nixon 2775.00 0.8297872340425532
12 dupa Hernández 2878.08 0.851063829787234
12 dupa Dewey 3304.00 0.8723404255319149
12 dupa Messner 3603.22 0.8936170212765957
12 dupa Rancé 3687.00 0.9148936170212766
12 dupa Petersen 3923.75 0.9361702127659575
12 dupa Sommer 4035.80 0.9574468085106383
12 dupa Larsson 4337.00 0.9787234042553191
12 dupa Mendel 6984.50 1
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas.      Vsn 1.3.0