[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Torres, Erin,12182 | 87.25 | 0.00 | 0.00 | 0.00 | 87.25 |
| Stewart, Lucas, J,29341 | 98.97 | 0.00 | 0.00 | 0.00 | 98.97 |
| Young, Savannah,25971 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Foster, Isabel, M,21745 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Taylor, Ryan,17025 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Adams, Gabriel, S,19527 | 1219.45 | 0.00 | 0.00 | 0.00 | 1219.45 |
| Williams, Destiny, S,15881 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Thomas, Zachary, D,28045 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Hughes, Luke, I,27014 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Carter, Bailey,21332 | 2616.86 | 0.00 | 0.00 | 2616.86 | 0.00 |
| Bennett, Maria, G,22983 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Morgan, Brianna, D,11136 | 2380.47 | 0.00 | 0.00 | 2380.47 | 0.00 |
| Ward, Devin, J,15378 | 170.91 | 0.00 | 0.00 | 0.00 | 170.91 |
| Coleman, Isabel, S,12530 | 337.90 | 0.00 | 0.00 | 0.00 | 337.90 |
| Martinez, Carol, D,17656 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Simmons, Caleb, M,12193 | 4833.03 | 0.00 | 0.00 | 0.00 | 4833.03 |
| Gonzales, Brianna, L,21148 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Garcia, Alexandra, J,14107 | 819.46 | 0.00 | 0.00 | 0.00 | 819.46 |
| Ramirez, Abigail, S,15859 | 74.14 | 0.00 | 0.00 | 0.00 | 74.14 |
| Jenkins, Gabrielle, B,21659 | 4143.74 | 3578.27 | 0.00 | 0.00 | 565.47 |
| Brown, Benjamin, D,15187 | 4725.32 | 0.00 | 0.00 | 0.00 | 4725.32 |
| Parker, Jeremy,28668 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Cox, Katelyn, B,21742 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Bennett, Isabelle, C,18674 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Davis, Dylan,15556 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Hughes, Nathan, B,12113 | 4737.53 | 0.00 | 0.00 | 0.00 | 4737.53 |
| Scott, Sean, F,24755 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lewis, Lucas, A,23209 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Coleman, Destiny, W,12122 | 4814.04 | 0.00 | 0.00 | 0.00 | 4814.04 |
| Alvarez, Melody,25070 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Foster, Isabelle,26377 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Walker, Emma, M,25209 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Nelson, Kevin,14765 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| Hughes, Riley,29284 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Peterson, Julia, P,16497 | 132.71 | 0.00 | 0.00 | 0.00 | 132.71 |
| Butler, Victoria,13284 | 4767.53 | 0.00 | 0.00 | 0.00 | 4767.53 |
| Harris, Megan,23281 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Smith, Nathan,21764 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Powell, Angela, R,12970 | 471.11 | 0.00 | 0.00 | 0.00 | 471.11 |
| Sun, Arturo, C,11498 | 557.54 | 0.00 | 0.00 | 0.00 | 557.54 |
| Washington, Vanessa,23819 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Russell, Isabella, A,11507 | 645.78 | 0.00 | 0.00 | 0.00 | 645.78 |
| Garcia, Patricia,11651 | 226.43 | 0.00 | 0.00 | 0.00 | 226.43 |
| Smith, Noah,13175 | 166.92 | 0.00 | 0.00 | 0.00 | 166.92 |
| Edwards, Eric,24627 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Hayes, Arianna,25991 | 2845.52 | 0.00 | 0.00 | 2181.56 | 663.96 |
| Parker, Jennifer, D,22118 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Sanz, Lori, L,23865 | 4891.61 | 0.00 | 3578.27 | 0.00 | 1313.34 |
| Clark, Emily, R,12086 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Bryant, Nathan,21450 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Perez, Dalton,11091 | 1125.36 | 0.00 | 0.00 | 67.97 | 1057.39 |
| Chandra, Brandy, P,11501 | 603.53 | 0.00 | 0.00 | 0.00 | 603.53 |
| Bell, Eduardo,27101 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Richardson, Brian,28608 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Anderson, Tyler, E,13148 | 1137.43 | 0.00 | 0.00 | 0.00 | 1137.43 |
| Perez, Charles,26693 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hill, Sydney,26482 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Patterson, Abigail, H,14478 | 4795.01 | 0.00 | 0.00 | 0.00 | 4795.01 |
| Ross, Natalie, J,12916 | 261.22 | 0.00 | 0.00 | 0.00 | 261.22 |
| Brooks, Bryce,12061 | 140.17 | 0.00 | 0.00 | 112.25 | 27.92 |
| Phillips, Adam, R,22748 | 4188.24 | 0.00 | 3578.27 | 0.00 | 609.97 |
| Chen, Luis, G,21252 | 94.45 | 0.00 | 0.00 | 0.00 | 94.45 |
Generated 2025-12-19 10:00:16.653 UTC