[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 593 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Cook, Jacqueline, A,19223 | 60.37 | 0.00 | 0.00 | 0.00 | 60.37 |
| Wilson, Christian,27085 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Mehta, Rebekah, B,27419 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Miller, Katherine, B,27102 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Patterson, Abigail, H,14478 | 4795.01 | 0.00 | 0.00 | 0.00 | 4795.01 |
| Townsend, Jeremiah, I,26503 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Sanders, Angel,16219 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Ross, Rachel, C,20669 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Ware, Dennis, L,23725 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Thompson, Joshua, F,25999 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Henderson, Hailey, C,17148 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| White, Christopher, R,26049 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Russell, Xavier,12964 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Thompson, Devin,20708 | 4406.40 | 0.00 | 0.00 | 2071.42 | 2334.98 |
| Hall, Taylor, J,16995 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Phillips, Kaylee,21138 | 4371.38 | 0.00 | 0.00 | 2049.10 | 2322.28 |
| Harris, Jeremiah, B,17023 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Ward, Nicole, L,21272 | 4435.38 | 0.00 | 0.00 | 2071.42 | 2363.96 |
| Cooper, Brian, L,13760 | 128.84 | 0.00 | 0.00 | 0.00 | 128.84 |
| Rivera, Makayla, A,28783 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Wang, Karen, P,19553 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| He, Micah,27401 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Turner, Kaylee, M,16213 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Hayes, Brittany,13941 | 286.82 | 0.00 | 0.00 | 0.00 | 286.82 |
| Smith, Austin,13707 | 149.05 | 0.00 | 0.00 | 0.00 | 149.05 |
| Sanchez, Faith,27049 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Flores, Kevin,15878 | 225.92 | 0.00 | 0.00 | 0.00 | 225.92 |
| Gutierrez, Jerome,12783 | 2420.46 | 0.00 | 0.00 | 0.00 | 2420.46 |
| Peterson, Alex, M,13423 | 132.90 | 0.00 | 0.00 | 0.00 | 132.90 |
| Phillips, Miguel,20498 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Long, Xavier,11251 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| King, Caleb, J,28986 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Townsend, Bryan,14077 | 180.73 | 0.00 | 0.00 | 0.00 | 180.73 |
| Hall, Lauren, A,19648 | 100.84 | 0.00 | 0.00 | 0.00 | 100.84 |
| Hughes, Samantha,27215 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Cox, Devin, C,13418 | 4768.05 | 0.00 | 0.00 | 0.00 | 4768.05 |
| Hall, Elizabeth, L,13474 | 339.48 | 0.00 | 0.00 | 0.00 | 339.48 |
| Lewis, Ryan, A,20312 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Blue, Paige,21703 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Chavez, Kara, P,13285 | 214.35 | 0.00 | 0.00 | 0.00 | 214.35 |
| Phillips, Kyle,12158 | 202.20 | 0.00 | 0.00 | 0.00 | 202.20 |
| Hughes, Miranda,26678 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Evans, Alexandra,24322 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Jackson, Hannah, G,13143 | 2404.97 | 0.00 | 0.00 | 0.00 | 2404.97 |
| Perez, Timothy, L,22730 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lewis, Brandon, A,29037 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Patterson, Taylor,12147 | 271.45 | 0.00 | 0.00 | 0.00 | 271.45 |
| Perez, Kaitlyn, A,12081 | 2366.96 | 0.00 | 0.00 | 0.00 | 2366.96 |
| Price, Riley, R,13909 | 4764.02 | 0.00 | 0.00 | 0.00 | 4764.02 |
| Carter, Savannah, M,12090 | 2350.96 | 0.00 | 0.00 | 0.00 | 2350.96 |
| Howard, Isaiah,25981 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Liu, Arturo,13222 | 150.41 | 0.00 | 0.00 | 0.00 | 150.41 |
| Evans, Kaylee,19642 | 133.54 | 0.00 | 0.00 | 0.00 | 133.54 |
| Ross, Natalie, J,12916 | 261.22 | 0.00 | 0.00 | 0.00 | 261.22 |
| Bailey, Richard, N,22050 | 4160.53 | 0.00 | 3578.27 | 0.00 | 582.26 |
| Walker, Brandon, J,15916 | 4793.27 | 0.00 | 0.00 | 0.00 | 4793.27 |
| Thompson, Kayla, D,12363 | 273.90 | 0.00 | 0.00 | 0.00 | 273.90 |
| Bryant, Gabriel,27656 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| James, Jeremiah, S,11661 | 287.70 | 0.00 | 0.00 | 0.00 | 287.70 |
| Bryant, Brittany,22545 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Stewart, Lucas, J,29341 | 98.97 | 0.00 | 0.00 | 0.00 | 98.97 |
| Hughes, Jasmine,27628 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Roberts, Rebecca,28000 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| White, Edward, J,15847 | 205.46 | 0.00 | 0.00 | 0.00 | 205.46 |
| Thomas, Zachary, D,28045 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Miller, Sydney, A,13440 | 4818.53 | 0.00 | 0.00 | 0.00 | 4818.53 |
| Stewart, Melissa,25173 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Brooks, Ian, W,28290 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Raje, Mindy, A,16083 | 561.97 | 0.00 | 0.00 | 0.00 | 561.97 |
| Price, Mariah, C,20745 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Henderson, Olivia,18859 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Hall, Fernando,22100 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Brown, Benjamin, D,15187 | 4725.32 | 0.00 | 0.00 | 0.00 | 4725.32 |
| Martinez, Kristina, S,21345 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Simmons, Anna, K,12451 | 2367.92 | 0.00 | 0.00 | 0.00 | 2367.92 |
| Carter, Katherine,11861 | 286.30 | 0.00 | 0.00 | 0.00 | 286.30 |
| Foster, Jose, C,28785 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Harris, Matthew,14330 | 806.76 | 0.00 | 0.00 | 0.00 | 806.76 |
| Torres, Erin,12182 | 87.25 | 0.00 | 0.00 | 0.00 | 87.25 |
| Clark, Emily, R,12086 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Powell, Angela, R,12970 | 471.11 | 0.00 | 0.00 | 0.00 | 471.11 |
| Moreno, Marie,27739 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Taylor, Madison, A,11802 | 215.29 | 0.00 | 0.00 | 0.00 | 215.29 |
| Thomas, Megan,29071 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Taylor, Jeremiah, M,29012 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Watson, Michelle, H,26235 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Ms., Coleman, Abigail, C,23868 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Powell, Caleb, G,21613 | 2610.58 | 0.00 | 0.00 | 2049.10 | 561.48 |
| Ward, Devin, J,15378 | 170.91 | 0.00 | 0.00 | 0.00 | 170.91 |
| Ward, Stephanie, A,27429 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Long, Brandon, M,16110 | 650.47 | 0.00 | 0.00 | 0.00 | 650.47 |
| Bell, Julia,21652 | 2646.06 | 0.00 | 0.00 | 2049.10 | 596.96 |
| Robinson, Abigail, R,18379 | 2362.27 | 0.00 | 0.00 | 0.00 | 2362.27 |
| Powell, David, W,26615 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Thomas, Emily,21803 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wilson, Victoria, R,27536 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Watson, Kimberly, A,20188 | 3226.90 | 0.00 | 2071.42 | 0.00 | 1155.48 |
| Washington, Riley, L,18544 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Navarro, Jerome, B,11519 | 717.28 | 0.00 | 0.00 | 0.00 | 717.28 |
| Davis, Richard, R,15549 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Sanders, Allison, B,18852 | 268.25 | 0.00 | 0.00 | 0.00 | 268.25 |
| Hall, Kaylee, E,19751 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Bailey, Jessica, L,12945 | 218.44 | 0.00 | 0.00 | 0.00 | 218.44 |
| Turner, Jeremiah, F,19207 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Flores, Miguel,19750 | 77.25 | 0.00 | 0.00 | 0.00 | 77.25 |
| Rubio, Kellie,27653 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Roberts, Amanda,17175 | 2334.98 | 0.00 | 0.00 | 0.00 | 2334.98 |
| Price, Lauren, J,14079 | 184.74 | 0.00 | 0.00 | 0.00 | 184.74 |
| Gonzales, Brittany,21710 | 4187.23 | 3578.27 | 0.00 | 0.00 | 608.96 |
| Murphy, Chase, J,24729 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Flores, Arianna,21727 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Davis, Ethan,13660 | 4750.01 | 0.00 | 0.00 | 0.00 | 4750.01 |
| Morris, Paige, W,22041 | 4167.23 | 0.00 | 3578.27 | 0.00 | 588.96 |
| Nelson, Sierra,16132 | 2459.62 | 0.00 | 0.00 | 2459.62 | 0.00 |
| Brown, Dalton, N,21813 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Alexander, Ryan, J,14078 | 839.48 | 0.00 | 0.00 | 839.48 | 0.00 |
| Price, Miranda,26629 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Allen, Jack, M,29137 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Reed, Paige,22112 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Diaz, Hailey, W,11693 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Parker, Jennifer, D,22118 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Suri, Carolyn, S,12972 | 175.71 | 0.00 | 0.00 | 0.00 | 175.71 |
| Gonzalez, Katherine,22234 | 5976.32 | 0.00 | 3578.27 | 0.00 | 2398.05 |
| Hayes, Jeremiah, W,20086 | 128.55 | 0.00 | 0.00 | 0.00 | 128.55 |
Generated 2026-01-04 05:09:14.227 UTC