[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1013 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gao, Christy, D,26204 | 1967.45 | 0.00 | 0.00 | 782.99 | 1184.46 |
| Zhao, Marshall, C,22033 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Ye, Martha,22200 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Serrano, Reginald, J,13025 | 2690.40 | 0.00 | 0.00 | 2071.42 | 618.98 |
| Gao, Amy,21996 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Moreno, Felicia, A,12987 | 6759.47 | 0.00 | 0.00 | 2071.42 | 4688.05 |
| Lee, David, J,22199 | 4693.88 | 0.00 | 0.00 | 2181.56 | 2512.32 |
| Serrano, Jésus, B,12991 | 5641.90 | 0.00 | 0.00 | 2049.10 | 3592.80 |
| Suri, Arthur,26190 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Ortega, Anne,13011 | 6819.11 | 0.00 | 0.00 | 2049.10 | 4770.01 |
| Munoz, Craig, V,13076 | 6862.14 | 0.00 | 0.00 | 2049.10 | 4813.04 |
| Zhu, Candice, S,21219 | 4696.49 | 0.00 | 0.00 | 2181.56 | 2514.93 |
| Gao, Stacey,16662 | 4355.71 | 0.00 | 3578.27 | 777.44 | 0.00 |
| Alonso, Stacy,28315 | 556.93 | 0.00 | 0.00 | 0.00 | 556.93 |
| Romero, Gina,14234 | 5687.72 | 0.00 | 0.00 | 2071.42 | 3616.30 |
| Fernandez, Kristopher, O,19271 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Suarez, Nelson,27355 | 1383.45 | 0.00 | 0.00 | 782.99 | 600.46 |
| Long, Julian,12034 | 72.25 | 0.00 | 0.00 | 0.00 | 72.25 |
| Beck, Alejandro,11025 | 6576.80 | 3374.99 | 0.00 | 2405.47 | 796.34 |
| Malhotra, Cynthia,11358 | 5034.78 | 0.00 | 3374.99 | 0.00 | 1659.79 |
| Martin, Lance,25236 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ye, Amy,11073 | 191.90 | 0.00 | 0.00 | 0.00 | 191.90 |
| Yuan, Marshall, P,19978 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Vazquez, Joan, B,16332 | 147.23 | 0.00 | 0.00 | 0.00 | 147.23 |
| Chapman, Clifford, C,21168 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Srini, Carolyn, S,27371 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Srini, Manuel,24168 | 2790.52 | 0.00 | 0.00 | 2181.56 | 608.96 |
| Vazquez, Byron,11122 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Jai, Nichole, R,28348 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Chapman, Alicia, A,21418 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
Generated 2026-01-04 05:26:38.752 UTC