[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 63 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Long, Chloe,16784 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Peterson, Jessica, M,11868 | 247.01 | 0.00 | 0.00 | 61.97 | 185.04 |
| Long, Jordan,19988 | 4555.47 | 0.00 | 3399.99 | 0.00 | 1155.48 |
| Morris, Chase, F,26789 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Washington, Caroline, D,23114 | 5996.32 | 0.00 | 3578.27 | 0.00 | 2418.05 |
| Lewis, Lucas, A,23209 | 4802.11 | 0.00 | 3578.27 | 1223.84 | 0.00 |
| Gill, Beth,19997 | 5814.98 | 0.00 | 3374.99 | 0.00 | 2439.99 |
| Flores, Megan, N,23074 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| Powell, Elijah, E,23113 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Brooks, Isaac, M,23385 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Ware, Dennis, L,23725 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Jackson, Joseph, R,23592 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Alexander, Ashley, J,20007 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Bryant, Isabelle,23397 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| White, Cameron,23830 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Washington, Vanessa,23819 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Diaz, Aidan, L,23846 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Foster, Olivia,23806 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Long, Kaitlyn,23396 | 4891.61 | 0.00 | 3578.27 | 0.00 | 1313.34 |
| Peterson, Gabrielle, D,24310 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Campbell, Evan, W,24342 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Ms., Coleman, Abigail, C,23868 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Bennett, Seth,24493 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Allen, Aaron, A,20075 | 3399.99 | 0.00 | 3399.99 | 0.00 | 0.00 |
| Martinez, Hannah, M,24666 | 4370.61 | 0.00 | 3578.27 | 0.00 | 792.34 |
| Hall, Lauren, A,19648 | 100.84 | 0.00 | 0.00 | 0.00 | 100.84 |
| Rodriguez, Nicholas, D,14604 | 137.95 | 0.00 | 0.00 | 58.97 | 78.98 |
| Cox, Devin, C,13418 | 4768.05 | 0.00 | 0.00 | 0.00 | 4768.05 |
| Simmons, Jennifer,11262 | 1010.56 | 0.00 | 0.00 | 207.93 | 802.63 |
| Ramirez, Makayla, L,17509 | 98.72 | 0.00 | 0.00 | 0.00 | 98.72 |
| Griffin, Jack, L,17686 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Bailey, Lauren,15864 | 103.55 | 0.00 | 0.00 | 0.00 | 103.55 |
| Lee, William,13185 | 149.84 | 0.00 | 0.00 | 69.97 | 79.87 |
| Barnes, Jeremy,21446 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Ross, Natalie, J,12916 | 261.22 | 0.00 | 0.00 | 0.00 | 261.22 |
| Griffin, Thomas, J,19015 | 125.43 | 0.00 | 0.00 | 94.46 | 30.97 |
| Hall, Jan, M,11740 | 334.12 | 0.00 | 0.00 | 235.15 | 98.97 |
| Flores, Eduardo, S,28969 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Roberts, Seth, H,11510 | 258.15 | 0.00 | 0.00 | 39.47 | 218.68 |
| Brooks, Ian, W,28290 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Miller, Sydney, A,13440 | 4818.53 | 0.00 | 0.00 | 0.00 | 4818.53 |
| Jai, Edwin,16921 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Cooper, Ariana,17348 | 205.42 | 0.00 | 0.00 | 0.00 | 205.42 |
| White, Edward, J,15847 | 205.46 | 0.00 | 0.00 | 0.00 | 205.46 |
| Edwards, Angel, J,29124 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Washington, Victoria,23557 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Bell, Christina,26099 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Young, Savannah,25971 | 2749.32 | 0.00 | 2181.56 | 0.00 | 567.76 |
| Taylor, Christian,20764 | 56.76 | 0.00 | 0.00 | 0.00 | 56.76 |
| Rubio, Kellie,27653 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Russell, Elijah, M,11835 | 4772.30 | 0.00 | 0.00 | 2319.26 | 2453.04 |
| Phillips, Devin,18759 | 112.06 | 0.00 | 0.00 | 0.00 | 112.06 |
| Lal, Caleb, R,15868 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| She, Alisha, G,24757 | 4343.59 | 0.00 | 3578.27 | 0.00 | 765.32 |
| Li, Connor,20186 | 3191.91 | 0.00 | 2071.42 | 0.00 | 1120.49 |
| Garcia, Carmen, J,24781 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Murphy, Olivia, V,20206 | 3204.58 | 0.00 | 2049.10 | 0.00 | 1155.48 |
| Griffin, Madison, A,25093 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Adams, Haley, M,24786 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Sanders, Paige,25287 | 2983.34 | 0.00 | 2443.35 | 0.00 | 539.99 |
| Jai, Adam,25095 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Gray, Alexandria, E,25363 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
Generated 2025-11-06 08:45:34.165 UTC