[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 31 > TITLE Top 1000 Australian Internet customers for 2020
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Shen, Tamara, G,22935 | 3951.52 | 0.00 | 0.00 | 2181.56 | 1769.96 |
| Madan, Patricia, L,22988 | 4194.33 | 0.00 | 0.00 | 2443.35 | 1750.98 |
| Morgan, Sara,13134 | 5648.92 | 0.00 | 0.00 | 2049.10 | 3599.82 |
| Ramos, Joy,13129 | 6823.15 | 0.00 | 0.00 | 2049.10 | 4774.05 |
| Lal, Bradley,13156 | 2663.69 | 0.00 | 0.00 | 2071.42 | 592.27 |
| Prasad, Carmen, L,18928 | 6095.08 | 0.00 | 3578.27 | 0.00 | 2516.81 |
| Yang, Kevin, F,20605 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Sanz, Kellie,16708 | 4406.74 | 3578.27 | 0.00 | 0.00 | 828.47 |
| Suri, Douglas,19096 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Vance, Monica, G,12338 | 8265.00 | 0.00 | 3374.99 | 0.00 | 4890.01 |
| Suarez, Dana, M,23541 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Blanco, Kari,19627 | 41.75 | 0.00 | 0.00 | 27.77 | 13.98 |
| Serrano, Lori,17066 | 105.75 | 0.00 | 0.00 | 0.00 | 105.75 |
| Zhu, Omar,25033 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Chen, Clarence, R,15147 | 97.45 | 0.00 | 0.00 | 0.00 | 97.45 |
| Goel, Michele,15041 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Gill, Gary, B,25108 | 2199.41 | 0.00 | 0.00 | 1000.44 | 1198.97 |
| Gonzalez, Savannah, F,15644 | 3803.68 | 0.00 | 0.00 | 2071.42 | 1732.26 |
| Price, Trevor, M,15725 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Zimmerman, Krystal,17228 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Chander, Clarence, E,13982 | 59.98 | 0.00 | 0.00 | 34.99 | 24.99 |
| Raji, Maurice, C,20619 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Malhotra, Terrance, E,20223 | 187.38 | 0.00 | 0.00 | 0.00 | 187.38 |
| Srini, Joe,22180 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Perez, Ronald,25944 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Zhu, Jessie, D,12666 | 34.56 | 0.00 | 0.00 | 0.00 | 34.56 |
| Yuan, Keith, N,22926 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Cox, Nicole, V,22950 | 3917.54 | 0.00 | 0.00 | 3917.54 | 0.00 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 0.00 | 782.99 | 578.46 |
| Long, Isabelle, W,23104 | 3490.03 | 0.00 | 0.00 | 3490.03 | 0.00 |
| Suarez, Kristi, D,23099 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
Generated 2024-11-14 04:00:05.344 UTC