[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 640 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Washington, Taylor,21266 | 4525.07 | 0.00 | 0.00 | 2049.10 | 2475.97 |
| Rodriguez, Anthony, G,23829 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Roberts, Carlos,23196 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Griffin, Marcus,20756 | 34.56 | 0.00 | 0.00 | 0.00 | 34.56 |
| Cooper, Amanda, P,14606 | 4716.02 | 0.00 | 0.00 | 0.00 | 4716.02 |
| Watson, Cole, A,21768 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Johnson, Madison, L,15530 | 846.46 | 0.00 | 0.00 | 0.00 | 846.46 |
| Nath, Alison, J,17116 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Alexander, Jordan,21412 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Yang, Justin, S,15363 | 4719.04 | 0.00 | 0.00 | 0.00 | 4719.04 |
| Washington, Caroline, D,23114 | 5996.32 | 0.00 | 3578.27 | 0.00 | 2418.05 |
| Green, Xavier,23567 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Foster, Samuel, M,18523 | 160.94 | 0.00 | 0.00 | 128.97 | 31.97 |
| Hughes, Zachary,12203 | 157.91 | 0.00 | 0.00 | 0.00 | 157.91 |
| Henderson, Abigail,20441 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Price, Caroline,18051 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Reed, Kaylee, R,17371 | 151.92 | 0.00 | 0.00 | 0.00 | 151.92 |
| Campbell, Timothy,25845 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Perry, Lauren,24816 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yuan, Yolanda, C,22154 | 36.96 | 0.00 | 0.00 | 36.96 | 0.00 |
| Thomas, Emily,21803 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Morgan, Angela,24665 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Ruiz, Carrie, D,18644 | 135.44 | 0.00 | 0.00 | 100.46 | 34.98 |
| Luo, Franklin, J,22027 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Collins, Hailey,11709 | 325.89 | 0.00 | 0.00 | 21.49 | 304.40 |
| Murphy, Juan, T,24646 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Howard, Erin, L,18362 | 1725.21 | 0.00 | 0.00 | 0.00 | 1725.21 |
| Yuan, Leonard, F,16791 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Washington, Miranda,15201 | 4793.02 | 0.00 | 0.00 | 0.00 | 4793.02 |
| Phillips, Kyle,12158 | 202.20 | 0.00 | 0.00 | 0.00 | 202.20 |
Generated 2025-11-06 06:00:43.427 UTC