[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 437 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Davis, Justin,28074 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| King, Caleb, J,28986 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Griffin, Miguel,21464 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Moore, Taylor, A,19987 | 4564.45 | 0.00 | 3374.99 | 0.00 | 1189.46 |
| Rodriguez, Alexandra,21642 | 2620.40 | 0.00 | 0.00 | 2071.42 | 548.98 |
| Bryant, Nathan,21450 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Brooks, Jennifer, L,17411 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Rodriguez, Morgan,23730 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Washington, Alexandra, E,15498 | 256.52 | 0.00 | 0.00 | 74.46 | 182.06 |
| Morris, Alyssa,28072 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Brown, Anna,16247 | 95.82 | 0.00 | 0.00 | 0.00 | 95.82 |
| Henderson, Stephanie, L,19224 | 352.52 | 0.00 | 0.00 | 0.00 | 352.52 |
| Baker, Sara, M,11827 | 512.47 | 0.00 | 0.00 | 148.47 | 364.00 |
| She, Alisha, G,24757 | 4343.59 | 0.00 | 3578.27 | 0.00 | 765.32 |
| Tang, Carl,21238 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Taylor, Marcus, A,18944 | 146.94 | 0.00 | 0.00 | 0.00 | 146.94 |
| Baker, Sean, T,24778 | 2858.49 | 0.00 | 2181.56 | 676.93 | 0.00 |
| White, James,25331 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ross, Anna, D,15494 | 275.44 | 0.00 | 0.00 | 29.99 | 245.45 |
| Barnes, Fernando,11300 | 1390.55 | 0.00 | 0.00 | 248.38 | 1142.17 |
| Robinson, Joseph,28141 | 94.48 | 0.00 | 0.00 | 94.48 | 0.00 |
| Li, Connor,20186 | 3191.91 | 0.00 | 2071.42 | 0.00 | 1120.49 |
| Carter, Marcus, l,21471 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| King, Sara,22354 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Johnson, Xavier, R,23255 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Garcia, Carmen, J,24781 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Ross, Antonio,18322 | 148.89 | 0.00 | 0.00 | 0.00 | 148.89 |
| Miller, Jill,12914 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Ward, Devin, J,15378 | 170.91 | 0.00 | 0.00 | 76.95 | 93.96 |
| Hill, Blake,11748 | 131.54 | 0.00 | 0.00 | 0.00 | 131.54 |
| Gray, Jesse,14626 | 197.04 | 0.00 | 0.00 | 0.00 | 197.04 |
Generated 2025-11-06 20:26:40.723 UTC