[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 37 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Green, Devin, J,26440 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Mr., Sands, Patrick,14063 | 5676.25 | 0.00 | 0.00 | 2071.42 | 3604.83 |
| Gao, Trisha, A,28953 | 2462.55 | 0.00 | 0.00 | 0.00 | 2462.55 |
| Campbell, Jason, J,13625 | 6962.14 | 0.00 | 0.00 | 2049.10 | 4913.04 |
| She, Mandy, K,21972 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| James, Evan, V,11119 | 85.22 | 0.00 | 0.00 | 35.23 | 49.99 |
| Srini, Douglas, M,16733 | 35.26 | 0.00 | 0.00 | 0.00 | 35.26 |
| Ortega, Jill, A,20239 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Li, Aimee,17915 | 4792.73 | 0.00 | 3578.27 | 0.00 | 1214.46 |
| Kovar, Mayra, J,17312 | 4471.74 | 0.00 | 3578.27 | 0.00 | 893.47 |
| Gonzalez, Kristopher, C,19264 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Serrano, Kristi,20616 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Ramos, Joe,12353 | 6765.46 | 0.00 | 2071.42 | 0.00 | 4694.04 |
| Gonzalez, George, L,11942 | 4792.29 | 0.00 | 3399.99 | 614.96 | 777.34 |
| Gao, Laura,22029 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Chander, Edwin, T,17370 | 4742.74 | 0.00 | 3578.27 | 0.00 | 1164.47 |
| Suarez, Nelson,27355 | 1383.45 | 0.00 | 0.00 | 782.99 | 600.46 |
| Alvarez, Kristy,15588 | 4486.07 | 0.00 | 0.00 | 2049.10 | 2436.97 |
| Blanco, Erika, L,14669 | 90.25 | 0.00 | 0.00 | 0.00 | 90.25 |
| Chandra, Ann,18209 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Ruiz, Adrienne,13523 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
| Dominguez, Kristine, A,14020 | 6831.76 | 0.00 | 0.00 | 2071.42 | 4760.34 |
| Kumar, Katie, P,12341 | 6840.62 | 0.00 | 2049.10 | 0.00 | 4791.52 |
| Hernandez, Alberto, D,25029 | 2272.20 | 0.00 | 0.00 | 1000.44 | 1271.76 |
| Zhang, Kristen,27484 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Perez, Toni,15581 | 113.94 | 0.00 | 0.00 | 0.00 | 113.94 |
| Madan, Geoffrey, M,15241 | 51.91 | 0.00 | 0.00 | 0.00 | 51.91 |
| Russell, Cassidy, N,26144 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
Generated 2025-12-24 06:49:42.251 UTC