[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 22 < SKIP 1375 > < TAKE 125 >
110 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Thompson, Lucas, O,21277 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gomez, Renee, L,25371 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Mitchell, Alexandra,14455 | 218.93 | 0.00 | 0.00 | 0.00 | 218.93 |
| Collins, Isaac,26077 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Butler, Cassidy, L,21792 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Turner, Samuel,27420 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Green, Gabrielle, M,21815 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Hughes, Samantha,27215 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Cooper, Brianna,25925 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Thomas, Edward, E,19147 | 133.71 | 0.00 | 0.00 | 0.00 | 133.71 |
| Alexander, Taylor,17482 | 146.94 | 0.00 | 0.00 | 0.00 | 146.94 |
| Morris, Abigail, C,28776 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Gonzales, Emily, P,21777 | 180.98 | 0.00 | 0.00 | 0.00 | 180.98 |
| Baker, Sara, M,11827 | 512.47 | 0.00 | 0.00 | 0.00 | 512.47 |
| Zhang, Heather,16654 | 3056.32 | 0.00 | 0.00 | 0.00 | 3056.32 |
| Flores, Megan, N,23074 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| Long, Gavin,13762 | 186.03 | 0.00 | 0.00 | 0.00 | 186.03 |
| She, Alisha, G,24757 | 4343.59 | 0.00 | 3578.27 | 0.00 | 765.32 |
| Alexander, Caroline,17654 | 1759.97 | 0.00 | 0.00 | 0.00 | 1759.97 |
| Coleman, Samuel, N,17450 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Torres, Mackenzie,28153 | 570.47 | 0.00 | 0.00 | 0.00 | 570.47 |
| Stewart, Andrea, M,27252 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Robinson, Julia,28121 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Washington, Alexandra, E,15498 | 256.52 | 0.00 | 0.00 | 0.00 | 256.52 |
| Coleman, Dylan,27403 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Patterson, Hailey, I,11223 | 1155.90 | 0.00 | 0.00 | 0.00 | 1155.90 |
| Hernandez, Eduardo, J,18919 | 300.94 | 0.00 | 0.00 | 0.00 | 300.94 |
| Green, Xavier,23567 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Malhotra, Brenda,13391 | 2405.47 | 0.00 | 0.00 | 0.00 | 2405.47 |
| Cox, Julia, A,20670 | 3228.57 | 0.00 | 0.00 | 2049.10 | 1179.47 |
| Jai, Logan, H,12031 | 769.49 | 0.00 | 0.00 | 0.00 | 769.49 |
| Smith, Katherine, J,13197 | 105.19 | 0.00 | 0.00 | 0.00 | 105.19 |
| Wright, Jackson,11698 | 225.95 | 0.00 | 0.00 | 0.00 | 225.95 |
| Zukowski, Jake,22058 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Torres, Taylor,16666 | 205.44 | 0.00 | 0.00 | 0.00 | 205.44 |
| Griffin, Seth, R,17585 | 164.46 | 0.00 | 0.00 | 0.00 | 164.46 |
| Taylor, Natalie, M,14338 | 828.74 | 0.00 | 0.00 | 0.00 | 828.74 |
| Hughes, Austin, P,18368 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Rivera, Makayla, A,28783 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Martin, Katherine, J,20273 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Long, Chloe,16784 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Jackson, Victoria,27019 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Simmons, Brittany,29231 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alexander, Elijah,11738 | 331.68 | 0.00 | 0.00 | 0.00 | 331.68 |
| Gonzalez, Molly,16370 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Campbell, Hunter,17422 | 174.92 | 0.00 | 0.00 | 0.00 | 174.92 |
| Coleman, Benjamin, F,23486 | 5343.23 | 0.00 | 3578.27 | 0.00 | 1764.96 |
| Powell, Katherine, C,14574 | 177.60 | 0.00 | 0.00 | 0.00 | 177.60 |
| Murphy, Juan, T,24646 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Powell, Jack, J,18411 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Bell, Danielle,14041 | 4765.02 | 0.00 | 0.00 | 0.00 | 4765.02 |
| Washington, Emma,19123 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Perry, Oscar,22785 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Miller, Alexis, A,12196 | 124.93 | 0.00 | 0.00 | 0.00 | 124.93 |
| Ward, Nicole, L,21272 | 4435.38 | 0.00 | 0.00 | 2071.42 | 2363.96 |
| Jones, Nicole,14504 | 112.27 | 0.00 | 0.00 | 0.00 | 112.27 |
| Butler, Victoria,13284 | 4767.53 | 0.00 | 0.00 | 0.00 | 4767.53 |
| Stewart, Allison, R,18826 | 166.43 | 0.00 | 0.00 | 0.00 | 166.43 |
| Hughes, Zachary,12203 | 157.91 | 0.00 | 0.00 | 0.00 | 157.91 |
| Jones, Michael, A,22107 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Hughes, Jasmine,27628 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Diaz, Elijah,20000 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Garcia, Jonathan,18883 | 86.96 | 0.00 | 0.00 | 0.00 | 86.96 |
| Perez, Jonathan, R,23455 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Yang, Aaron, C,25196 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Brooks, Evan,23401 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nelson, Jose,19217 | 185.02 | 0.00 | 0.00 | 0.00 | 185.02 |
| Garcia, Benjamin, L,17595 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 |
| Edwards, Madeline,20771 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Gonzales, Brittany,21710 | 4187.23 | 3578.27 | 0.00 | 0.00 | 608.96 |
| Turner, Adam, K,16109 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Wu, Randy, J,11647 | 2365.94 | 0.00 | 0.00 | 0.00 | 2365.94 |
| James, Zoe, R,14611 | 304.55 | 0.00 | 0.00 | 0.00 | 304.55 |
| Richardson, Olivia,20468 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Price, Rachel, D,25328 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Simmons, Jennifer,11262 | 1010.56 | 0.00 | 0.00 | 0.00 | 1010.56 |
| Carter, Elijah,21618 | 2611.07 | 0.00 | 0.00 | 2049.10 | 561.97 |
| Parker, Blake,15008 | 170.53 | 0.00 | 0.00 | 0.00 | 170.53 |
| Johnson, James,23498 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzalez, Chelsea, E,18103 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Watson, Kimberly, A,20188 | 3226.90 | 0.00 | 2071.42 | 0.00 | 1155.48 |
| Torres, Victoria,17551 | 160.92 | 0.00 | 0.00 | 0.00 | 160.92 |
| Stewart, Gabriella,28034 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lal, Caleb, R,15868 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Reed, Kaitlyn, H,27413 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Stewart, Cody, A,21284 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Hill, Jordan, J,16005 | 198.73 | 0.00 | 0.00 | 0.00 | 198.73 |
| Flores, Arianna,21727 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Morgan, Isabella, L,28602 | 144.47 | 0.00 | 0.00 | 0.00 | 144.47 |
| Mitchell, Evan, R,24731 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cook, Bryce,28640 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Russell, Isabella, A,11507 | 645.78 | 0.00 | 0.00 | 0.00 | 645.78 |
| White, Jennifer, S,27027 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Lee, Samantha, B,27378 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Phillips, Devin,18759 | 112.06 | 0.00 | 0.00 | 0.00 | 112.06 |
| Sanchez, Katherine, S,24399 | 132.94 | 0.00 | 0.00 | 0.00 | 132.94 |
| Hayes, Gavin, A,19400 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Thompson, Devin,20708 | 4406.40 | 0.00 | 0.00 | 2071.42 | 2334.98 |
| Green, Blake, P,11719 | 287.20 | 0.00 | 0.00 | 0.00 | 287.20 |
| Wilson, Eduardo,15323 | 804.47 | 0.00 | 0.00 | 0.00 | 804.47 |
| Thompson, Isabella,18756 | 128.41 | 0.00 | 0.00 | 0.00 | 128.41 |
| Reed, Marcus,14582 | 111.79 | 0.00 | 0.00 | 0.00 | 111.79 |
| Van, Bobby,27757 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Simmons, Adam,25327 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Murphy, Richard, M,22299 | 4145.54 | 0.00 | 3578.27 | 0.00 | 567.27 |
| Moore, Ian, L,24639 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Simmons, Elizabeth, A,21461 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Perry, Marcus, L,20656 | 3245.90 | 0.00 | 0.00 | 2071.42 | 1174.48 |
| Long, Morgan, H,21352 | 2625.39 | 0.00 | 0.00 | 2071.42 | 553.97 |
| Parker, Katherine,13268 | 289.70 | 0.00 | 0.00 | 0.00 | 289.70 |
Generated 2026-01-04 05:47:47.058 UTC