Spreadsheet: 220670d1363223065-summing-and-ranking-rank-region-date
Sheet: Sheet1

Date | Client Name | REGION | USD |  | unique list | total | rank | from | to | ASIA |  |  | EUROPE | validation list
2012-08-01 00:00:00 | ABC | EUROPE | 77.91 |  | GHI | 286.29 | 4 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | choose from j1 |  |  | ASIA
2012-08-01 00:00:00 | ABC | EUROPE | 11.62 |  | JKL | 343.4 | 3
2012-08-01 00:00:00 | ABC | EUROPE | 63.77 |  | MNO | 401.1799999999999 | 1
2012-08-01 00:00:00 | DEF | EUROPE | 21.33 |  | VWXZY | 379.33 | 2
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 | 8
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 | 11
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 | 14
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 | 25
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