[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 125 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Walker, Ian,16771 | 104.55 | 0.00 | 0.00 | 54.58 | 49.97 |
| Reed, Bryan,18884 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Gonzalez, James, M,18842 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Williams, Austin,20354 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Russell, Richard,27633 | 22.26 | 0.00 | 0.00 | 0.00 | 22.26 |
| Morris, Jessica,28967 | 8.99 | 0.00 | 0.00 | 8.99 | 0.00 |
| Washington, Aaron, L,24649 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Diaz, Brandon,23676 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Watson, Emma,17481 | 126.94 | 0.00 | 0.00 | 0.00 | 126.94 |
| Blanco, Armando, F,13918 | 2397.95 | 0.00 | 0.00 | 0.00 | 2397.95 |
| Madan, Carmen, V,15567 | 4720.27 | 0.00 | 0.00 | 0.00 | 4720.27 |
| Russell, Megan,16220 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Johnson, Ian, E,21732 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Thomas, Seth,14567 | 161.28 | 0.00 | 0.00 | 96.07 | 65.21 |
| Bennett, Jordyn, L,22230 | 4223.23 | 0.00 | 3578.27 | 0.00 | 644.96 |
| Moore, Seth,13851 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Baker, Robert, A,27300 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Phillips, Kyle,12158 | 202.20 | 0.00 | 0.00 | 0.00 | 202.20 |
| Jones, Joshua,18401 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Alexander, Aidan,17387 | 148.19 | 0.00 | 0.00 | 56.97 | 91.22 |
| Moore, Chloe, L,26269 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Cook, Jacqueline, A,19223 | 60.37 | 0.00 | 0.00 | 21.49 | 38.88 |
| Long, Chloe,16784 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Barnes, Alexandra, P,22268 | 6031.31 | 0.00 | 3578.27 | 0.00 | 2453.04 |
| Thomas, Richard,27557 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Blue, Marcus, L,27550 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Gonzalez, Amber, L,23879 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Roberts, Amber, W,21582 | 2638.06 | 0.00 | 0.00 | 2049.10 | 588.96 |
| Rowe, Todd,14586 | 233.94 | 0.00 | 0.00 | 0.00 | 233.94 |
| Reed, Megan, A,18118 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Foster, Abigail,19823 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
Generated 2025-11-06 06:14:29.240 UTC