[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 62 > TITLE Top 1000 Australian Internet customers for 2020
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Wu, Micah,17246 | 4380.04 | 3578.27 | 0.00 | 0.00 | 801.77 |
| Carson, Bradley,23995 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Gutierrez, Meredith, T,11111 | 8137.00 | 0.00 | 3399.99 | 2318.96 | 2418.05 |
| Suarez, Neil,15242 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Watson, Alexandra, H,25249 | 1868.56 | 699.10 | 0.00 | 0.00 | 1169.46 |
| Tang, Rafael, A,11908 | 8079.05 | 0.00 | 3374.99 | 2319.99 | 2384.07 |
| Rana, Meagan, M,11914 | 8165.96 | 0.00 | 3374.99 | 0.00 | 4790.97 |
| Suri, Mayra, M,15729 | 4393.70 | 0.00 | 0.00 | 2071.42 | 2322.28 |
| Serrano, Randall,27973 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gutierrez, Pedro, S,15224 | 71.92 | 0.00 | 0.00 | 0.00 | 71.92 |
| Ramos, Jaime,15720 | 70.22 | 0.00 | 0.00 | 35.23 | 34.99 |
| Subram, Kari,12682 | 227.96 | 0.00 | 0.00 | 0.00 | 227.96 |
| Hill, Kaylee, L,11918 | 8204.99 | 0.00 | 3399.99 | 0.00 | 4805.00 |
| Sai, Ross, A,21966 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Hernandez, Armando,21950 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Sai, Clifford,25128 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Sanchez, Olivia, J,14278 | 177.46 | 0.00 | 0.00 | 0.00 | 177.46 |
| Rana, Molly,21554 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Zheng, Curtis, S,23645 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Lopez, George,15040 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Perez, Toni,15581 | 113.94 | 0.00 | 0.00 | 0.00 | 113.94 |
| Raman, Deanna, H,17053 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Ruiz, Adrienne,13523 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
| Hu, Barbara,19567 | 104.96 | 0.00 | 0.00 | 0.00 | 104.96 |
| Kumar, Tommy,17297 | 100.25 | 0.00 | 0.00 | 37.27 | 62.98 |
| Pal, Arturo, P,29303 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Sanz, Marvin,19612 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Serrano, Anne,24244 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Goel, Karl,18705 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Sai, Rachael,11912 | 8095.32 | 0.00 | 3374.99 | 0.00 | 4720.33 |
| Jordan, Ross, F,11124 | 8129.02 | 0.00 | 3399.99 | 2309.97 | 2419.06 |
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 2294.99 | 2438.06 |
| Lin, Wesley,21407 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Hernandez, Monique, J,15138 | 123.45 | 0.00 | 0.00 | 34.99 | 88.46 |
| Gomez, Gary,15640 | 34.57 | 0.00 | 0.00 | 2.29 | 32.28 |
| Rowe, Jacquelyn, I,13615 | 146.91 | 0.00 | 0.00 | 7.95 | 138.96 |
| Wu, Mandy,18309 | 6090.59 | 0.00 | 3578.27 | 2512.32 | 0.00 |
| Zhou, Steve, C,20263 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Prasad, Henry, M,24364 | 3965.52 | 0.00 | 0.00 | 2181.56 | 1783.96 |
| Serrano, Danny,24381 | 3970.52 | 0.00 | 0.00 | 2181.56 | 1788.96 |
| Nara, Karl,15142 | 138.46 | 0.00 | 0.00 | 0.00 | 138.46 |
| Zhao, Susan, L,25122 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nara, Lindsay, M,25247 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Deng, Latoya, H,21969 | 4759.47 | 0.00 | 0.00 | 2181.56 | 2577.91 |
| Cox, Catherine, K,13122 | 6871.43 | 0.00 | 0.00 | 2071.42 | 4800.01 |
| Raman, Cassandra,28718 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Suarez, Leslie, C,22955 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Xu, Cristina,25017 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Shan, Deborah,20624 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Johnston, Joanna, L,17296 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Raman, Johnathan,19103 | 63.91 | 0.00 | 0.00 | 41.93 | 21.98 |
| Ma, Jorge, O,14052 | 86.26 | 0.00 | 0.00 | 27.28 | 58.98 |
| Torres, Neil,17305 | 196.97 | 0.00 | 0.00 | 196.97 | 0.00 |
| Navarro, Dana, J,11125 | 79.69 | 0.00 | 0.00 | 47.42 | 32.27 |
| Arun, Bryant, C,20453 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Bhat, Edwin,13079 | 6752.13 | 0.00 | 0.00 | 2049.10 | 4703.03 |
| Andersen, Warren,11919 | 8171.52 | 0.00 | 3374.99 | 0.00 | 4796.53 |
| Gao, Jorge,23573 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Hayes, Eric, A,22964 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Munoz, Marvin,14680 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Tang, April, A,25935 | 1256.03 | 0.00 | 699.10 | 0.00 | 556.93 |
| Lal, Alicia,15734 | 4426.41 | 0.00 | 0.00 | 2071.42 | 2354.99 |
Generated 2024-11-12 22:34:03.091 UTC