[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1063 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| He, Jon, L,14262 | 5652.54 | 0.00 | 0.00 | 2071.42 | 3581.12 |
| Shen, Tony,29099 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Moyer, Mario,23420 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Kumar, Kenneth,11472 | 8165.82 | 0.00 | 3399.99 | 0.00 | 4765.83 |
| Suri, Patricia, E,15436 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Tang, Julie,26589 | 1966.46 | 0.00 | 0.00 | 782.99 | 1183.47 |
| Blue, Richard,12006 | 144.74 | 0.00 | 0.00 | 0.00 | 144.74 |
| Chander, Keith, A,24174 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Xu, Cara,23526 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Nara, Grant,12995 | 6850.58 | 0.00 | 0.00 | 2049.10 | 4801.48 |
| Suarez, Melinda,29181 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Zhu, Omar,25033 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Serrano, Lori,17066 | 105.75 | 0.00 | 0.00 | 0.00 | 105.75 |
| Vazquez, Neil, K,28719 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Alvarez, Lori, C,26662 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Cai, Suzanne,25051 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Chander, Alison,18249 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Martin, Anne, V,25034 | 2164.91 | 0.00 | 0.00 | 1000.44 | 1164.47 |
| Garcia, Monica, D,20267 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Suarez, Daisy, A,18288 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Anand, Johnny,14058 | 5652.52 | 0.00 | 0.00 | 2071.42 | 3581.10 |
| Gill, Sheila, B,17375 | 24.49 | 0.00 | 0.00 | 0.00 | 24.49 |
| Pal, Casey,16522 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Zheng, Edwin, J,14216 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Barnes, Taylor,14279 | 5137.71 | 0.00 | 0.00 | 2049.10 | 3088.61 |
| Ward, Haley, J,16631 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Hernandez, Raquel, W,13997 | 4586.35 | 0.00 | 0.00 | 2071.42 | 2514.93 |
| Chandra, Jermaine, A,14299 | 5108.76 | 0.00 | 0.00 | 2071.42 | 3037.34 |
| Wang, Shannon,11017 | 6434.31 | 3374.99 | 0.00 | 2316.97 | 742.35 |
| Adams, Amber,26746 | 2001.45 | 0.00 | 0.00 | 782.99 | 1218.46 |
| Shen, Cristina,26768 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Fernandez, Brenda, L,16493 | 4197.25 | 3578.27 | 0.00 | 0.00 | 618.98 |
| Navarro, Javier,14131 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Shan, Darrell, J,27345 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ashe, Ebony, E,16612 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Zheng, Curtis, S,23645 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Black, Shawna, C,15205 | 4433.69 | 0.00 | 0.00 | 2071.42 | 2362.27 |
| Holt, Krystal,16518 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Garcia, Rebekah, M,14007 | 3772.41 | 0.00 | 0.00 | 3772.41 | 0.00 |
| Liu, Warren,15014 | 3860.87 | 0.00 | 0.00 | 2071.42 | 1789.45 |
| She, Melvin,16516 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Cook, Isaac, M,13994 | 4528.75 | 0.00 | 0.00 | 2071.42 | 2457.33 |
| Flores, Katherine,21180 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Ramos, Francis,16345 | 4173.24 | 3578.27 | 0.00 | 0.00 | 594.97 |
| Harris, Ian, W,14128 | 3836.38 | 0.00 | 0.00 | 2071.42 | 1764.96 |
| Shen, Grant, B,26763 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Sai, Harold,11026 | 6575.79 | 3399.99 | 0.00 | 0.00 | 3175.80 |
| Chande, Derek,26743 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Goel, Alisha, C,26767 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Simmons, Jordyn,16494 | 5961.20 | 3578.27 | 0.00 | 0.00 | 2382.93 |
| Muñoz, Pedro, A,23433 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Xie, Derek,14287 | 5141.43 | 0.00 | 0.00 | 2049.10 | 3092.33 |
| Tang, Dawn, R,16496 | 5960.23 | 3578.27 | 0.00 | 0.00 | 2381.96 |
| Ross, Brandon,14132 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Xu, Edwin, J,25272 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Chander, Yolanda,16519 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Hernandez, Ebony, S,23574 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Romero, Jessie,25030 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Jimenez, Melody, S,14066 | 3612.19 | 0.00 | 0.00 | 2853.57 | 758.62 |
| Chander, Karla,23648 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Beck, Ashlee, L,26666 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Lopez, Donald, A,26740 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
Generated 2025-12-22 02:09:52.342 UTC