[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 594 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Flores, Arianna,21727 | 4132.24 | 3578.27 | 0.00 | 0.00 | 553.97 |
| Garcia, Alexandra, J,14107 | 819.46 | 0.00 | 0.00 | 819.46 | 0.00 |
| Scott, Mason,23551 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Stewart, Andrea, M,27252 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Thompson, Xavier, R,15761 | 192.41 | 0.00 | 0.00 | 0.00 | 192.41 |
| Butler, Ana,26040 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Rivera, Allison, M,13751 | 224.91 | 0.00 | 0.00 | 0.00 | 224.91 |
| Martinez, Matthew, L,16009 | 170.45 | 0.00 | 0.00 | 0.00 | 170.45 |
| King, Morgan,19681 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Yang, Aaron, C,25196 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Allen, Amanda,22353 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Foster, Samuel, M,18523 | 160.94 | 0.00 | 0.00 | 128.97 | 31.97 |
| Williams, Austin,20354 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Patterson, Maria, G,13330 | 94.95 | 0.00 | 0.00 | 0.00 | 94.95 |
| Ross, David, M,17143 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Cox, Sara, P,27758 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Miller, Eduardo,14561 | 158.84 | 0.00 | 0.00 | 49.97 | 108.87 |
| Sanders, Mason, G,23459 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Luis, D,11203 | 801.77 | 0.00 | 0.00 | 183.97 | 617.80 |
| Davis, Marcus, T,17337 | 123.91 | 0.00 | 0.00 | 86.95 | 36.96 |
| Anderson, Madison, G,28359 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Hill, Haley, J,16103 | 3142.32 | 0.00 | 0.00 | 792.34 | 2349.98 |
| Alexander, Angelica,22714 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Alexander, Logan, E,19116 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Diaz, Richard, A,26682 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Russell, Arianna,22728 | 149.93 | 0.00 | 0.00 | 149.93 | 0.00 |
| Reed, Erin, I,14353 | 128.84 | 0.00 | 0.00 | 74.98 | 53.86 |
| Jones, Samantha,18317 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Thompson, Tyler,27502 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Rogers, Bryce,17402 | 2304.98 | 0.00 | 0.00 | 0.00 | 2304.98 |
| Roberts, Wyatt,15900 | 699.97 | 0.00 | 0.00 | 699.97 | 0.00 |
Generated 2025-11-04 04:52:43.326 UTC