[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 22 < SKIP 3500 > < TAKE 1000
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Young, Morgan, L,12342 | 6838.12 | 0.00 | 2049.10 | 0.00 | 4789.02 |
| Chandra, Virginia, M,27588 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Martinez, Fernando,20454 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Wu, Marshall, J,15590 | 4440.05 | 0.00 | 0.00 | 2049.10 | 2390.95 |
| Cai, Susan,19101 | 104.42 | 0.00 | 0.00 | 0.00 | 104.42 |
| Chander, Misty,17333 | 80.94 | 0.00 | 0.00 | 0.00 | 80.94 |
| Gonzalez, Devin,18485 | 6063.21 | 0.00 | 3578.27 | 0.00 | 2484.94 |
| Shen, Willie, S,18450 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Zimmerman, Jenny,18197 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Sanz, Meghan, L,28352 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Martinez, Virginia,13136 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Alonso, Kathleen,21196 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Serrano, Alberto, L,15800 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Rubio, Natasha, K,13627 | 214.25 | 0.00 | 0.00 | 0.00 | 214.25 |
| Goel, Shawna, L,29332 | 165.28 | 0.00 | 0.00 | 0.00 | 165.28 |
Generated 2025-12-23 05:06:57.485 UTC