[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 65 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Nara, Ricardo,28934 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Xu, Lacey, S,17913 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Gutierrez, Adrienne,18906 | 4217.22 | 0.00 | 3578.27 | 638.95 | 0.00 |
| Kapoor, Candace,18282 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Alvarez, Reginald, A,18746 | 6135.09 | 0.00 | 3578.27 | 0.00 | 2556.82 |
| Jai, Lacey, C,11371 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Xie, Dawn,21391 | 29.99 | 0.00 | 0.00 | 29.99 | 0.00 |
| Jiménez, Briana, T,28118 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Liang, Christy, I,21239 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lin, Clayton, M,27492 | 1344.91 | 0.00 | 0.00 | 782.99 | 561.92 |
| Powell, Elizabeth, K,28306 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Guo, Tiffany,25927 | 1272.52 | 0.00 | 699.10 | 0.00 | 573.42 |
| Gonzalez, Ruth,12693 | 6820.47 | 0.00 | 0.00 | 2071.42 | 4749.05 |
| Raje, Jodi, E,19630 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
Generated 2025-12-22 00:21:38.580 UTC