[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Yang, Darryl, K,21571 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Lopez, Francisco, L,18714 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Flores, Alexandra, C,26165 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Gutierrez, Joy, A,18466 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Travers, Danny,12587 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Nara, Cristina, R,19792 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Tang, Terrence, R,17303 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| She, Brittney, M,22942 | 3971.53 | 0.00 | 0.00 | 2181.56 | 1789.97 |
| Lal, Rafael, W,28945 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Yang, Lacey,13150 | 89.24 | 0.00 | 0.00 | 0.00 | 89.24 |
| Gutierrez, Tabitha, A,21884 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Chande, Carl,18932 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Chander, Alisha,12572 | 2611.41 | 0.00 | 2071.42 | 0.00 | 539.99 |
| Munoz, Shannon, S,29122 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Zhang, Edwin,15785 | 4454.35 | 0.00 | 0.00 | 2071.42 | 2382.93 |
Generated 2025-12-21 19:38:31.058 UTC