[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Reed, Mariah,26373 | 1565.91 | 0.00 | 1000.44 | 0.00 | 565.47 |
| Taylor, Zachary, M,27082 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Richardson, Olivia,20468 | 3169.59 | 0.00 | 2049.10 | 0.00 | 1120.49 |
| Bell, Eduardo,27101 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Cooper, Christina, C,26512 | 1000.44 | 0.00 | 1000.44 | 0.00 | 0.00 |
| Evans, James, C,20665 | 4408.56 | 0.00 | 2049.10 | 0.00 | 2359.46 |
| Howard, Alexandra,20736 | 3194.58 | 0.00 | 2049.10 | 0.00 | 1145.48 |
| Stewart, Cody, A,21284 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Ramirez, Jennifer, E,21311 | 4472.58 | 0.00 | 0.00 | 2049.10 | 2423.48 |
| Mitchell, Xavier, L,26533 | 1629.41 | 0.00 | 0.00 | 1000.44 | 628.97 |
| Patterson, Alexis,21348 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Simmons, Haley, T,26202 | 2749.32 | 0.00 | 0.00 | 2749.32 | 0.00 |
| Long, Morgan, H,21352 | 2625.39 | 0.00 | 0.00 | 2625.39 | 0.00 |
| Collins, Connor, J,27270 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Hall, Elizabeth, L,13474 | 339.48 | 0.00 | 0.00 | 83.95 | 255.53 |
| Ramirez, Makayla, L,17509 | 98.72 | 0.00 | 0.00 | 37.27 | 61.45 |
| Lee, William,13185 | 149.84 | 0.00 | 0.00 | 117.24 | 32.60 |
| Adams, Miguel,11659 | 213.52 | 0.00 | 0.00 | 64.97 | 148.55 |
| Jackson, Charles, P,11277 | 1305.66 | 0.00 | 0.00 | 790.61 | 515.05 |
| Ross, Natalie, J,12916 | 261.22 | 0.00 | 0.00 | 68.97 | 192.25 |
| Green, Chloe, J,14658 | 92.82 | 0.00 | 0.00 | 37.29 | 55.53 |
| Gonzalez, Jackson, S,14480 | 194.94 | 0.00 | 0.00 | 0.00 | 194.94 |
| Russell, Oscar, A,12140 | 118.17 | 0.00 | 0.00 | 32.28 | 85.89 |
| Young, Sierra, J,11619 | 634.84 | 0.00 | 0.00 | 244.70 | 390.14 |
| Scott, Haley,13701 | 154.54 | 0.00 | 0.00 | 36.59 | 117.95 |
| Hughes, Destiny, P,28027 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Stewart, Sara,17347 | 119.72 | 0.00 | 0.00 | 21.98 | 97.74 |
| Thomas, Benjamin, J,21295 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Gonzalez, Gabriella, Z,15872 | 235.54 | 0.00 | 0.00 | 0.00 | 235.54 |
| Murphy, Emma,19844 | 5807.93 | 3374.99 | 0.00 | 0.00 | 2432.94 |
| Long, Jordyn,17338 | 47.25 | 0.00 | 0.00 | 0.00 | 47.25 |
Generated 2026-07-22 21:37:42.725 UTC