[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 52 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| James, Emma,12781 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Carter, Sydney,12959 | 203.92 | 0.00 | 0.00 | 0.00 | 203.92 |
| Cooper, Alexandra,19541 | 131.24 | 0.00 | 0.00 | 0.00 | 131.24 |
| Alexander, Ryan, J,14078 | 839.48 | 0.00 | 0.00 | 839.48 | 0.00 |
| Shan, Christian, L,23084 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Bryant, Rachel,22019 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gomez, Renee, L,25371 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Jackson, Andrew,20479 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Edwards, Hailey,24258 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perry, Christian,24671 | 4354.60 | 0.00 | 3578.27 | 0.00 | 776.33 |
| Torres, Victoria,17551 | 160.92 | 0.00 | 0.00 | 0.00 | 160.92 |
| Henderson, Jeremiah, D,18961 | 2369.96 | 0.00 | 0.00 | 0.00 | 2369.96 |
| Parker, Jennifer, D,22118 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Henderson, Gabrielle, B,18603 | 1205.47 | 0.00 | 0.00 | 0.00 | 1205.47 |
| Diaz, Kaitlyn, B,29230 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Edwards, Angel, J,29124 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ramirez, Gabrielle, H,16000 | 4813.95 | 0.00 | 0.00 | 0.00 | 4813.95 |
| Bryant, Jackson, J,25332 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Barnes, Elizabeth, J,24939 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Baker, Eduardo,18092 | 1789.45 | 0.00 | 0.00 | 0.00 | 1789.45 |
| Li, Eugene, A,15283 | 865.95 | 0.00 | 0.00 | 0.00 | 865.95 |
| Wright, Jackson,11698 | 225.95 | 0.00 | 0.00 | 0.00 | 225.95 |
| Xu, Louis,20104 | 66.53 | 0.00 | 0.00 | 0.00 | 66.53 |
| Thomas, Victoria, A,15536 | 249.53 | 0.00 | 0.00 | 0.00 | 249.53 |
Generated 2026-01-04 05:27:37.293 UTC