[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 30 < SKIP 1375 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Luo, Maurice, C,27491 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Madan, Kristi, I,29184 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Rodriguez, Sergio, D,15239 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| She, Colin, M,15139 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Diaz, Kendra,13021 | 2668.38 | 0.00 | 0.00 | 2071.42 | 596.96 |
| Lin, Rafael,14099 | 200.26 | 0.00 | 0.00 | 0.00 | 200.26 |
| Navarro, Mathew, A,19673 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Mehta, Brandy,22839 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Carlson, Alfredo,16178 | 108.85 | 0.00 | 0.00 | 0.00 | 108.85 |
| Rodriguez, Cynthia, E,22206 | 201.28 | 0.00 | 0.00 | 0.00 | 201.28 |
| Diaz, Dana, C,12361 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Martinez, Troy, L,20823 | 4216.75 | 0.00 | 3578.27 | 0.00 | 638.48 |
| Moreno, Dwayne, T,23103 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Beck, Ashlee, L,26666 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Russell, Stephanie,20255 | 75.48 | 0.00 | 0.00 | 0.00 | 75.48 |
| Ortega, Julio, M,11892 | 8119.03 | 0.00 | 3399.99 | 0.00 | 4719.04 |
| Pal, Casey,16522 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Rai, Brad, S,18490 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Carlson, Audrey, A,25263 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Romero, Rodney,14521 | 117.96 | 0.00 | 0.00 | 0.00 | 117.96 |
| Wright, Haley,26036 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Vazquez, Marvin, K,21953 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Ramos, Tanya, R,14045 | 6804.13 | 0.00 | 0.00 | 2049.10 | 4755.03 |
| Rubio, Erika, A,11452 | 8183.04 | 0.00 | 3374.99 | 2414.99 | 2393.06 |
| Gutierrez, Jaime, A,25227 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Torres, Bailey,18259 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Sharma, Misty,25708 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Campbell, Haley, L,17304 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Zhu, Alan,17320 | 4391.74 | 0.00 | 3578.27 | 0.00 | 813.47 |
| Serrano, Neil, L,17076 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Gutierrez, Meredith, T,11111 | 8137.00 | 0.00 | 3399.99 | 0.00 | 4737.01 |
Generated 2025-12-24 07:08:44.377 UTC