[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 125 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| She, Gregory,18458 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Gonzales, Hunter,26570 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| He, Ramon,26919 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Blanco, Kristi,15464 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Raje, Ashlee, E,16658 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Ye, Dennis, M,16638 | 5974.23 | 3578.27 | 0.00 | 0.00 | 2395.96 |
| Wang, Curtis, A,13108 | 5718.66 | 0.00 | 0.00 | 2071.42 | 3647.24 |
| Cooper, Cody, A,16028 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Jai, Rafael, L,17323 | 84.96 | 0.00 | 0.00 | 8.99 | 75.97 |
| Raje, Marshall, J,19267 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Patterson, Jordan,17238 | 147.48 | 0.00 | 0.00 | 53.99 | 93.49 |
| Jai, Derek, E,13613 | 105.22 | 0.00 | 0.00 | 27.28 | 77.94 |
| Weber, Levi, A,13120 | 205.39 | 0.00 | 0.00 | 49.48 | 155.91 |
| Weber, Jarrod, M,14859 | 31.27 | 0.00 | 0.00 | 31.27 | 0.00 |
| Kapoor, Candace,18282 | 30.97 | 0.00 | 0.00 | 21.98 | 8.99 |
| Shen, Roger, G,14011 | 3831.89 | 0.00 | 0.00 | 3831.89 | 0.00 |
| Zhou, Arturo, F,27910 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Luo, Raul, Q,20154 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Moore, Nathan, N,28323 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| 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 |
| Alexander, Austin,26673 | 1505.76 | 0.00 | 0.00 | 1505.76 | 0.00 |
| Li, Trisha, A,18296 | 6117.69 | 0.00 | 3578.27 | 2539.42 | 0.00 |
| Jai, Jaime, M,24894 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Nara, Katrina, Z,24608 | 2120.93 | 0.00 | 1000.44 | 1120.49 | 0.00 |
| Lin, Claudia, A,14312 | 191.27 | 0.00 | 0.00 | 166.28 | 24.99 |
| Lewis, Hannah,26561 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Dominguez, Raquel, A,27470 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Sun, Dennis, K,24481 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Ye, Krystal, M,26923 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Foster, Madison,14038 | 6819.12 | 0.00 | 0.00 | 2049.10 | 4770.02 |
| Lopez, Ross,18443 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Sai, Francisco, W,18766 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Lewis, Jasmine,13964 | 6806.45 | 0.00 | 0.00 | 2071.42 | 4735.03 |
| Morgan, Melissa, M,20222 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Carson, Mitchell,13623 | 99.20 | 0.00 | 0.00 | 0.00 | 99.20 |
| Luo, Devon, D,22850 | 4657.51 | 0.00 | 0.00 | 2181.56 | 2475.95 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Xu, Alejandro, R,26585 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Chen, Jon,26920 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Garcia, Levi, G,21232 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Vance, Ruth, D,17302 | 147.44 | 0.00 | 0.00 | 58.98 | 88.46 |
| Zheng, Shannon, M,14678 | 49.99 | 0.00 | 0.00 | 49.99 | 0.00 |
| Zimmerman, Jenny,18197 | 30.97 | 0.00 | 0.00 | 8.99 | 21.98 |
| Arthur, Tabitha, E,16482 | 4783.74 | 3578.27 | 0.00 | 1205.47 | 0.00 |
| Chande, Derek,26743 | 1371.95 | 0.00 | 0.00 | 1371.95 | 0.00 |
| She, Stacey,26748 | 1357.97 | 0.00 | 0.00 | 1357.97 | 0.00 |
| Wang, Jaclyn, M,17063 | 100.25 | 0.00 | 0.00 | 37.27 | 62.98 |
| Vazquez, Lawrence,19632 | 56.98 | 0.00 | 0.00 | 56.98 | 0.00 |
| Rana, Cindy,21367 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Hu, Edwin,24240 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Munoz, Natasha, M,24601 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Jiménez, Byron,16026 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Zhang, Glenn, A,13967 | 5721.91 | 0.00 | 0.00 | 2049.10 | 3672.81 |
| He, Karen, C,27861 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Sullivan, Ruth,27723 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Pal, Drew,11902 | 63.04 | 0.00 | 0.00 | 6.28 | 56.76 |
| Chande, Melvin, R,11460 | 8137.52 | 0.00 | 3399.99 | 2294.99 | 2442.54 |
| Kapoor, Kristina,11997 | 7029.78 | 0.00 | 3399.99 | 1249.84 | 2379.95 |
| Carlson, Armando,17484 | 126.96 | 0.00 | 0.00 | 21.98 | 104.98 |
| Mehta, Gerald,20234 | 32.28 | 0.00 | 0.00 | 32.28 | 0.00 |
Generated 2025-11-03 08:17:03.394 UTC