[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 |
|---|---|---|---|---|---|
| Jackson, Hannah, G,13143 | 2404.97 | 0.00 | 0.00 | 0.00 | 2404.97 |
| Simmons, Sarah, V,11500 | 651.98 | 0.00 | 0.00 | 34.99 | 616.99 |
| Green, Chloe, J,14658 | 92.82 | 0.00 | 0.00 | 0.00 | 92.82 |
| Hughes, Justin, M,18122 | 2439.99 | 0.00 | 0.00 | 0.00 | 2439.99 |
| Ramirez, Sydney,26700 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Brooks, Jennifer, L,17411 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Zhang, Connor, R,13853 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Roberts, Wyatt,15900 | 699.97 | 0.00 | 0.00 | 0.00 | 699.97 |
| Lewis, Rachel, J,14900 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Li, Rafael, M,21752 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Campbell, Jordan,13290 | 111.89 | 0.00 | 0.00 | 0.00 | 111.89 |
| Williams, Destiny, S,15881 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Williams, Ryan, R,22247 | 5978.61 | 0.00 | 3578.27 | 0.00 | 2400.34 |
| Gonzalez, Katherine,22234 | 5976.32 | 0.00 | 3578.27 | 0.00 | 2398.05 |
| Patterson, Taylor,12147 | 271.45 | 0.00 | 0.00 | 0.00 | 271.45 |
| Griffin, Jordan,13095 | 328.89 | 0.00 | 0.00 | 0.00 | 328.89 |
| Campbell, Kevin, S,12177 | 4811.50 | 0.00 | 0.00 | 0.00 | 4811.50 |
| Cox, Sara, P,27758 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ward, Natalie, J,13241 | 2325.96 | 0.00 | 0.00 | 0.00 | 2325.96 |
| Coleman, Logan,18686 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Foster, Isabelle,26377 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Stewart, Andrea, M,27252 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Washington, Lauren, R,22998 | 5329.25 | 0.00 | 3578.27 | 1750.98 | 0.00 |
| Gray, Mariah,22278 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Phillips, Aaron, R,24947 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Foster, Edward, R,18355 | 150.95 | 0.00 | 0.00 | 0.00 | 150.95 |
| Sanchez, Faith,27049 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ross, Miranda,14598 | 4839.00 | 0.00 | 0.00 | 0.00 | 4839.00 |
| Bailey, Marcus, L,18329 | 146.53 | 0.00 | 0.00 | 23.78 | 122.75 |
| Hernandez, Jamie,27283 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Gonzales, Kayla,21494 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Long, Sarah,17372 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Carter, Marcus, l,21471 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Morgan, Isaiah,18978 | 118.73 | 0.00 | 0.00 | 0.00 | 118.73 |
| Cooper, Timothy, J,20651 | 3198.57 | 0.00 | 0.00 | 2049.10 | 1149.47 |
| Sanders, Megan, A,15376 | 136.24 | 0.00 | 0.00 | 0.00 | 136.24 |
| Torres, Xavier,16840 | 176.95 | 0.00 | 0.00 | 0.00 | 176.95 |
| Collins, Lucas, T,21921 | 4142.75 | 0.00 | 3578.27 | 0.00 | 564.48 |
| Martin, John, A,14436 | 4776.01 | 0.00 | 0.00 | 0.00 | 4776.01 |
| Huang, Kristen,25100 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Flores, Cassidy, L,23368 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lewis, Lucas, A,23209 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Perez, Jonathan, R,23455 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Watson, Victoria,16125 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Murphy, Catherine, L,16506 | 92.05 | 0.00 | 0.00 | 0.00 | 92.05 |
| Moore, Hunter,14897 | 196.27 | 0.00 | 0.00 | 0.00 | 196.27 |
| Harris, Megan,23281 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Scott, Mason,23551 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Garcia, Victoria, V,24501 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Martinez, Andrew, C,11530 | 523.81 | 0.00 | 0.00 | 78.48 | 445.33 |
| Carter, Luis, E,25883 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Ward, Lucas, N,18363 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Gray, Isabella,16820 | 3217.79 | 0.00 | 0.00 | 0.00 | 3217.79 |
| Mehta, Rebekah, B,27419 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Butler, Ana,26040 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Kelly, Trinity,26095 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Russell, Katherine,28771 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ross, Kaitlyn,16121 | 614.47 | 0.00 | 0.00 | 0.00 | 614.47 |
| Sanchez, Katherine, S,24399 | 132.94 | 0.00 | 0.00 | 0.00 | 132.94 |
| Brooks, Ian, W,28290 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Young, Kaitlyn, J,25062 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Taylor, Christian,20764 | 56.76 | 0.00 | 0.00 | 0.00 | 56.76 |
Generated 2025-12-21 12:37:48.451 UTC