[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Luo, Ashlee,23534 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Sai, Ruth, D,24461 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Sai, Ronald, B,13643 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Alonso, Danny, S,18217 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Young, Marcus, A,18494 | 6037.89 | 0.00 | 3578.27 | 0.00 | 2459.62 |
| Diaz, Roberto, A,22202 | 4671.74 | 0.00 | 0.00 | 2181.56 | 2490.18 |
| Ramos, Joe,12353 | 6765.46 | 0.00 | 2071.42 | 0.00 | 4694.04 |
| Cooper, Cody, A,16028 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Patterson, Kyle,11448 | 8132.01 | 0.00 | 3374.99 | 2318.96 | 2438.06 |
| Price, Ian, J,22401 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Shen, Misty, S,25019 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Reed, Kimberly, D,17311 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Cai, Suzanne,25051 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Sanz, Lawrence, M,14030 | 6905.47 | 0.00 | 0.00 | 2071.42 | 4834.05 |
Generated 2025-12-20 23:20:26.426 UTC