[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 125 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lopez, Katelyn,11820 | 232.71 | 0.00 | 0.00 | 60.47 | 172.24 |
| Gomez, Rebekah,13486 | 225.44 | 0.00 | 0.00 | 0.00 | 225.44 |
| Zeng, Jake,18054 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Patterson, Eduardo,11142 | 866.81 | 0.00 | 0.00 | 72.26 | 794.55 |
| Washington, Alexandra, E,15498 | 256.52 | 0.00 | 0.00 | 74.46 | 182.06 |
| Jai, Samuel, L,16358 | 87.95 | 0.00 | 0.00 | 39.99 | 47.96 |
| Thompson, Ryan, M,11330 | 1111.36 | 0.00 | 0.00 | 198.94 | 912.42 |
| Martin, John, A,14436 | 4776.01 | 0.00 | 0.00 | 0.00 | 4776.01 |
| Chandra, Brandy, P,11501 | 603.53 | 0.00 | 0.00 | 0.00 | 603.53 |
| Hill, Kaitlyn, M,24659 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Gonzales, Nathan, M,12107 | 222.23 | 0.00 | 0.00 | 32.27 | 189.96 |
| Gonzales, Ashley, C,18600 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Ashe, Alexis, S,19414 | 1145.48 | 0.00 | 0.00 | 0.00 | 1145.48 |
| Russell, Oscar, A,12140 | 118.17 | 0.00 | 0.00 | 0.00 | 118.17 |
| Phillips, Aaron, R,24947 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thomas, Wyatt, R,12431 | 154.54 | 0.00 | 0.00 | 94.98 | 59.56 |
| Baker, Sara, M,11827 | 512.47 | 0.00 | 0.00 | 148.47 | 364.00 |
| Stewart, Sara,17347 | 119.72 | 0.00 | 0.00 | 0.00 | 119.72 |
| James, Bryce,13466 | 133.45 | 0.00 | 0.00 | 0.00 | 133.45 |
| Russell, Isabella, A,11507 | 645.78 | 0.00 | 0.00 | 28.48 | 617.30 |
| Howard, Danielle,28357 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Diaz, Luis, D,11203 | 801.77 | 0.00 | 0.00 | 124.99 | 676.78 |
| Hill, Carlos,12919 | 257.88 | 0.00 | 0.00 | 158.93 | 98.95 |
| Perry, Ana,11215 | 1155.52 | 0.00 | 0.00 | 292.94 | 862.58 |
| Washington, Aaron, L,24649 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Barnes, Ian, M,16106 | 133.54 | 0.00 | 0.00 | 0.00 | 133.54 |
| Perry, Justin, E,16758 | 3062.34 | 0.00 | 0.00 | 0.00 | 3062.34 |
| Lewis, Zachary, L,14760 | 167.26 | 0.00 | 0.00 | 0.00 | 167.26 |
| Ramos, Kristi,15176 | 4703.03 | 0.00 | 0.00 | 0.00 | 4703.03 |
| Jenkins, Melissa, R,15997 | 4746.34 | 0.00 | 0.00 | 0.00 | 4746.34 |
| Kelly, Bailey, R,28284 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
Generated 2025-11-06 10:55:45.607 UTC