[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 14 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Anderson, Emma, A,18580 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Perry, Brandon,22095 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Wood, Gabrielle, S,28787 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Watson, Michelle, H,26235 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Davis, Justin,28074 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Li, Eugene, A,15283 | 865.95 | 0.00 | 0.00 | 0.00 | 865.95 |
| Russell, Richard,27633 | 22.26 | 0.00 | 0.00 | 0.00 | 22.26 |
| Carter, Jose, H,12532 | 235.72 | 0.00 | 0.00 | 0.00 | 235.72 |
| Brooks, Jacqueline, W,28254 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Martinez, Jonathan,13303 | 66.25 | 0.00 | 0.00 | 0.00 | 66.25 |
| Davis, James,11922 | 275.50 | 0.00 | 0.00 | 0.00 | 275.50 |
| Barnes, Ian, M,16106 | 133.54 | 0.00 | 0.00 | 0.00 | 133.54 |
| Robinson, Ian, D,13852 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Kumar, Cameron, S,18571 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Turner, Eduardo,15876 | 4789.02 | 0.00 | 0.00 | 0.00 | 4789.02 |
| Hall, Luke, E,14745 | 902.46 | 0.00 | 0.00 | 0.00 | 902.46 |
| Alexander, Lauren,18950 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Li, Jordan,17026 | 261.39 | 0.00 | 0.00 | 0.00 | 261.39 |
| Harris, Seth, M,16140 | 2528.33 | 0.00 | 0.00 | 0.00 | 2528.33 |
| Russell, Katherine,28771 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lee, John,19801 | 193.01 | 0.00 | 0.00 | 0.00 | 193.01 |
| _SUM | 1806517.50 | 25543.71 | 493581.21 | 255540.50 | 1031852.08 |
| Nelson, Jordan, H,20130 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Yang, Aaron, C,25196 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
Generated 2025-12-22 01:15:38.164 UTC