[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 88 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| He, Jake, M,24472 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Chandra, Jermaine, A,14299 | 5108.76 | 0.00 | 0.00 | 2071.42 | 3037.34 |
| Munoz, Robyn,14214 | 5759.87 | 0.00 | 0.00 | 2049.10 | 3710.77 |
| Garcia, Roy, H,15585 | 4367.02 | 0.00 | 0.00 | 2049.10 | 2317.92 |
| Tang, Sharon, M,15823 | 67.96 | 0.00 | 0.00 | 0.00 | 67.96 |
| Moreno, Hector,21183 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Watson, Anna,20238 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Richardson, Abigail, S,14236 | 5710.23 | 0.00 | 0.00 | 2071.42 | 3638.81 |
| Mr., Short, Carlos, M.,25139 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Zheng, Roger,29321 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Gomez, Kendra, J,23320 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Zhang, Barbara,16338 | 169.43 | 0.00 | 0.00 | 0.00 | 169.43 |
Generated 2026-01-04 05:40:39.680 UTC