[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 66 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jai, Samuel, L,16358 | 87.95 | 0.00 | 0.00 | 0.00 | 87.95 |
| Thomas, Richard,27557 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Perez, Katherine, J,22079 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Sanders, Megan, A,15376 | 136.24 | 0.00 | 0.00 | 0.00 | 136.24 |
| Hayes, Luis,12880 | 200.73 | 0.00 | 0.00 | 0.00 | 200.73 |
| Turner, Eduardo,15876 | 4789.02 | 0.00 | 0.00 | 0.00 | 4789.02 |
| Morgan, Isaiah,18978 | 118.73 | 0.00 | 0.00 | 0.00 | 118.73 |
| Bryant, Isabelle,23397 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Evans, Dalton, E,12710 | 4774.04 | 0.00 | 0.00 | 0.00 | 4774.04 |
| Allen, Luke,11316 | 2349.98 | 0.00 | 0.00 | 2349.98 | 0.00 |
| Blue, Makayla,19000 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Jackson, Joseph, R,23592 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
Generated 2025-12-23 21:01:05.818 UTC