[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 73 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanders, Hailey,19647 | 282.04 | 0.00 | 0.00 | 0.00 | 282.04 |
| Edwards, Amber, B,20517 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Gonzales, Ryan, M,17373 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Wright, Jennifer,26505 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Campbell, Lucas,29329 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Carter, Jose, H,12532 | 235.72 | 0.00 | 0.00 | 0.00 | 235.72 |
| Mitchell, Caleb, K,26806 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Anderson, Isabella,13743 | 2349.98 | 0.00 | 0.00 | 0.00 | 2349.98 |
| Gonzales, Emily, P,21777 | 180.98 | 0.00 | 0.00 | 0.00 | 180.98 |
| Garcia, Lucas,27545 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Stewart, Alex, M,20084 | 63.15 | 0.00 | 0.00 | 0.00 | 63.15 |
| Robinson, Zachary, L,13709 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
| Ward, Ian,12056 | 213.92 | 0.00 | 0.00 | 0.00 | 213.92 |
| Phillips, Jackson, D,23378 | 5317.23 | 0.00 | 3578.27 | 0.00 | 1738.96 |
Generated 2025-12-21 12:38:18.480 UTC