[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE SKIP 0 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Evans, Jesse,21916 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Harrison, Trevor, A,18055 | 143.91 | 0.00 | 0.00 | 36.96 | 106.95 |
| Wedge, Andrew, T,12060 | 4811.54 | 0.00 | 0.00 | 2418.48 | 2393.06 |
| Scott, Adam,15863 | 243.01 | 0.00 | 0.00 | 0.00 | 243.01 |
| McDonald, Aaron, J,27734 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Moore, Jessica, J,20085 | 76.76 | 0.00 | 0.00 | 0.00 | 76.76 |
| Van, Bobby,27757 | 132.97 | 0.00 | 0.00 | 132.97 | 0.00 |
| Navarro, Jerome, B,11519 | 717.28 | 0.00 | 0.00 | 22.18 | 695.10 |
| Williams, Ethan,24309 | 4793.12 | 0.00 | 3578.27 | 0.00 | 1214.85 |
| Harris, Isabella,17119 | 214.90 | 0.00 | 0.00 | 77.96 | 136.94 |
| Foster, Edward, R,18355 | 150.95 | 0.00 | 0.00 | 0.00 | 150.95 |
| Foster, Kayla,19693 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Phillips, Isaiah,28631 | 144.47 | 0.00 | 0.00 | 144.47 | 0.00 |
| Simmons, Dylan,16133 | 107.85 | 0.00 | 0.00 | 38.88 | 68.97 |
| Mehta, Rebekah, B,27419 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Perry, Ryan,13249 | 4795.34 | 0.00 | 0.00 | 0.00 | 4795.34 |
| Fernandez, Cesar,20035 | 5694.98 | 0.00 | 3374.99 | 0.00 | 2319.99 |
| Flores, Zachary, H,23376 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Powell, David, W,26615 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Cox, Julia, A,20670 | 3228.57 | 0.00 | 0.00 | 2049.10 | 1179.47 |
| Turner, Adam, K,16109 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Stewart, Andrea, M,27252 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Cooper, Alexandra,19541 | 131.24 | 0.00 | 0.00 | 0.00 | 131.24 |
| Hill, Timothy,14871 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Torres, Abigail,25367 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Miller, Sydney, A,13440 | 4818.53 | 0.00 | 0.00 | 0.00 | 4818.53 |
| Shan, Chad, M,24621 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Chen, Jack, E,17579 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Hill, Jordan, J,16005 | 198.73 | 0.00 | 0.00 | 102.27 | 96.46 |
| Rogers, Carlos,19645 | 134.44 | 0.00 | 0.00 | 0.00 | 134.44 |
| Foster, Trevor, J,28964 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
Generated 2025-11-03 14:07:24.193 UTC