[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 124 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martin, Hector,27860 | 615.47 | 0.00 | 0.00 | 0.00 | 615.47 |
| Subram, Joe,13631 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Lu, Randy,26441 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Jiménez, Briana, T,28118 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Navarro, Marc,16346 | 37.55 | 0.00 | 0.00 | 0.00 | 37.55 |
| Carlson, Orlando, J,11893 | 8123.03 | 0.00 | 3374.99 | 2319.99 | 2428.05 |
| Diaz, Tyrone,13116 | 230.25 | 0.00 | 0.00 | 32.27 | 197.98 |
| Hu, Ramon,23439 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
| Ramos, Lance, S,28949 | 2473.05 | 0.00 | 0.00 | 2473.05 | 0.00 |
| Jimenez, Krista,18257 | 115.95 | 0.00 | 0.00 | 106.96 | 8.99 |
| Kumar, Lacey,13960 | 6871.74 | 0.00 | 0.00 | 2071.42 | 4800.32 |
| Dominguez, Kristi, M,13644 | 6864.46 | 0.00 | 0.00 | 2071.42 | 4793.04 |
| Zhao, Bianca,13971 | 6772.13 | 0.00 | 0.00 | 2049.10 | 4723.03 |
| Serrano, Joy, L,14069 | 173.94 | 0.00 | 0.00 | 0.00 | 173.94 |
| Yuan, Darrell,18271 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Lal, Mitchell, C,20403 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Russell, Alexis, L,13634 | 234.93 | 0.00 | 0.00 | 0.00 | 234.93 |
| Hall, Haley,27489 | 1383.45 | 0.00 | 0.00 | 782.99 | 600.46 |
| Gill, Anne,27469 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Serrano, Reginald, J,13025 | 2690.40 | 0.00 | 0.00 | 2071.42 | 618.98 |
| Ramos, Tanya, R,14045 | 6804.13 | 0.00 | 0.00 | 2049.10 | 4755.03 |
| Zheng, Alan,11050 | 5007.30 | 3374.99 | 0.00 | 854.97 | 777.34 |
| Lin, Damien, L,23414 | 3391.03 | 0.00 | 0.00 | 3391.03 | 0.00 |
| Ramos, Rodney, C,14059 | 106.75 | 0.00 | 0.00 | 74.48 | 32.27 |
| Xie, Ricardo,18710 | 6098.58 | 0.00 | 3578.27 | 2520.31 | 0.00 |
| Zheng, Vincent,18496 | 6121.71 | 0.00 | 3578.27 | 2543.44 | 0.00 |
| Weber, Deanna, L,14855 | 3759.08 | 0.00 | 0.00 | 2049.10 | 1709.98 |
| Chande, Katrina, L,19968 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Alan, Bob, A,27366 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Rodriguez, Douglas, W,19652 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Suarez, Natasha,14679 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
Generated 2025-11-06 12:16:17.488 UTC