[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 624 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wagner, Alexandra, E,23244 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Peterson, Christina,28976 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Washington, Victoria,23557 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hall, Kyle, J,17491 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Barnes, Kaitlyn, Z,15162 | 154.96 | 0.00 | 0.00 | 0.00 | 154.96 |
| Cook, Seth,23010 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Chow, Candice,19232 | 60.96 | 0.00 | 0.00 | 0.00 | 60.96 |
| 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 |
| Campbell, Adam, A,21400 | 2688.89 | 0.00 | 0.00 | 2071.42 | 617.47 |
| Gomez, Krista,12760 | 273.18 | 0.00 | 0.00 | 36.27 | 236.91 |
| Washington, Alexis,19781 | 46.26 | 0.00 | 0.00 | 7.28 | 38.98 |
| Wright, Carol, C,12928 | 247.41 | 0.00 | 0.00 | 33.98 | 213.43 |
| She, Shawn, J,16902 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Yuan, Leonard, F,16791 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Hall, Charles,23476 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hall, Lauren, A,19648 | 100.84 | 0.00 | 0.00 | 0.00 | 100.84 |
| Bell, Danielle,14041 | 4765.02 | 0.00 | 0.00 | 0.00 | 4765.02 |
| Price, Riley, R,13909 | 4764.02 | 0.00 | 0.00 | 0.00 | 4764.02 |
| Hall, Noah, A,15251 | 75.25 | 0.00 | 0.00 | 0.00 | 75.25 |
| Washington, Alexandra, E,15498 | 256.52 | 0.00 | 0.00 | 74.46 | 182.06 |
| Diaz, Thomas, O,16020 | 595.96 | 0.00 | 0.00 | 0.00 | 595.96 |
| Bryant, Samantha,18345 | 115.47 | 0.00 | 0.00 | 0.00 | 115.47 |
| Turner, Amanda, L,20318 | 3241.90 | 0.00 | 2071.42 | 0.00 | 1170.48 |
| Lewis, Brandon, A,29037 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Wilson, Daniel, K,14281 | 4746.30 | 0.00 | 0.00 | 0.00 | 4746.30 |
| Shan, Logan,18677 | 60.96 | 0.00 | 0.00 | 29.99 | 30.97 |
| Stewart, Brooke, R,24759 | 4369.59 | 0.00 | 3578.27 | 0.00 | 791.32 |
| Russell, Kaitlyn, M,24491 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Perry, Christian,24671 | 4354.60 | 0.00 | 3578.27 | 0.00 | 776.33 |
| She, Alisha, G,24757 | 4343.59 | 0.00 | 3578.27 | 0.00 | 765.32 |
| Cooper, Stephanie,24976 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Richardson, Victoria, C,24817 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Hughes, Julia,25061 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Martin, Morgan,24832 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Gray, Alexandria, E,25363 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Price, Stephanie,25892 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Murphy, Dalton, N,27043 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Cox, Lucas, J,25393 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Campbell, Isabella, C,20350 | 3226.90 | 0.00 | 2071.42 | 0.00 | 1155.48 |
| Williams, Morgan, C,20373 | 3226.90 | 0.00 | 0.00 | 2071.42 | 1155.48 |
| Sanders, Alexandra,25911 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Russell, Fernando,27084 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Gonzales, Melissa, W,20470 | 4408.69 | 0.00 | 0.00 | 2071.42 | 2337.27 |
| Blanco, Randall,26321 | 1554.41 | 0.00 | 0.00 | 1000.44 | 553.97 |
| Adams, Mackenzie, A,14640 | 812.42 | 0.00 | 0.00 | 0.00 | 812.42 |
| Lopez, Jack, I,29047 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Coleman, Jose, S,25349 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| White, Miguel, S,13988 | 195.52 | 0.00 | 0.00 | 0.00 | 195.52 |
| Flores, Eduardo, S,28969 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Brooks, Ian, W,28290 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Carter, Katherine,11861 | 286.30 | 0.00 | 0.00 | 0.00 | 286.30 |
| Clark, Emily, R,12086 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Young, Kaylee, S,13756 | 298.49 | 0.00 | 0.00 | 58.47 | 240.02 |
| Watson, Marcus,22715 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Taylor, Christian,20764 | 56.76 | 0.00 | 0.00 | 0.00 | 56.76 |
| Morris, Alyssa,28072 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Garcia, Jonathan,18883 | 86.96 | 0.00 | 0.00 | 29.99 | 56.97 |
| Harris, Destiny, M,13710 | 2341.46 | 0.00 | 0.00 | 0.00 | 2341.46 |
| Hill, Blake,11748 | 131.54 | 0.00 | 0.00 | 0.00 | 131.54 |
| Turner, Morgan,11823 | 178.47 | 0.00 | 0.00 | 0.00 | 178.47 |
| Moore, Anthony, M,24730 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Flores, Madison,14416 | 769.49 | 0.00 | 0.00 | 0.00 | 769.49 |
| Shan, Chad, M,24621 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Stewart, Alex, M,20084 | 63.15 | 0.00 | 0.00 | 0.00 | 63.15 |
| Torres, Xavier,16840 | 176.95 | 0.00 | 0.00 | 0.00 | 176.95 |
| Green, Mackenzie, C,28073 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ortega, Javier, P,12785 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Campbell, Hailey,15507 | 267.84 | 0.00 | 0.00 | 228.96 | 38.88 |
| Ward, Ian,12056 | 213.92 | 0.00 | 0.00 | 0.00 | 213.92 |
| Sandberg, Nicole, M,12077 | 144.69 | 0.00 | 0.00 | 94.46 | 50.23 |
| Morgan, Angela,24665 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Martinez, Matthew, L,16009 | 170.45 | 0.00 | 0.00 | 0.00 | 170.45 |
| King, Caleb, J,28986 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Reed, Mariah,26373 | 1565.91 | 0.00 | 0.00 | 1000.44 | 565.47 |
| Price, Jeremy,25989 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Miller, Katherine, B,27102 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Thomas, Isabella, M,27265 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Anderson, Ashley,20680 | 3219.58 | 0.00 | 0.00 | 2049.10 | 1170.48 |
| Thompson, Joshua, F,25999 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Zhao, Karen, L,25408 | 2735.53 | 0.00 | 2181.56 | 0.00 | 553.97 |
| White, Jennifer, S,27027 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Lazecky, Petr,25864 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Hughes, Stephanie,26316 | 1000.44 | 0.00 | 1000.44 | 0.00 | 0.00 |
| Powell, Blake, J,22371 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hayes, Oscar,26527 | 29.26 | 0.00 | 0.00 | 0.00 | 29.26 |
| Hall, Luke, E,14745 | 902.46 | 0.00 | 0.00 | 0.00 | 902.46 |
| Gonzalez, James, M,18842 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Luo, Franklin, J,22027 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Ward, Juan, H,21595 | 2649.56 | 0.00 | 0.00 | 2049.10 | 600.46 |
| Jai, Edwin,16921 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| 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 |
| Harris, Matthew,14330 | 806.76 | 0.00 | 0.00 | 0.00 | 806.76 |
| Thomas, Megan,29071 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Bell, Christina,26099 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Bryant, Nathan,21450 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Rodriguez, Michael, E,16810 | 3064.63 | 0.00 | 0.00 | 0.00 | 3064.63 |
| Kumar, Zachary,25433 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Simmons, Jose,24647 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Griffin, Haley, L,18925 | 82.18 | 0.00 | 0.00 | 0.00 | 82.18 |
| Taylor, Natalie, M,14338 | 828.74 | 0.00 | 0.00 | 0.00 | 828.74 |
| Martin, John, A,14436 | 4776.01 | 0.00 | 0.00 | 0.00 | 4776.01 |
| Turner, Jeremiah, F,19207 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Lal, Caleb, R,15868 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Coleman, Vanessa,21589 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Nelson, Sean,11841 | 307.97 | 0.00 | 0.00 | 0.00 | 307.97 |
| Foster, Kayla,19693 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Gutierrez, Jerome,12783 | 2420.46 | 0.00 | 0.00 | 0.00 | 2420.46 |
| Scott, Gabrielle,27061 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Phillips, Miguel,20498 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| James, Christina,17409 | 219.92 | 0.00 | 0.00 | 0.00 | 219.92 |
| Taylor, Zachary, M,27082 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Kumar, Austin,20483 | 4400.06 | 0.00 | 0.00 | 2049.10 | 2350.96 |
| Wilson, Christian,27085 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Cooper, Timothy, J,20651 | 3198.57 | 0.00 | 0.00 | 2049.10 | 1149.47 |
| Ross, Rachel, C,20669 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Cox, Julia, A,20670 | 3228.57 | 0.00 | 0.00 | 2049.10 | 1179.47 |
| Phillips, Jack, R,25995 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Gonzales, Brianna, L,21148 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Davis, Jasmine, M,26529 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Stewart, Cody, A,21284 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Ward, Nicole, L,21272 | 4435.38 | 0.00 | 0.00 | 2071.42 | 2363.96 |
| Garcia, Hunter, J,21305 | 3204.58 | 0.00 | 0.00 | 2049.10 | 1155.48 |
Generated 2025-11-04 07:35:55.655 UTC