[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 438 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alexander, Lauren,18950 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Ross, Xavier, A,12202 | 171.47 | 0.00 | 0.00 | 49.97 | 121.50 |
| Patterson, Austin, O,27024 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| James, Bryce,13466 | 133.45 | 0.00 | 0.00 | 0.00 | 133.45 |
| Barnes, Alexandra, P,22268 | 6031.31 | 0.00 | 3578.27 | 0.00 | 2453.04 |
| Gonzales, Trevor, K,16085 | 143.53 | 0.00 | 0.00 | 14.98 | 128.55 |
| Griffin, Stephanie, L,28261 | 27.92 | 0.00 | 0.00 | 0.00 | 27.92 |
| Hughes, Riley,29284 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Thomas, Zachary, D,28045 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Lal, Jonathan,20096 | 71.46 | 0.00 | 0.00 | 0.00 | 71.46 |
| Smith, Samuel, D,23083 | 49.90 | 0.00 | 0.00 | 0.00 | 49.90 |
| Kennedy, Bridget,22026 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Campbell, Hailey,15507 | 267.84 | 0.00 | 0.00 | 228.96 | 38.88 |
| Barnes, Fernando,11300 | 1390.55 | 0.00 | 0.00 | 248.38 | 1142.17 |
| Mehta, Rebekah, B,27419 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Thomas, Megan,29071 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Davis, Marcus, T,17337 | 123.91 | 0.00 | 0.00 | 86.95 | 36.96 |
| Li, Eugene, A,15283 | 865.95 | 0.00 | 0.00 | 0.00 | 865.95 |
| Thomas, Samantha,21690 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Lopez, Bailey, R,18557 | 1179.47 | 0.00 | 0.00 | 1179.47 | 0.00 |
| Martin, James, M,19870 | 77.25 | 0.00 | 0.00 | 0.00 | 77.25 |
| Gray, Seth, M,20087 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Morgan, Timothy,14633 | 242.50 | 0.00 | 0.00 | 71.58 | 170.92 |
| Russell, Samuel, V,11652 | 310.93 | 0.00 | 0.00 | 0.00 | 310.93 |
| Martin, Madison, C,20492 | 71.97 | 0.00 | 0.00 | 71.97 | 0.00 |
| Gomez, Krista,12760 | 273.18 | 0.00 | 0.00 | 36.27 | 236.91 |
| Reed, Paige,22112 | 6047.32 | 0.00 | 3578.27 | 2469.05 | 0.00 |
| Turner, Morgan,11823 | 178.47 | 0.00 | 0.00 | 0.00 | 178.47 |
| Griffin, Jason, L,11200 | 1267.11 | 0.00 | 0.00 | 391.08 | 876.03 |
| Diaz, Faith, M,22363 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Collins, Sierra,18549 | 1169.46 | 0.00 | 0.00 | 1169.46 | 0.00 |
| Davis, Justin,28074 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Wedge, Andrew, T,12060 | 4811.54 | 0.00 | 0.00 | 2418.48 | 2393.06 |
| Cooper, Brian, L,13760 | 128.84 | 0.00 | 0.00 | 0.00 | 128.84 |
| Adams, Kaitlyn, A,11869 | 239.60 | 0.00 | 0.00 | 37.27 | 202.33 |
| Martinez, Jonathan,13303 | 66.25 | 0.00 | 0.00 | 0.00 | 66.25 |
| Morris, Chase, F,26789 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Coleman, Dylan,27403 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Martin, Jill, C,11824 | 181.03 | 0.00 | 0.00 | 69.97 | 111.06 |
| She, Shawn, J,16902 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Hughes, Anna,19705 | 2341.97 | 0.00 | 0.00 | 0.00 | 2341.97 |
| James, Sara,19802 | 3374.99 | 3374.99 | 0.00 | 0.00 | 0.00 |
| Bailey, Jessica, L,12945 | 218.44 | 0.00 | 0.00 | 0.00 | 218.44 |
| Wilson, Grace,17539 | 205.92 | 0.00 | 0.00 | 0.00 | 205.92 |
| Hall, Taylor, J,16995 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Rodriguez, Michael, E,16810 | 3064.63 | 0.00 | 0.00 | 0.00 | 3064.63 |
| Bennett, Maria, G,22983 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Taylor, Madison, A,11802 | 215.29 | 0.00 | 0.00 | 127.96 | 87.33 |
| Stewart, Jessica,16097 | 103.55 | 0.00 | 0.00 | 46.58 | 56.97 |
| Williams, Joshua,26051 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rodriguez, Lucas, P,15942 | 191.87 | 0.00 | 0.00 | 0.00 | 191.87 |
| Jenkins, Gabrielle, B,21659 | 4143.74 | 3578.27 | 0.00 | 0.00 | 565.47 |
| Miller, Andrew, C,27110 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Mr., Smith, Jeff,29283 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Young, Jenna, W,16365 | 2490.18 | 0.00 | 0.00 | 0.00 | 2490.18 |
| Long, Xavier,11251 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| Griffin, Madison, A,25093 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Russell, Megan,16220 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Allen, Angel, G,15571 | 101.85 | 0.00 | 0.00 | 34.89 | 66.96 |
| Evans, Jesse,21916 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lewis, Isabella,26242 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Washington, Lauren, R,22998 | 5329.25 | 0.00 | 3578.27 | 1750.98 | 0.00 |
| Barnes, Jeremy,21446 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Morris, Haley, A,23548 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Johnson, Christopher,11979 | 4813.76 | 0.00 | 0.00 | 2352.21 | 2461.55 |
| Moreno, Renee, C,12936 | 265.22 | 0.00 | 0.00 | 0.00 | 265.22 |
| Lee, Kayla, M,20781 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Butler, Morgan, E,20500 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Stewart, Cody, A,21284 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Shan, Logan,18677 | 60.96 | 0.00 | 0.00 | 29.99 | 30.97 |
| Phillips, Luis, G,20734 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hughes, Austin, P,18368 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Miller, Victoria,15816 | 188.02 | 0.00 | 0.00 | 81.46 | 106.56 |
| Watson, Janet, S,23208 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Richardson, Brian,28608 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Ward, Devin, J,15378 | 170.91 | 0.00 | 0.00 | 76.95 | 93.96 |
| Mehta, Carmen, C,27436 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Collins, Eduardo,13987 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Gill, Robyn, J,12765 | 1750.98 | 0.00 | 0.00 | 1750.98 | 0.00 |
| Hughes, Jasmine,27628 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bryant, Connor,23842 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Long, Caleb, P,25046 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Washington, Elijah, L,25016 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kelly, Trinity,26095 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Jones, Samantha,18317 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Hernandez, Eduardo, J,18919 | 300.94 | 0.00 | 0.00 | 300.94 | 0.00 |
| Murphy, Olivia, V,20206 | 3204.58 | 0.00 | 2049.10 | 0.00 | 1155.48 |
| Smith, Tyler, J,20341 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Diaz, Jasmine, A,16098 | 3101.29 | 0.00 | 0.00 | 756.33 | 2344.96 |
| Long, Morgan, H,21352 | 2625.39 | 0.00 | 0.00 | 2071.42 | 553.97 |
| Carter, Savannah, M,12090 | 2350.96 | 0.00 | 0.00 | 0.00 | 2350.96 |
| Brooks, Victoria, H,16479 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
| Garcia, Lucas,27545 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Phillips, Devin,18759 | 112.06 | 0.00 | 0.00 | 0.00 | 112.06 |
| Johnson, Jonathan,22059 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lee, John,19801 | 193.01 | 0.00 | 0.00 | 0.00 | 193.01 |
| Bryant, Samantha,18345 | 115.47 | 0.00 | 0.00 | 0.00 | 115.47 |
| Thomas, Alexandra, C,23172 | 4809.39 | 0.00 | 3578.27 | 1231.12 | 0.00 |
| Butler, Dalton, A,13345 | 4759.51 | 0.00 | 0.00 | 0.00 | 4759.51 |
| Martin, Tyler, L,27724 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Rowe, Todd,14586 | 233.94 | 0.00 | 0.00 | 0.00 | 233.94 |
| Moore, Seth,13851 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Lopez, Isaiah,18968 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Powell, Lauren, E,19662 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Peterson, Jared,11502 | 829.37 | 0.00 | 0.00 | 171.95 | 657.42 |
| Thompson, Lucas, O,21277 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Long, Natalie,14363 | 192.34 | 0.00 | 0.00 | 0.00 | 192.34 |
| Hall, Grace, A,20189 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Smith, Alexandra,28292 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Brown, Anthony, J,19399 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| She, Martha, E,22251 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Hill, Alexandra, K,15172 | 215.45 | 0.00 | 0.00 | 36.27 | 179.18 |
| White, Emma, N,16090 | 604.96 | 0.00 | 0.00 | 0.00 | 604.96 |
| Thompson, Devin,20708 | 4406.40 | 0.00 | 0.00 | 2071.42 | 2334.98 |
| Patterson, Eric, A,27384 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Henderson, Sarah, M,23867 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Ramirez, Jennifer, E,21311 | 4472.58 | 0.00 | 0.00 | 2049.10 | 2423.48 |
| Diaz, Alyssa,13908 | 4715.33 | 0.00 | 0.00 | 0.00 | 4715.33 |
| Turner, Sean,22732 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Perez, Dalton,11091 | 1125.36 | 0.00 | 0.00 | 213.86 | 911.50 |
| Jackson, Andrew,20479 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Hernandez, Jonathan, J,19014 | 65.95 | 0.00 | 0.00 | 0.00 | 65.95 |
| Turner, Mary,22015 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Baker, Sara, M,11827 | 512.47 | 0.00 | 0.00 | 148.47 | 364.00 |
Generated 2025-11-04 04:52:16.296 UTC