[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 62 < SKIP 250 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Bell, Eduardo,27101 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Garcia, Benjamin, L,17595 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 |
| Flores, Logan, K,14631 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Gray, Cody, C,14459 | 4775.01 | 0.00 | 0.00 | 0.00 | 4775.01 |
| Watson, Richard,15943 | 365.41 | 0.00 | 0.00 | 0.00 | 365.41 |
| Diaz, Gabrielle,14893 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Cox, Julia, A,20670 | 3228.57 | 0.00 | 0.00 | 2049.10 | 1179.47 |
| White, Edward, J,15847 | 205.46 | 0.00 | 0.00 | 0.00 | 205.46 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 10.24 | 988.98 |
| Washington, Miranda,15201 | 4793.02 | 0.00 | 0.00 | 0.00 | 4793.02 |
| Torres, Mackenzie,28153 | 570.47 | 0.00 | 0.00 | 0.00 | 570.47 |
| Richardson, Melissa, E,11132 | 2371.94 | 0.00 | 0.00 | 0.00 | 2371.94 |
| King, Gabrielle,26350 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Torres, Abigail,25367 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanchez, Trinity, J,26279 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Evans, Jordan,29209 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Williams, Ian, M,17558 | 1750.47 | 0.00 | 0.00 | 0.00 | 1750.47 |
| Li, Jordan,17026 | 261.39 | 0.00 | 0.00 | 0.00 | 261.39 |
| Peterson, Steven, L,23449 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Murphy, Emma,19844 | 5807.93 | 0.00 | 3374.99 | 0.00 | 2432.94 |
| Kelly, Erin, D,23513 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Moore, Anthony, M,24730 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martinez, Dominique,28788 | 8.99 | 0.00 | 0.00 | 8.99 | 0.00 |
| Hernandez, Sierra,27393 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Simmons, Haley, T,26202 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Ms., Coleman, Abigail, C,23868 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Taylor, Zachary, M,27082 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Malhotra, Brenda,13391 | 2405.47 | 0.00 | 0.00 | 0.00 | 2405.47 |
| Morris, Mason, J,22349 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Rogers, Olivia,12020 | 804.47 | 0.00 | 0.00 | 0.00 | 804.47 |
| Bennett, Jennifer, G,13708 | 123.94 | 0.00 | 0.00 | 0.00 | 123.94 |
| Nelson, Henry,19394 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Brown, Benjamin, D,15187 | 4725.32 | 0.00 | 0.00 | 0.00 | 4725.32 |
| Scott, Adam,15863 | 243.01 | 0.00 | 0.00 | 0.00 | 243.01 |
| Suarez, Juan, R,16763 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Davis, Jasmine, M,26529 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Barnes, Kayla,24256 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Mitchell, Maria, D,27404 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Rodriguez, Alexandra,21642 | 2620.40 | 0.00 | 0.00 | 2071.42 | 548.98 |
| Powell, Angela, R,12970 | 471.11 | 0.00 | 0.00 | 0.00 | 471.11 |
| Baker, Sara, M,11827 | 512.47 | 0.00 | 0.00 | 0.00 | 512.47 |
| Sánchez, Angela, C,17655 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Young, Jenna, W,16365 | 2490.18 | 0.00 | 0.00 | 0.00 | 2490.18 |
| Flores, Brandon, L,25621 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Alexander, Julian,13217 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Patterson, Hailey, I,11223 | 1155.90 | 0.00 | 0.00 | 64.98 | 1090.92 |
| Smith, Megan, J,26716 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Chen, Jackson, S,27075 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Henderson, Olivia,18859 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Griffin, Jennifer, B,14244 | 154.96 | 0.00 | 0.00 | 0.00 | 154.96 |
| Wu, Randy, J,11647 | 2365.94 | 0.00 | 0.00 | 0.00 | 2365.94 |
| Parker, Morgan, S,16772 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Hall, Kaylee, E,19751 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Hayes, Hannah, J,21656 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Hall, Amber,20106 | 131.95 | 0.00 | 0.00 | 0.00 | 131.95 |
| Alexander, Logan, E,19116 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Kapoor, Preston,21431 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Russell, Kaitlyn, M,24491 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| James, Emma,12781 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Scott, Sean, F,24755 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jones, Joshua,18401 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Watson, Janet, S,23208 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Anderson, Daniel,20694 | 146.97 | 0.00 | 0.00 | 0.00 | 146.97 |
| Patterson, Jeremy,13027 | 2319.26 | 0.00 | 0.00 | 0.00 | 2319.26 |
| Umeda, Masaki,16717 | 233.81 | 0.00 | 0.00 | 0.00 | 233.81 |
| Parker, Kaylee, M,27738 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Foster, Olivia,23806 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Cooper, Grace, C,16012 | 94.26 | 0.00 | 0.00 | 0.00 | 94.26 |
| Alexander, Taylor,17482 | 146.94 | 0.00 | 0.00 | 0.00 | 146.94 |
| Miller, Benjamin, G,26643 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Hu, Gilbert, L,28767 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hill, Timothy,14871 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Gomez, Rebekah,13486 | 225.44 | 0.00 | 0.00 | 0.00 | 225.44 |
| Perez, Kaitlyn, A,12081 | 2366.96 | 0.00 | 0.00 | 0.00 | 2366.96 |
| Wood, Brittany,28777 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Simmons, Adam,25327 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Diaz, Elijah,20000 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Brooks, Ian, W,28290 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Gonzalez, Molly,16370 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Foster, Caleb,27112 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Raman, Emmanuel, W,19554 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| White, Jennifer, S,27027 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Suri, Carolyn, S,12972 | 175.71 | 0.00 | 0.00 | 0.00 | 175.71 |
| Powell, Caleb, G,21613 | 2610.58 | 0.00 | 0.00 | 2049.10 | 561.48 |
| Henderson, Gabrielle, B,18603 | 1205.47 | 0.00 | 0.00 | 0.00 | 1205.47 |
| Chen, Ethan,20547 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Bradley, Alexandria,17691 | 1779.47 | 0.00 | 0.00 | 0.00 | 1779.47 |
| Hall, Jan, M,11740 | 334.12 | 0.00 | 0.00 | 0.00 | 334.12 |
| White, Judith, R,14885 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Anderson, Madison, G,28359 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Thompson, Brianna, X,18642 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Bailey, Alexandria, V,13209 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Clark, Destiny, L,28600 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Henderson, Ashley,11185 | 1381.37 | 0.00 | 0.00 | 0.00 | 1381.37 |
| Sanchez, Katherine, S,24399 | 132.94 | 0.00 | 0.00 | 0.00 | 132.94 |
| Patterson, Cassidy, A,17586 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Hernandez, José, M,11253 | 696.61 | 0.00 | 0.00 | 0.00 | 696.61 |
| White, James,25331 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Carter, Jose, H,12532 | 235.72 | 0.00 | 0.00 | 0.00 | 235.72 |
| Martin, Jill, C,11824 | 181.03 | 0.00 | 0.00 | 0.00 | 181.03 |
| Allen, Madeline,29240 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Richardson, Nathaniel,12089 | 4710.03 | 0.00 | 0.00 | 2316.97 | 2393.06 |
| Phillips, Kyle,12158 | 202.20 | 0.00 | 0.00 | 0.00 | 202.20 |
| Cooper, Brianna,25925 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Baker, Mason, A,13270 | 2394.95 | 0.00 | 0.00 | 0.00 | 2394.95 |
| Ward, Nicole, L,21272 | 4435.38 | 0.00 | 0.00 | 2071.42 | 2363.96 |
| Morgan, Isaiah,18978 | 118.73 | 0.00 | 0.00 | 0.00 | 118.73 |
| Li, Brandon,29339 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Rivera, Allison, M,13751 | 224.91 | 0.00 | 0.00 | 0.00 | 224.91 |
| Sanders, Chloe, C,23137 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Adams, Carlos,19822 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Barnes, Kaitlyn, Z,15162 | 154.96 | 0.00 | 0.00 | 0.00 | 154.96 |
| Campbell, Lucas,29329 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Perry, Jonathan, T,27026 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Anderson, Tyler, E,13148 | 1137.43 | 0.00 | 0.00 | 0.00 | 1137.43 |
| Mr., Sandstone, John, J,12903 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
| Brooks, Allison,14605 | 4750.01 | 0.00 | 0.00 | 0.00 | 4750.01 |
| Butler, Victoria,13284 | 4767.53 | 0.00 | 0.00 | 0.00 | 4767.53 |
| Patterson, Jocelyn, D,23559 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Edwards, Angel, J,29124 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Blue, Melanie, L,17861 | 1749.96 | 0.00 | 0.00 | 0.00 | 1749.96 |
| She, Kenneth,16096 | 212.01 | 0.00 | 0.00 | 0.00 | 212.01 |
| Watson, Cole, A,21768 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Flores, Emma, P,15543 | 180.94 | 0.00 | 0.00 | 0.00 | 180.94 |
| Nelson, Jose,19217 | 185.02 | 0.00 | 0.00 | 0.00 | 185.02 |
Generated 2025-12-22 00:16:23.953 UTC