[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Smith, Andrew,14723 | 87.57 | 0.00 | 0.00 | 87.57 | 0.00 |
| Simmons, Anna, K,12451 | 2367.92 | 0.00 | 0.00 | 2367.92 | 0.00 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 330.95 | 668.27 |
| Allen, Angel, G,15571 | 101.85 | 0.00 | 0.00 | 44.88 | 56.97 |
| Reed, Morgan, E,28779 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Baker, Gabriella,17404 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Thompson, Ryan, M,11330 | 1111.36 | 0.00 | 0.00 | 623.78 | 487.58 |
| Sharma, Jackson,16876 | 151.84 | 0.00 | 0.00 | 34.89 | 116.95 |
| Moreno, Renee, C,12936 | 265.22 | 0.00 | 0.00 | 0.00 | 265.22 |
| Simmons, Jennifer,11262 | 1010.56 | 0.00 | 0.00 | 488.15 | 522.41 |
| Carter, Jose, H,12532 | 235.72 | 0.00 | 0.00 | 0.00 | 235.72 |
| Chandra, Brandy, P,11501 | 603.53 | 0.00 | 0.00 | 128.21 | 475.32 |
| Perez, Dalton,11091 | 1125.36 | 0.00 | 0.00 | 471.29 | 654.07 |
| Hayes, Brittany,13941 | 286.82 | 0.00 | 0.00 | 38.88 | 247.94 |
| Kelly, Bailey, R,28284 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Hughes, Austin, P,18368 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Rowe, Todd,14586 | 233.94 | 0.00 | 0.00 | 0.00 | 233.94 |
| Allen, Madeline,29240 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Long, Rachel,28283 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wang, Austin, A,14632 | 84.97 | 0.00 | 0.00 | 9.99 | 74.98 |
| Davis, Marcus, T,17337 | 123.91 | 0.00 | 0.00 | 101.93 | 21.98 |
| Lewis, Brianna, H,14282 | 166.24 | 0.00 | 0.00 | 74.98 | 91.26 |
| Jenkins, Samantha,11331 | 1290.33 | 0.00 | 0.00 | 822.35 | 467.98 |
| Torres, Pedro, E,16958 | 168.02 | 0.00 | 0.00 | 168.02 | 0.00 |
| Roberts, Mason, D,11176 | 1106.68 | 0.00 | 0.00 | 693.99 | 412.69 |
| Rogers, Shelby,11712 | 127.80 | 0.00 | 0.00 | 97.81 | 29.99 |
| Baker, Mason, A,13270 | 2394.95 | 0.00 | 0.00 | 0.00 | 2394.95 |
| Richardson, Devin, G,21318 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
Generated 2026-07-22 22:19:38.624 UTC