[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 83 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chander, Wayne, S,24344 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Campbell, Alex,11984 | 4730.32 | 0.00 | 0.00 | 0.00 | 4730.32 |
| Turner, Eduardo,15876 | 4789.02 | 0.00 | 0.00 | 0.00 | 4789.02 |
| Long, Morgan, H,21352 | 2625.39 | 0.00 | 0.00 | 2071.42 | 553.97 |
| Anderson, David, A,22097 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Moore, Taylor, A,19987 | 4564.45 | 0.00 | 3374.99 | 0.00 | 1189.46 |
| Carter, Bailey,21332 | 2616.86 | 0.00 | 0.00 | 2049.10 | 567.76 |
| Cook, Seth,23010 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Cook, Steven, J,27053 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Anderson, Megan, A,23859 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Thomas, Jeremiah,18372 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Davis, James,11922 | 275.50 | 0.00 | 0.00 | 0.00 | 275.50 |
| Parker, Madeline, H,22182 | 6006.32 | 0.00 | 3578.27 | 0.00 | 2428.05 |
| Collins, Eduardo,13987 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Butler, Isabel,16241 | 126.96 | 0.00 | 0.00 | 0.00 | 126.96 |
| Harris, Noah,29256 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Wilson, Christian,27085 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Smith, Katherine, J,13197 | 105.19 | 0.00 | 0.00 | 0.00 | 105.19 |
| Ward, Ian,12056 | 213.92 | 0.00 | 0.00 | 0.00 | 213.92 |
| Allen, Mason,17625 | 2431.95 | 0.00 | 0.00 | 0.00 | 2431.95 |
| Carter, Savannah, M,12090 | 2350.96 | 0.00 | 0.00 | 0.00 | 2350.96 |
| Price, Jocelyn, D,25875 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Powell, Jordyn, K,15391 | 4828.01 | 0.00 | 0.00 | 0.00 | 4828.01 |
| Brooks, Victoria, H,16479 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
Generated 2025-12-22 09:52:43.680 UTC