[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 55 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Morris, Jessica,28967 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Gray, Jesse,14626 | 197.04 | 0.00 | 0.00 | 0.00 | 197.04 |
| Carter, Katherine,11861 | 286.30 | 0.00 | 0.00 | 0.00 | 286.30 |
| Alexander, Sarah,19411 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Raman, Emmanuel, W,19554 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Edwards, Madeline,20771 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Butler, Morgan, E,20500 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Morgan, Andrea, M,16870 | 149.04 | 0.00 | 0.00 | 39.47 | 109.57 |
| Robinson, Zachary, L,13709 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
| Mitchell, Thomas, J,13711 | 2380.47 | 0.00 | 0.00 | 0.00 | 2380.47 |
| Robinson, Julia,28121 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Turner, Morgan,11823 | 178.47 | 0.00 | 0.00 | 0.00 | 178.47 |
Generated 2025-12-22 08:26:55.662 UTC