[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 62 > TITLE Top 1000 Australian Internet customers for 2020
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Luo, Ashlee,23534 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Pais, Wilson, C,13038 | 5581.26 | 0.00 | 0.00 | 2071.42 | 3509.84 |
| Raji, Katrina, M,16517 | 4698.76 | 3578.27 | 0.00 | 1120.49 | 0.00 |
| Jai, Warren, S,16483 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Raji, Misty,16520 | 4727.74 | 3578.27 | 0.00 | 0.00 | 1149.47 |
| Zheng, Rosa, G,16629 | 5933.26 | 3578.27 | 0.00 | 0.00 | 2354.99 |
| Vazquez, Daisy, L,25560 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Torres, Ruben,11002 | 8114.04 | 3399.99 | 0.00 | 4714.05 | 0.00 |
| Arun, Cory, O,16527 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Malhotra, Mayra, E,15577 | 143.45 | 0.00 | 0.00 | 0.00 | 143.45 |
| Li, Crystal, L,14325 | 5152.70 | 0.00 | 0.00 | 2049.10 | 3103.60 |
| Fernandez, Manuel, A,16514 | 4761.74 | 3578.27 | 0.00 | 1183.47 | 0.00 |
| Wang, Curtis, A,13108 | 5718.66 | 0.00 | 0.00 | 2071.42 | 3647.24 |
| Gao, Tiffany, E,16352 | 5948.49 | 3578.27 | 0.00 | 0.00 | 2370.22 |
| Liang, Martha,16525 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Gray, Faith,22914 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Alonso, Brandi,17061 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Madan, Toni,26668 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Lin, Kelvin, A,13075 | 6843.94 | 0.00 | 0.00 | 2071.42 | 4772.52 |
| Hu, Glenn, R,24897 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Ramos, Briana, J,14303 | 3636.91 | 0.00 | 0.00 | 2049.10 | 1587.81 |
| Navarro, Monique, R,15240 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Madan, Henry, E,17283 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Wang, Trisha, V,17259 | 4404.73 | 3578.27 | 0.00 | 0.00 | 826.46 |
| Ramos, Eddie, T,13954 | 128.46 | 0.00 | 0.00 | 0.00 | 128.46 |
| Beck, Donna, J,18247 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Mehta, Erick, E,14123 | 61.58 | 0.00 | 0.00 | 28.98 | 32.60 |
| Ramos, Joe,12353 | 6765.46 | 0.00 | 2071.42 | 0.00 | 4694.04 |
| Roberts, Jordan,23432 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Tang, Dawn, R,16496 | 5960.23 | 3578.27 | 0.00 | 0.00 | 2381.96 |
| Zhu, Dawn,26661 | 1912.47 | 0.00 | 0.00 | 782.99 | 1129.48 |
| Alvarez, Janet, G,11006 | 8119.03 | 3399.99 | 0.00 | 2334.97 | 2384.07 |
| Verhoff, Rob,11008 | 8106.31 | 3374.99 | 0.00 | 4731.32 | 0.00 |
| Serrano, Max, E,12010 | 8203.50 | 0.00 | 3374.99 | 0.00 | 4828.51 |
| Carlson, Shannon, C,11009 | 8091.33 | 3374.99 | 0.00 | 2297.28 | 2419.06 |
| Chapman, Kathryn,11988 | 8078.02 | 0.00 | 3374.99 | 0.00 | 4703.03 |
| Xu, Colin, C,29461 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Stewart, Ariana,16743 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Raman, Shane,16661 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| Alexander, Olivia, L,14667 | 5295.41 | 0.00 | 0.00 | 2049.10 | 3246.31 |
| Diaz, Ruben, A,25136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martin, Naomi, A,15593 | 116.26 | 0.00 | 0.00 | 88.98 | 27.28 |
| Henderson, Xavier, K,12993 | 96.25 | 0.00 | 0.00 | 0.00 | 96.25 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 8.99 | 64.97 |
| Suri, Roy, M,17253 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Allen, Hailey, C,26759 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Liu, Autumn, J,20985 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Gonzalez, Ebony,11034 | 6491.32 | 3399.99 | 0.00 | 0.00 | 3091.33 |
| Rubio, Kendra,17047 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Shen, Nichole,12999 | 6840.46 | 0.00 | 0.00 | 2071.42 | 4769.04 |
| Jones, Emily,16659 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Diaz, Samuel,14065 | 5608.55 | 0.00 | 0.00 | 2071.42 | 3537.13 |
| Zhu, Gilbert,11921 | 63.24 | 0.00 | 0.00 | 0.00 | 63.24 |
| Zeng, Claudia, M,16696 | 4506.76 | 3578.27 | 0.00 | 928.49 | 0.00 |
| Ruiz, Bruce, W,16171 | 103.86 | 0.00 | 0.00 | 0.00 | 103.86 |
| Yuan, Bethany, G,11030 | 6471.32 | 3399.99 | 0.00 | 0.00 | 3071.33 |
| Lal, Karla,25219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martin, Marc, J,11039 | 6636.58 | 3399.99 | 0.00 | 0.00 | 3236.59 |
Generated 2025-11-01 02:49:23.063 UTC