[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 31 > TITLE Top 1000 Australian Internet customers for 2020
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Deng, Deborah,23324 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Blanco, Jésus, E,20448 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Fernandez, Manuel, A,16514 | 4761.74 | 3578.27 | 0.00 | 1183.47 | 0.00 |
| Cai, Alvin, D,11115 | 35.23 | 0.00 | 0.00 | 27.28 | 7.95 |
| Ramos, Jaime,15720 | 70.22 | 0.00 | 0.00 | 35.23 | 34.99 |
| Zeng, Wesley,20460 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| She, Katie, B,11965 | 118.74 | 0.00 | 0.00 | 94.25 | 24.49 |
| Perez, Preston,12370 | 61.53 | 0.00 | 0.00 | 2.29 | 59.24 |
| Lin, Edwin,19766 | 4167.23 | 0.00 | 3578.27 | 588.96 | 0.00 |
| Navarro, Kristy, J,19570 | 74.94 | 0.00 | 0.00 | 45.95 | 28.99 |
| Evans, Adam, H,25820 | 48.97 | 0.00 | 0.00 | 48.97 | 0.00 |
| Guo, Krystal, S,17381 | 188.93 | 0.00 | 0.00 | 188.93 | 0.00 |
| Ye, Steve,29087 | 810.32 | 0.00 | 0.00 | 0.00 | 810.32 |
| Patel, Virginia, R,11366 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Jai, Bonnie,11977 | 8212.50 | 0.00 | 3399.99 | 0.00 | 4812.51 |
| Blanco, Ricky, F,16606 | 67.17 | 0.00 | 0.00 | 0.00 | 67.17 |
| Moore, Devin, J,16167 | 102.57 | 0.00 | 0.00 | 0.00 | 102.57 |
| Diaz, Jay,16692 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Liu, Lacey, L,23545 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| He, Louis, E,21211 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Lu, Rosa, A,16663 | 4471.74 | 3578.27 | 0.00 | 893.47 | 0.00 |
| Kapoor, Candace,18282 | 30.97 | 0.00 | 0.00 | 21.98 | 8.99 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 8.99 | 64.97 |
| Romero, Jacquelyn,25815 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Moore, Nathan, N,28323 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Chen, Claudia, R,16627 | 64.88 | 0.00 | 0.00 | 29.99 | 34.89 |
| Guo, Susan, A,26543 | 14.23 | 0.00 | 0.00 | 14.23 | 0.00 |
| Foster, Luke,15137 | 161.94 | 0.00 | 0.00 | 97.97 | 63.97 |
| Serrano, Tabitha,28327 | 2407.04 | 0.00 | 0.00 | 2407.04 | 0.00 |
| Muñoz, Alberto, J,13008 | 125.51 | 0.00 | 0.00 | 0.00 | 125.51 |
| Nath, Keith,19617 | 61.75 | 0.00 | 0.00 | 0.00 | 61.75 |
Generated 2024-11-12 22:40:32.304 UTC