[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 407 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Thomas, David,16836 | 3193.79 | 0.00 | 0.00 | 0.00 | 3193.79 |
| Perez, Amber, D,13318 | 214.26 | 0.00 | 0.00 | 0.00 | 214.26 |
| Coleman, Samuel, N,17450 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Rodriguez, Lucas, P,15942 | 191.87 | 0.00 | 0.00 | 0.00 | 191.87 |
| Griffin, Cassidy,26496 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Alexander, Ashley, J,20007 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Jai, Luis, A,18320 | 185.92 | 0.00 | 0.00 | 0.00 | 185.92 |
| Sanders, Megan, A,15376 | 136.24 | 0.00 | 0.00 | 0.00 | 136.24 |
| Ross, Rachel, C,20669 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Reed, Catherine, M,20380 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hayes, Dalton, C,18882 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Mr., Sandstone, John, J,12903 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
| Perry, Marcus, L,20656 | 3245.90 | 0.00 | 0.00 | 2071.42 | 1174.48 |
| Smith, Lucas, P,18090 | 64.91 | 0.00 | 0.00 | 0.00 | 64.91 |
| Flores, Arianna,21727 | 4132.24 | 3578.27 | 0.00 | 0.00 | 553.97 |
| Carter, Sydney,12959 | 203.92 | 0.00 | 0.00 | 0.00 | 203.92 |
| Anderson, Ashley,20680 | 3219.58 | 0.00 | 0.00 | 2049.10 | 1170.48 |
| Ramirez, Abigail, S,15859 | 74.14 | 0.00 | 0.00 | 0.00 | 74.14 |
| Tang, Carl,21238 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Nelson, Katherine,28021 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Gonzales, Brianna, L,21148 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Peterson, Jared,11502 | 829.37 | 0.00 | 0.00 | 53.99 | 775.38 |
| Johnson, James,23498 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Coleman, Alexandria, C,13289 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Howard, Alexandra,20736 | 3194.58 | 0.00 | 0.00 | 2049.10 | 1145.48 |
| Butler, Morgan, E,20500 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Carter, Marcus, l,21471 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Simmons, Haley, T,26202 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Butler, Ana,26040 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Johnson, Andrew, F,26294 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Jenkins, Gabrielle, B,21659 | 4143.74 | 3578.27 | 0.00 | 0.00 | 565.47 |
| Diaz, Jason,17374 | 206.63 | 0.00 | 0.00 | 89.46 | 117.17 |
| Thompson, Devin,20708 | 4406.40 | 0.00 | 0.00 | 2071.42 | 2334.98 |
| Russell, Jessica,26572 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Long, Xavier,11251 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| Harris, Anthony,21447 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Stewart, Cody, A,21284 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Thomas, Richard,27557 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| James, Sara,19802 | 3374.99 | 3374.99 | 0.00 | 0.00 | 0.00 |
| Parker, Katherine,13268 | 289.70 | 0.00 | 0.00 | 0.00 | 289.70 |
| Hall, Noah, A,15251 | 75.25 | 0.00 | 0.00 | 0.00 | 75.25 |
| Winston, Ethan, R,21622 | 2612.06 | 0.00 | 0.00 | 2049.10 | 562.96 |
| Green, Isabella,26620 | 699.10 | 699.10 | 0.00 | 0.00 | 0.00 |
| Richardson, Lauren, C,14867 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Barnes, Elizabeth, J,24939 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Thomas, Thomas,21629 | 2624.08 | 0.00 | 0.00 | 2049.10 | 574.98 |
| Yang, Justin, S,15363 | 4719.04 | 0.00 | 0.00 | 0.00 | 4719.04 |
| Gonzalez, Katherine,22234 | 5976.32 | 0.00 | 3578.27 | 0.00 | 2398.05 |
| Ward, Emma, W,21796 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Wilson, Victoria, R,27536 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Murphy, Emma,19844 | 5807.93 | 0.00 | 3374.99 | 0.00 | 2432.94 |
| Wang, Zachary,22144 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Suri, Carolyn, S,12972 | 175.71 | 0.00 | 0.00 | 0.00 | 175.71 |
| Powell, Jocelyn, A,21658 | 2641.89 | 0.00 | 0.00 | 2071.42 | 570.47 |
| Parker, Jennifer, D,22118 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Ward, Nicole, L,21272 | 4435.38 | 0.00 | 0.00 | 2071.42 | 2363.96 |
| Long, Sydney,27921 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Washington, Alexia,27613 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Murphy, Catherine, L,16506 | 92.05 | 0.00 | 0.00 | 0.00 | 92.05 |
| Lee, Alexander, S,18356 | 149.91 | 0.00 | 0.00 | 0.00 | 149.91 |
| Griffin, Isabelle,24986 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bryant, Zachary,21655 | 2648.07 | 0.00 | 0.00 | 2049.10 | 598.97 |
| Watson, Shelby, J,14911 | 867.97 | 0.00 | 0.00 | 0.00 | 867.97 |
| Torres, Abigail,25367 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Butler, Benjamin, C,18972 | 2369.97 | 0.00 | 0.00 | 0.00 | 2369.97 |
| Washington, Lauren, R,22998 | 5329.25 | 0.00 | 3578.27 | 1750.98 | 0.00 |
| Lopez, Eduardo, J,26640 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Ross, Anna, D,15494 | 275.44 | 0.00 | 0.00 | 0.00 | 275.44 |
| Alexander, Thomas,20760 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| King, Jordan, C,11020 | 2316.97 | 0.00 | 0.00 | 2316.97 | 0.00 |
| Simmons, Mariah,26683 | 1270.82 | 0.00 | 699.10 | 0.00 | 571.72 |
| Henderson, Gabrielle, B,18603 | 1205.47 | 0.00 | 0.00 | 0.00 | 1205.47 |
| Lopez, Katelyn,11820 | 232.71 | 0.00 | 0.00 | 0.00 | 232.71 |
| Washington, Riley, L,18544 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Brooks, Paige,22232 | 5985.31 | 0.00 | 3578.27 | 0.00 | 2407.04 |
| Walker, Hunter,27100 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Long, Jordyn,17338 | 47.25 | 0.00 | 0.00 | 0.00 | 47.25 |
| Griffin, Julian, M,11328 | 4718.04 | 0.00 | 0.00 | 2319.99 | 2398.05 |
| Parker, Madeline, H,22182 | 6006.32 | 0.00 | 3578.27 | 0.00 | 2428.05 |
| Green, Gabrielle, M,21815 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Baker, Isaiah,12106 | 169.54 | 0.00 | 0.00 | 0.00 | 169.54 |
| Russell, Elijah, M,11835 | 4772.30 | 0.00 | 0.00 | 2319.26 | 2453.04 |
| Miller, Benjamin, G,26643 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Anderson, Lucas,29266 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Washington, Hailey, S,25885 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Davis, Richard, R,15549 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Miller, Joseph, A,22713 | 4148.19 | 0.00 | 3578.27 | 0.00 | 569.92 |
| Wilson, Andrew, R,18236 | 2414.99 | 0.00 | 0.00 | 0.00 | 2414.99 |
| Watson, Richard,15943 | 365.41 | 0.00 | 0.00 | 0.00 | 365.41 |
| Kelly, Bryan,21349 | 2989.38 | 0.00 | 0.00 | 2989.38 | 0.00 |
| Brooks, Makayla,22252 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Gonzales, Ashley, C,18600 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Jones, Charles,22882 | 101.45 | 0.00 | 0.00 | 0.00 | 101.45 |
| Phillips, Kyle,12158 | 202.20 | 0.00 | 0.00 | 0.00 | 202.20 |
| Lewis, Seth,26782 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Bailey, Morgan, E,21354 | 2646.40 | 0.00 | 0.00 | 2071.42 | 574.98 |
| James, Maria,16243 | 91.97 | 0.00 | 0.00 | 0.00 | 91.97 |
| Allen, Sean, L,12097 | 159.22 | 0.00 | 0.00 | 0.00 | 159.22 |
| Turner, Courtney, A,22975 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Edwards, Eric,24627 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Nelson, Kevin,14765 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| Martinez, Jonathan,13303 | 66.25 | 0.00 | 0.00 | 0.00 | 66.25 |
| Perez, Eduardo, M,22895 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Martin, Lucas, L,22114 | 4183.23 | 0.00 | 3578.27 | 0.00 | 604.96 |
| Turner, Kaylee, M,16213 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Perez, Timothy, L,22730 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Patterson, Maria, G,13330 | 94.95 | 0.00 | 0.00 | 0.00 | 94.95 |
| Moreno, Renee, C,12936 | 265.22 | 0.00 | 0.00 | 0.00 | 265.22 |
| Smith, Austin,13707 | 149.05 | 0.00 | 0.00 | 0.00 | 149.05 |
| Griffin, Marcus,20756 | 34.56 | 0.00 | 0.00 | 0.00 | 34.56 |
| Richardson, Caitlin, T,23057 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| Mitchell, Jonathan, L,22109 | 5971.33 | 0.00 | 3578.27 | 2393.06 | 0.00 |
| Howard, Natalie,13491 | 54.96 | 0.00 | 0.00 | 14.98 | 39.98 |
| Jai, Jose,12944 | 164.21 | 0.00 | 0.00 | 0.00 | 164.21 |
| Washington, Caroline, D,23114 | 5996.32 | 0.00 | 3578.27 | 0.00 | 2418.05 |
| Jones, Nicole,14504 | 112.27 | 0.00 | 0.00 | 0.00 | 112.27 |
| Rodriguez, Richard,12969 | 180.79 | 0.00 | 0.00 | 0.00 | 180.79 |
| James, Zoe, R,14611 | 304.55 | 0.00 | 0.00 | 0.00 | 304.55 |
| James, Juan,23267 | 4862.09 | 0.00 | 3578.27 | 0.00 | 1283.82 |
| Wilson, Fernando,16643 | 126.96 | 0.00 | 0.00 | 0.00 | 126.96 |
| Robinson, Sarah, A,27028 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Walker, Charles,11677 | 298.21 | 0.00 | 0.00 | 0.00 | 298.21 |
| Brooks, Isaac, M,23385 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Williams, Ryan, R,22247 | 5978.61 | 0.00 | 3578.27 | 0.00 | 2400.34 |
Generated 2025-12-23 09:10:58.682 UTC