Spreadsheet: 220659d1363217851-summing-and-ranking-rank-example
Sheet: Sheet1

Date | Client Name | REGION | USD
2012-08-01 00:00:00 | ABC | EUROPE | 77.91
2012-08-01 00:00:00 | ABC | EUROPE | 11.62
2012-08-01 00:00:00 | ABC | EUROPE | 63.77
2012-08-01 00:00:00 | DEF | EUROPE | 21.33
2012-08-01 00:00:00 | DEF | EUROPE | 73.35
2012-08-01 00:00:00 | DEF | EUROPE | 43.66
2012-08-01 00:00:00 | DEF | EUROPE | 1.93
2012-08-01 00:00:00 | GHI | ASIA | 50.18
2012-08-01 00:00:00 | GHI | ASIA | 71.56
2012-08-01 00:00:00 | GHI | ASIA | 4.89
2012-08-01 00:00:00 | JKL | ASIA | 17.82
2012-08-01 00:00:00 | JKL | ASIA | 96.34
2012-08-01 00:00:00 | JKL | ASIA | 12.51
2012-08-01 00:00:00 | MNO | ASIA | 15.11
2012-08-01 00:00:00 | MNO | ASIA | 31.72
2012-08-01 00:00:00 | MNO | ASIA | 35.37
2012-08-01 00:00:00 | MNO | ASIA | 91.07
2012-08-01 00:00:00 | PQR | EUROPE | 52.26
2012-08-01 00:00:00 | PQR | EUROPE | 11.28
2012-08-01 00:00:00 | PQR | EUROPE | 83.51
2012-08-01 00:00:00 | PQR | EUROPE | 48.45
2012-08-01 00:00:00 | STU | EUROPE | 70.99
2012-08-01 00:00:00 | STU | EUROPE | 72.22
2012-08-01 00:00:00 | STU | EUROPE | 40.84
2012-08-01 00:00:00 | VWXZY | ASIA | 17.81
2012-08-01 00:00:00 | VWXZY | ASIA | 63.14
2012-08-01 00:00:00 | VWXZY | ASIA | 82.31
2012-08-01 00:00:00 | VWXZY | ASIA | 85.85
2012-08-01 00:00:00 | VWXZY | ASIA | 3.55
2012-09-01 00:00:00 | ABC | EUROPE | 14.78
2012-09-01 00:00:00 | ABC | EUROPE | 84.05
2012-09-01 00:00:00 | ABC | EUROPE | 42.56
2012-09-01 00:00:00 | DEF | EUROPE | 6.4
2012-09-01 00:00:00 | DEF | EUROPE | 11.56
2012-09-01 00:00:00 | DEF | EUROPE | 8.68
2012-09-01 00:00:00 | DEF | EUROPE | 22.83
2012-09-01 00:00:00 | GHI | ASIA | 48.34
2012-09-01 00:00:00 | GHI | ASIA | 16.52
2012-09-01 00:00:00 | GHI | ASIA | 94.8
2012-09-01 00:00:00 | JKL | ASIA | 92.94
2012-09-01 00:00:00 | JKL | ASIA | 35.59
2012-09-01 00:00:00 | JKL | ASIA | 88.2
2012-09-01 00:00:00 | MNO | ASIA | 86.07
2012-09-01 00:00:00 | MNO | ASIA | 44.71
2012-09-01 00:00:00 | MNO | ASIA | 5.59
2012-09-01 00:00:00 | MNO | ASIA | 91.54
2012-09-01 00:00:00 | PQR | EUROPE | 95.62
2012-09-01 00:00:00 | PQR | EUROPE | 55.34
2012-09-01 00:00:00 | PQR | EUROPE | 42.12
2012-09-01 00:00:00 | PQR | EUROPE | 76.02
2012-09-01 00:00:00 | STU | EUROPE | 52.21
2012-09-01 00:00:00 | STU | EUROPE | 13.42
2012-09-01 00:00:00 | STU | EUROPE | 42.6
2012-09-01 00:00:00 | VWXZY | ASIA | 30.14
2012-09-01 00:00:00 | VWXZY | ASIA | 14.09
2012-09-01 00:00:00 | VWXZY | ASIA | 0.36
2012-09-01 00:00:00 | VWXZY | ASIA | 57.62
2012-09-01 00:00:00 | VWXZY | ASIA | 24.46
2012-10-01 00:00:00 | ABC | EUROPE | 56.89
2012-10-01 00:00:00 | ABC | EUROPE | 56.69
2012-10-01 00:00:00 | ABC | EUROPE | 24.71
2012-10-01 00:00:00 | DEF | EUROPE | 89.9
2012-10-01 00:00:00 | DEF | EUROPE | 94.36
2012-10-01 00:00:00 | DEF | EUROPE | 35.66
2012-10-01 00:00:00 | DEF | EUROPE | 95.85
2012-10-01 00:00:00 | GHI | ASIA | 11.75
2012-10-01 00:00:00 | GHI | ASIA | 22.68
2012-10-01 00:00:00 | GHI | ASIA | 39.42
2012-10-01 00:00:00 | JKL | ASIA | 99.22
2012-10-01 00:00:00 | JKL | ASIA | 86.15
2012-10-01 00:00:00 | JKL | ASIA | 44.06
2012-10-01 00:00:00 | MNO | ASIA | 39.58
2012-10-01 00:00:00 | MNO | ASIA | 47.41
2012-10-01 00:00:00 | MNO | ASIA | 64.89
2012-10-01 00:00:00 | MNO | ASIA | 2.22
2012-10-01 00:00:00 | PQR | EUROPE | 10.02
2012-10-01 00:00:00 | PQR | EUROPE | 3.37
2012-10-01 00:00:00 | PQR | EUROPE | 9
2012-10-01 00:00:00 | PQR | EUROPE | 84.39
2012-10-01 00:00:00 | STU | EUROPE | 17.03
2012-10-01 00:00:00 | STU | EUROPE | 79.39
2012-10-01 00:00:00 | STU | EUROPE | 43.52
2012-10-01 00:00:00 | VWXZY | ASIA | 80.92
2012-10-01 00:00:00 | VWXZY | ASIA | 72.37
2012-10-01 00:00:00 | VWXZY | ASIA | 96.51
2012-10-01 00:00:00 | VWXZY | ASIA | 79.71
2012-10-01 00:00:00 | VWXZY | ASIA | 44.43