[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 126 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Moore, Seth,13851 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Adams, Mason, T,20528 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Cooper, Paige,14119 | 148.94 | 0.00 | 0.00 | 0.00 | 148.94 |
| Patterson, Jeremy,13027 | 2319.26 | 0.00 | 0.00 | 0.00 | 2319.26 |
| Bryant, Jackson, J,25332 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Turner, Courtney, A,22975 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Yang, Jordan, K,14458 | 133.95 | 0.00 | 0.00 | 0.00 | 133.95 |
| Alexander, Ryan, J,14078 | 839.48 | 0.00 | 0.00 | 839.48 | 0.00 |
| Wilson, Eduardo,15323 | 804.47 | 0.00 | 0.00 | 0.00 | 804.47 |
| Price, Mariah, C,20745 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Thomas, Dalton,23009 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Dominguez, Meghan,14370 | 122.56 | 0.00 | 0.00 | 0.00 | 122.56 |
| Bryant, Samantha,18345 | 115.47 | 0.00 | 0.00 | 0.00 | 115.47 |
| Turner, Morgan,11823 | 178.47 | 0.00 | 0.00 | 0.00 | 178.47 |
| Flores, Caleb, S,12165 | 280.64 | 0.00 | 0.00 | 243.37 | 37.27 |
| Srini, Ruben,18078 | 200.94 | 0.00 | 0.00 | 0.00 | 200.94 |
| Patterson, Grace, M,27560 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Martin, Jeremiah, E,17345 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Hill, Jordan, J,16005 | 198.73 | 0.00 | 0.00 | 102.27 | 96.46 |
| Ward, Destiny,16128 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gill, Robyn, J,12765 | 1750.98 | 0.00 | 0.00 | 1750.98 | 0.00 |
| Anderson, Jasmine, A,23553 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Mitchell, Caleb, K,26806 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Henderson, Stephanie, L,19224 | 352.52 | 0.00 | 0.00 | 0.00 | 352.52 |
| Chandra, Brandy, P,11501 | 603.53 | 0.00 | 0.00 | 0.00 | 603.53 |
| Smith, Megan, J,26716 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Coleman, Lucas, A,27060 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Moore, Wyatt, F,18971 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Flores, Brittany,16906 | 2359.98 | 0.00 | 0.00 | 0.00 | 2359.98 |
| She, Shawn, J,16902 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| King, Sara,22354 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Young, Jenna, W,16365 | 2490.18 | 0.00 | 0.00 | 0.00 | 2490.18 |
| Coleman, Miguel, D,27400 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Peterson, Julia, P,16497 | 132.71 | 0.00 | 0.00 | 0.00 | 132.71 |
| Ross, Elizabeth, E,14118 | 4741.34 | 0.00 | 0.00 | 0.00 | 4741.34 |
| Phillips, Isaiah,28631 | 144.47 | 0.00 | 0.00 | 144.47 | 0.00 |
| Russell, Chloe, M,12763 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Davis, Marcus, T,17337 | 123.91 | 0.00 | 0.00 | 86.95 | 36.96 |
| Allen, Madeline,29240 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Russell, Ian, T,24746 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Hernandez, Jonathan, J,19014 | 65.95 | 0.00 | 0.00 | 0.00 | 65.95 |
| Carter, Madeline, A,27522 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Turner, Amanda, L,20318 | 3241.90 | 0.00 | 2071.42 | 0.00 | 1170.48 |
| Ross, Alexia, S,13231 | 247.90 | 0.00 | 0.00 | 0.00 | 247.90 |
| Wood, Brittany,28777 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Harris, Emily, P,19862 | 98.48 | 0.00 | 0.00 | 0.00 | 98.48 |
| Phillips, Aaron, R,24947 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Perez, Angel, S,21336 | 2628.35 | 0.00 | 0.00 | 2071.42 | 556.93 |
| Parker, James,11808 | 610.19 | 0.00 | 0.00 | 0.00 | 610.19 |
| Ward, Jade, D,14661 | 195.02 | 0.00 | 0.00 | 0.00 | 195.02 |
| Watson, Shelby, J,14911 | 867.97 | 0.00 | 0.00 | 0.00 | 867.97 |
| Adams, Jennifer,15362 | 4745.02 | 0.00 | 0.00 | 0.00 | 4745.02 |
| Gonzales, Melanie, C,18089 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Flores, Kevin,15878 | 225.92 | 0.00 | 0.00 | 69.97 | 155.95 |
| Sanchez, Lucas, L,23351 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Campbell, Timothy,25845 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Bell, Gabrielle,22373 | 5976.32 | 0.00 | 3578.27 | 0.00 | 2398.05 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 66.26 | 773.89 |
| Smith, Nathan,21764 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Hughes, Edward,20023 | 4530.47 | 0.00 | 3374.99 | 0.00 | 1155.48 |
| White, Judith, R,14885 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Collins, Lucas, T,21921 | 4142.75 | 3578.27 | 0.00 | 0.00 | 564.48 |
| Bradley, Jocelyn,23022 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Diaz, Trevor, B,20519 | 54.96 | 0.00 | 0.00 | 0.00 | 54.96 |
| Hill, Blake,11748 | 131.54 | 0.00 | 0.00 | 0.00 | 131.54 |
| Patterson, Austin, O,27024 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Garcia, Christian, J,16491 | 3106.33 | 0.00 | 0.00 | 751.34 | 2354.99 |
| Green, Sophia, E,24977 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Jones, Alexander, I,20021 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Garcia, Alexandra, J,14107 | 819.46 | 0.00 | 0.00 | 819.46 | 0.00 |
| Young, Courtney,17622 | 2374.98 | 0.00 | 0.00 | 0.00 | 2374.98 |
| Mitchell, Kaylee, R,14566 | 401.49 | 0.00 | 0.00 | 0.00 | 401.49 |
| Martin, John, A,14436 | 4776.01 | 0.00 | 0.00 | 0.00 | 4776.01 |
| Chen, Ethan,20547 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Lee, Ian,19646 | 197.04 | 0.00 | 0.00 | 0.00 | 197.04 |
| Thomas, Matthew, K,13239 | 185.70 | 0.00 | 0.00 | 0.00 | 185.70 |
| Edwards, Madeline,20771 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Washington, Adam, G,25437 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Diaz, Faith, M,22363 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Wagner, Alexandra, E,23244 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Russell, Rachel, C,21581 | 24.27 | 0.00 | 0.00 | 24.27 | 0.00 |
| Cook, Bryce,28640 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Moore, Hunter,14897 | 196.27 | 0.00 | 0.00 | 71.58 | 124.69 |
| Garcia, Hunter, J,21305 | 3204.58 | 0.00 | 0.00 | 2049.10 | 1155.48 |
| Ward, Nicole, L,21272 | 4435.38 | 0.00 | 0.00 | 2071.42 | 2363.96 |
| Campbell, Chloe,11212 | 760.93 | 0.00 | 0.00 | 231.72 | 529.21 |
| Williams, Morgan, C,20373 | 3226.90 | 0.00 | 0.00 | 2071.42 | 1155.48 |
| Prasad, Donald,15413 | 318.92 | 0.00 | 0.00 | 123.98 | 194.94 |
| Brown, Isabella, L,26692 | 1266.86 | 0.00 | 699.10 | 0.00 | 567.76 |
| Turner, James, E,16841 | 126.96 | 0.00 | 0.00 | 69.99 | 56.97 |
| Bell, Alexandria, A,13758 | 284.13 | 0.00 | 0.00 | 42.28 | 241.85 |
| Gonzalez, Madeline, B,18922 | 2326.96 | 0.00 | 0.00 | 0.00 | 2326.96 |
| Sanders, Sean,14341 | 175.15 | 0.00 | 0.00 | 0.00 | 175.15 |
| Russell, Fernando,27084 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Murphy, Maria,16011 | 3657.26 | 0.00 | 0.00 | 0.00 | 3657.26 |
| Stewart, Sara,17347 | 119.72 | 0.00 | 0.00 | 0.00 | 119.72 |
| Taylor, Brianna,17027 | 230.90 | 0.00 | 0.00 | 51.96 | 178.94 |
| Garcia, Isabella,18382 | 204.94 | 0.00 | 0.00 | 0.00 | 204.94 |
| Perry, Melissa,22128 | 4142.23 | 0.00 | 3578.27 | 0.00 | 563.96 |
| Coleman, Ashley,27297 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Reed, Catherine, M,20380 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Diaz, Katherine, P,11526 | 2376.96 | 0.00 | 0.00 | 2376.96 | 0.00 |
| Murphy, Brianna, K,28342 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Moore, Fernando,26582 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Green, Isabella,26620 | 699.10 | 699.10 | 0.00 | 0.00 | 0.00 |
| Wu, Randy, J,11647 | 2365.94 | 0.00 | 0.00 | 2365.94 | 0.00 |
| Sanders, Xavier,16721 | 73.75 | 0.00 | 0.00 | 0.00 | 73.75 |
| Johnson, James,23498 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jackson, Brianna,15377 | 97.91 | 0.00 | 0.00 | 74.98 | 22.93 |
| Hu, Gilbert, L,28767 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Simmons, Dakota, T,14110 | 819.46 | 0.00 | 0.00 | 0.00 | 819.46 |
| Hall, Eduardo,16847 | 189.94 | 0.00 | 0.00 | 0.00 | 189.94 |
| Stewart, Andrea, M,27252 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Stewart, Katherine, Z,22901 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Cooper, Ariana,17348 | 205.42 | 0.00 | 0.00 | 0.00 | 205.42 |
| Price, Jeremy,25989 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Powell, Spencer,14904 | 468.12 | 0.00 | 0.00 | 0.00 | 468.12 |
| Sanz, Lori, L,23865 | 4891.61 | 0.00 | 3578.27 | 0.00 | 1313.34 |
| Simmons, Anna, K,12451 | 2367.92 | 0.00 | 0.00 | 0.00 | 2367.92 |
| Lee, Alexander, S,18356 | 149.91 | 0.00 | 0.00 | 0.00 | 149.91 |
| Ward, Juan, H,21595 | 2649.56 | 0.00 | 0.00 | 2049.10 | 600.46 |
| White, Abigail, T,15866 | 145.82 | 0.00 | 0.00 | 38.88 | 106.94 |
| Perry, Ryan,13249 | 4795.34 | 0.00 | 0.00 | 0.00 | 4795.34 |
| Long, Sydney,27921 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Generated 2025-11-06 07:11:52.262 UTC