[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 434 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xu, Alisha,14100 | 226.26 | 0.00 | 0.00 | 0.00 | 226.26 |
| Russell, Alexis, L,13634 | 234.93 | 0.00 | 0.00 | 0.00 | 234.93 |
| Bryant, Lauren,11752 | 137.87 | 0.00 | 0.00 | 0.00 | 137.87 |
| Sun, Jorge,16025 | 3831.89 | 0.00 | 0.00 | 2071.42 | 1760.47 |
| Cox, Michelle, E,17328 | 4387.74 | 0.00 | 3578.27 | 0.00 | 809.47 |
| Black, Tommy,24376 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Tang, Cristina, D,19623 | 153.93 | 0.00 | 0.00 | 0.00 | 153.93 |
| Rana, Ruben,27696 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Nath, Melvin, D,27697 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Gill, Mathew, M,27486 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Roberts, Jennifer,11447 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Xu, Cedric, M,24278 | 184.48 | 0.00 | 0.00 | 0.00 | 184.48 |
| Fernandez, Donald, C,24462 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Hernandez, Gina,14049 | 5290.68 | 0.00 | 0.00 | 2071.42 | 3219.26 |
| Perez, Preston,12370 | 61.53 | 0.00 | 0.00 | 0.00 | 61.53 |
| Zheng, Randy, B,22574 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| She, Glenn, L,29117 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Wilson, Jasmine,17329 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Rubio, Randall, M,17286 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Madan, Cassandra, D,29068 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Patel, Virginia, R,11366 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Chande, Melvin, R,11460 | 8137.52 | 0.00 | 3399.99 | 0.00 | 4737.53 |
| Long, Nicole, C,13624 | 114.97 | 0.00 | 0.00 | 0.00 | 114.97 |
| Navarro, Julio, M,25822 | 1819.59 | 0.00 | 699.10 | 0.00 | 1120.49 |
| Sharma, Christian,15809 | 62.59 | 0.00 | 0.00 | 0.00 | 62.59 |
| Chande, Warren,17307 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| Sai, Ivan, E,17300 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Jai, Bonnie,11977 | 8212.50 | 0.00 | 3399.99 | 0.00 | 4812.51 |
| Rubio, Larry,14223 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Russell, Ashley,12000 | 8183.00 | 0.00 | 3399.99 | 0.00 | 4783.01 |
| Anand, Andrés,11096 | 8063.04 | 0.00 | 3374.99 | 0.00 | 4688.05 |
| Guo, Martha, A,28536 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Sanz, Larry,14067 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Baker, Luke, J,22952 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Travers, Alexa, A,24466 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Andersen, Deborah,19610 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Kovár, Donald, M,24277 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Gonzales, Alexis,23521 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Nara, Tommy,16729 | 38.92 | 0.00 | 0.00 | 0.00 | 38.92 |
| Navarro, Carolyn,11069 | 8104.05 | 0.00 | 3399.99 | 0.00 | 4704.06 |
| Torres, Ruben,11002 | 8114.04 | 3399.99 | 0.00 | 2294.99 | 2419.06 |
| Vazquez, Theresa, F,22581 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Ma, Bianca,19798 | 128.44 | 0.00 | 0.00 | 0.00 | 128.44 |
| Dominguez, Darren, M,13966 | 6842.12 | 0.00 | 0.00 | 2049.10 | 4793.02 |
| Ramos, Kristine,17479 | 163.40 | 0.00 | 0.00 | 0.00 | 163.40 |
| Raji, Kathryn, C,21995 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Henderson, Wyatt,16697 | 87.08 | 0.00 | 0.00 | 0.00 | 87.08 |
| Nara, Ricardo,28934 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Cox, Jared, E,28114 | 570.47 | 0.00 | 0.00 | 0.00 | 570.47 |
| Gao, Arturo,28714 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Rodriguez, Rachael, M,11944 | 4776.27 | 0.00 | 3374.99 | 0.00 | 1401.28 |
| Nelson, Carol,13520 | 4551.36 | 0.00 | 0.00 | 2071.42 | 2479.94 |
| Prasad, Marco, C,15606 | 115.93 | 0.00 | 0.00 | 0.00 | 115.93 |
| Zhang, Dawn, A,14222 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Rubio, Juan,16170 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Madan, Marco,18895 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Tang, Terrence, R,17303 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Guo, Aimee,17075 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Martin, Roy,22065 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Allen, Devin,15806 | 102.85 | 0.00 | 0.00 | 0.00 | 102.85 |
| Campbell, Devin,23653 | 3975.03 | 0.00 | 0.00 | 2181.56 | 1793.47 |
| Ortega, Max,23413 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
Generated 2026-01-04 05:40:29.489 UTC