[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 125 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Evans, Kaylee,19642 | 133.54 | 0.00 | 0.00 | 0.00 | 133.54 |
| Cooper, Paige,14119 | 148.94 | 0.00 | 0.00 | 0.00 | 148.94 |
| Bailey, Richard, N,22050 | 4160.53 | 3578.27 | 0.00 | 0.00 | 582.26 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 81.49 | 917.73 |
| Young, Sierra, J,11619 | 634.84 | 0.00 | 0.00 | 34.99 | 599.85 |
| Allen, Angel, G,15571 | 101.85 | 0.00 | 0.00 | 34.89 | 66.96 |
| Simmons, Jennifer,11262 | 1010.56 | 0.00 | 0.00 | 207.93 | 802.63 |
| Diaz, Kaitlyn, B,29230 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Bryant, Rachel,22019 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Xu, Louis,20104 | 66.53 | 0.00 | 0.00 | 66.53 | 0.00 |
| Jenkins, Samantha,11331 | 1290.33 | 0.00 | 0.00 | 410.31 | 880.02 |
| Wood, Gavin,16964 | 108.54 | 0.00 | 0.00 | 93.56 | 14.98 |
| Roberts, Mason, D,11176 | 1106.68 | 0.00 | 0.00 | 494.64 | 612.04 |
| Patterson, Eduardo,11142 | 866.81 | 0.00 | 0.00 | 72.26 | 794.55 |
| Wang, Austin, A,14632 | 84.97 | 0.00 | 0.00 | 9.99 | 74.98 |
Generated 2025-11-05 21:58:26.229 UTC