[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 4 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Powell, Rachel,20818 | 4230.73 | 0.00 | 3578.27 | 0.00 | 652.46 |
| Serrano, Rebekah,14130 | 3814.06 | 0.00 | 0.00 | 2049.10 | 1764.96 |
| Murphy, Seth, A,25704 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Luo, Darrell, J,21187 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Andersen, Deborah,19610 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Serrano, Anne,24244 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Jimenez, Julio,24005 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Hayes, Edward,15796 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Sharma, Raul, E,16347 | 5918.50 | 3578.27 | 0.00 | 0.00 | 2340.23 |
| Rodriguez, Joel, C,16488 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Cox, Nicole, V,22950 | 3917.54 | 0.00 | 0.00 | 3917.54 | 0.00 |
| Serrano, Marvin, E,17316 | 97.45 | 0.00 | 0.00 | 0.00 | 97.45 |
| He, Aimee, A,11093 | 8180.00 | 0.00 | 3399.99 | 2360.95 | 2419.06 |
| Zhou, Stacey, L,21374 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Diaz, Roberto, A,22202 | 4671.74 | 0.00 | 0.00 | 2181.56 | 2490.18 |
| Sutton, Jaime, L,16630 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Lu, Margaret, D,20814 | 4186.23 | 0.00 | 3578.27 | 0.00 | 607.96 |
| Gonzalez, Devin,18485 | 6063.21 | 0.00 | 3578.27 | 0.00 | 2484.94 |
| Munoz, Latasha,11967 | 8153.02 | 0.00 | 3374.99 | 0.00 | 4778.03 |
| Srini, Roy,24888 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Gutierrez, Adrienne,18906 | 4217.22 | 0.00 | 3578.27 | 638.95 | 0.00 |
| Holt, Krystal,16518 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Romero, Kathleen,14019 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Martin, Deanna,13091 | 6864.95 | 0.00 | 0.00 | 2071.42 | 4793.53 |
| Evans, Xavier,19098 | 122.24 | 0.00 | 0.00 | 0.00 | 122.24 |
| Suarez, Billy, M,17287 | 95.26 | 0.00 | 0.00 | 0.00 | 95.26 |
| Zheng, Vincent,18496 | 6121.71 | 0.00 | 3578.27 | 0.00 | 2543.44 |
| Lopez, Joe, L,27512 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
Generated 2025-12-23 07:10:20.612 UTC