[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 250 SHUFFLE < SKIP 62 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Allen, Jack, M,29137 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Bailey, Marcus, L,18329 | 146.53 | 0.00 | 0.00 | 0.00 | 146.53 |
| Martin, Nicholas,23362 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Foster, Olivia,23806 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Ross, Jose,27441 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Cooper, Stephanie,24976 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Price, Riley, R,13909 | 4764.02 | 0.00 | 0.00 | 0.00 | 4764.02 |
| Deng, Damien, A,16873 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Roberts, Jordan, M,16800 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Lewis, Rachel, J,14900 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Garcia, Kaitlyn, J,26310 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Russell, Katherine,28771 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Russell, Rachel, C,21581 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Gonzalez, Morgan,13065 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Wood, Gabrielle, S,28787 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Dominguez, Meghan,14370 | 122.56 | 0.00 | 0.00 | 0.00 | 122.56 |
| Richardson, Olivia,20468 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Sánchez, Angela, C,17655 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Long, Sarah,17372 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Hughes, Eduardo,15564 | 188.52 | 0.00 | 0.00 | 0.00 | 188.52 |
| Hall, Morgan,21726 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Yang, Thomas, A,14108 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Martinez, Jill,24235 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Hughes, Samantha,27215 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Williams, Ryan, R,22247 | 5978.61 | 0.00 | 3578.27 | 0.00 | 2400.34 |
| Powell, Elijah, E,23113 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Peterson, Jessica, M,11868 | 247.01 | 0.00 | 0.00 | 0.00 | 247.01 |
| Parker, Jeremy,28668 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Smith, Justin, P,19827 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Sanchez, Trinity, J,26279 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Rogers, Andrea, L,14328 | 308.66 | 0.00 | 0.00 | 0.00 | 308.66 |
| Harris, Samuel, M,24771 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Hill, Alexandra, K,15172 | 215.45 | 0.00 | 0.00 | 0.00 | 215.45 |
| Hughes, Julia,25061 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Peterson, Isabella,28080 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Bradley, Evan,18506 | 101.94 | 0.00 | 0.00 | 0.00 | 101.94 |
| Price, Miranda,26629 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Zhang, Robert,18855 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Carter, Jonathan,14578 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Henderson, Olivia,18859 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Lewis, Morgan,17410 | 168.74 | 0.00 | 0.00 | 0.00 | 168.74 |
| Gray, Brianna,24960 | 3008.82 | 0.00 | 2443.35 | 0.00 | 565.47 |
| White, Jennifer, S,27027 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Price, Marissa,15826 | 160.74 | 0.00 | 0.00 | 0.00 | 160.74 |
| She, Shawn, J,16902 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Evans, Jesse,21916 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Howard, Alexandra,20736 | 3194.58 | 0.00 | 0.00 | 2049.10 | 1145.48 |
| Anderson, Destiny,12895 | 336.65 | 0.00 | 0.00 | 0.00 | 336.65 |
| Perry, Jonathan, T,27026 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Lewis, Brandon, A,29037 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ward, Kaylee, A,24415 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Richardson, Caitlin, T,23057 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| Moreno, Lance, A,29229 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Perez, Savannah, J,17036 | 176.95 | 0.00 | 0.00 | 0.00 | 176.95 |
| Campbell, Timothy,25845 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Hernandez, Jamie,27283 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Rodriguez, Destiny, J,22739 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Smith, Megan, J,26716 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Gomez, Krista,12760 | 273.18 | 0.00 | 0.00 | 0.00 | 273.18 |
| Alexander, Ashley, J,20007 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Collins, Nathan, F,19704 | 1143.46 | 0.00 | 0.00 | 0.00 | 1143.46 |
| Nelson, James, L,24525 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Peterson, Gabrielle, D,24310 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Sanders, Paige,25287 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Coleman, Destiny, W,12122 | 4814.04 | 0.00 | 0.00 | 0.00 | 4814.04 |
| Richardson, Victoria, C,24817 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Green, Eric,27380 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Brooks, Makayla,22252 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Harris, Destiny, M,13710 | 2341.46 | 0.00 | 0.00 | 0.00 | 2341.46 |
| Thompson, Joshua, F,25999 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Kumar, Zachary,25433 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Walker, John, M,28589 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Williams, Joshua,26051 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Simmons, James,19884 | 4588.45 | 0.00 | 3399.99 | 0.00 | 1188.46 |
| Robinson, Emily,12183 | 228.42 | 0.00 | 0.00 | 0.00 | 228.42 |
| Howard, Morgan, T,22971 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Scott, Adam,15863 | 243.01 | 0.00 | 0.00 | 0.00 | 243.01 |
| Watson, Victoria,16125 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Harrison, Trevor, A,18055 | 143.91 | 0.00 | 0.00 | 0.00 | 143.91 |
| Brooks, Bryce,12061 | 140.17 | 0.00 | 0.00 | 0.00 | 140.17 |
| Murphy, Dalton, N,27043 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Diaz, Ryan, J,16910 | 141.96 | 0.00 | 0.00 | 0.00 | 141.96 |
| Hall, Charles,23476 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rubio, Javier, E,19726 | 64.24 | 0.00 | 0.00 | 0.00 | 64.24 |
| Thomas, Emily,21803 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Blue, Marcus, L,27550 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Allen, Aaron, A,20075 | 3399.99 | 0.00 | 3399.99 | 0.00 | 0.00 |
| Davis, Jonathan,29259 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Russell, Arianna,22728 | 149.93 | 0.00 | 0.00 | 0.00 | 149.93 |
| Scott, Haley,13701 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Martin, Noah, A,17657 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| James, Emma,12781 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Bailey, Mariah, L,27243 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Sanders, Alexandra,25911 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Washington, Robert, J,14906 | 143.95 | 0.00 | 0.00 | 0.00 | 143.95 |
| Cooper, Paige,14119 | 148.94 | 0.00 | 0.00 | 0.00 | 148.94 |
| Smith, Eduardo,20691 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thomas, Samantha,21690 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Zeng, Jake,18054 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Thompson, Lucas, O,21277 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzales, Melissa, W,20470 | 4408.69 | 0.00 | 0.00 | 2071.42 | 2337.27 |
| Bailey, Morgan, E,21354 | 2646.40 | 0.00 | 0.00 | 2071.42 | 574.98 |
| Taylor, Edward, C,17442 | 319.88 | 0.00 | 0.00 | 0.00 | 319.88 |
| Campbell, Evan, W,24342 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Coleman, Lucas, A,27060 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Adams, Miguel,11659 | 213.52 | 0.00 | 0.00 | 0.00 | 213.52 |
| Parker, James,11808 | 610.19 | 0.00 | 0.00 | 0.00 | 610.19 |
| Turner, Timothy, C,14641 | 119.86 | 0.00 | 0.00 | 0.00 | 119.86 |
| Washington, Elijah, L,25016 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Walker, Emma, M,25209 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Roberts, Carlos,23196 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Turner, Blake,12136 | 131.74 | 0.00 | 0.00 | 0.00 | 131.74 |
| Sanders, Hailey,19647 | 282.04 | 0.00 | 0.00 | 0.00 | 282.04 |
| Anderson, Jasmine, A,23553 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Henderson, Caroline,20082 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Ms., Coleman, Abigail, C,23868 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Ramirez, Gabrielle, H,16000 | 4813.95 | 0.00 | 0.00 | 0.00 | 4813.95 |
| Davis, Richard, R,15549 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Edwards, Angel, J,29124 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Patterson, Alexis,21348 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Gonzales, Ashley, C,18600 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Foster, Jessica,26069 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Morgan, Isaiah,18978 | 118.73 | 0.00 | 0.00 | 0.00 | 118.73 |
| Davis, Austin, E,13366 | 4749.04 | 0.00 | 0.00 | 0.00 | 4749.04 |
Generated 2026-01-04 05:48:19.933 UTC