[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1306 > < TAKE 248 >
201 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hill, Kaitlyn, M,24659 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Allen, Mason,17625 | 2431.95 | 0.00 | 0.00 | 0.00 | 2431.95 |
| Rivera, Hailey, R,20792 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Flores, Brandon, L,25621 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Hayes, Jason,26176 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Torres, Abigail,25367 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Davis, Jonathan,29259 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Perez, Barry, M,27282 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Gray, Marcus, T,18389 | 2401.45 | 0.00 | 0.00 | 0.00 | 2401.45 |
| Henderson, Austin,27643 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Rogers, Olivia,12020 | 804.47 | 0.00 | 0.00 | 0.00 | 804.47 |
| Lewis, Rachel, J,14900 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Wright, Kaitlyn, G,13434 | 2354.99 | 0.00 | 0.00 | 0.00 | 2354.99 |
| Lee, Samantha, B,27378 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Campbell, Isabella, C,20350 | 3226.90 | 0.00 | 0.00 | 2071.42 | 1155.48 |
| Moore, Matthew, W,13267 | 109.95 | 0.00 | 0.00 | 0.00 | 109.95 |
| Howard, Isaiah,25981 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Suarez, Juan, R,16763 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Coleman, Lucas, A,27060 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Harris, Edward,27062 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Russell, Fernando,27084 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Hayes, Arianna,25991 | 2845.52 | 0.00 | 0.00 | 2181.56 | 663.96 |
| Reed, Judith, D,25347 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Rogers, Shelby,11712 | 127.80 | 0.00 | 0.00 | 32.60 | 95.20 |
| Perez, Angel, S,21336 | 2628.35 | 0.00 | 0.00 | 2071.42 | 556.93 |
| Isla, Julian, A,13732 | 108.96 | 0.00 | 0.00 | 4.99 | 103.97 |
| Ramos, Kristi,15176 | 4703.03 | 0.00 | 0.00 | 0.00 | 4703.03 |
| Sharma, Samuel,27725 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Long, Brandon, M,16110 | 650.47 | 0.00 | 0.00 | 0.00 | 650.47 |
| Taylor, Zachary, M,27082 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Williams, Zachary, B,27099 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Thomas, Isabella, M,27265 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Carter, Bailey,21332 | 2616.86 | 0.00 | 0.00 | 2049.10 | 567.76 |
| Mitchell, Xavier, L,26533 | 1629.41 | 0.00 | 0.00 | 1000.44 | 628.97 |
| Campbell, Adam, A,21400 | 2688.89 | 0.00 | 0.00 | 2071.42 | 617.47 |
| Jones, Zachary, J,27285 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Coleman, Jennifer, L,27298 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Coleman, Ashley,27297 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Kelly, Bryan,21349 | 2989.38 | 0.00 | 0.00 | 2989.38 | 0.00 |
| Henderson, Caroline,20082 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Lee, William,13185 | 149.84 | 0.00 | 0.00 | 0.00 | 149.84 |
| Gomez, Rebekah,13486 | 225.44 | 0.00 | 0.00 | 0.00 | 225.44 |
| Moore, Andrew, A,13944 | 150.13 | 0.00 | 0.00 | 0.00 | 150.13 |
| Brown, Benjamin, D,15187 | 4725.32 | 0.00 | 0.00 | 0.00 | 4725.32 |
| Powell, Caleb, G,21613 | 2610.58 | 0.00 | 0.00 | 2049.10 | 561.48 |
| Ward, Stephanie, A,27429 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Garcia, Kaitlyn, J,26310 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Powell, David, W,26615 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Moore, Fernando,26582 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Blue, Marcus, L,27550 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Bryant, Zachary,21655 | 2648.07 | 0.00 | 0.00 | 2049.10 | 598.97 |
| King, Jordan, C,11020 | 2316.97 | 0.00 | 0.00 | 2316.97 | 0.00 |
| Lopez, Isaiah,18968 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Jones, Joshua,18401 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Murphy, Caitlin, L,14910 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Anderson, Destiny,12895 | 336.65 | 0.00 | 0.00 | 0.00 | 336.65 |
| Alexander, Luke,29043 | 2447.05 | 0.00 | 0.00 | 2447.05 | 0.00 |
| Alexander, Ryan, J,14078 | 839.48 | 0.00 | 0.00 | 839.48 | 0.00 |
| Allen, Jack, M,29137 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Sandberg, Nicole, M,12077 | 144.69 | 0.00 | 0.00 | 89.47 | 55.22 |
| Washington, Alexis,19781 | 46.26 | 0.00 | 0.00 | 7.28 | 38.98 |
| Wedge, Andrew, T,12060 | 4811.54 | 0.00 | 0.00 | 2418.48 | 2393.06 |
| Walker, Jasmine,13460 | 4693.04 | 0.00 | 0.00 | 0.00 | 4693.04 |
| Long, Chloe,16784 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Hughes, Brittany,14387 | 898.46 | 0.00 | 0.00 | 0.00 | 898.46 |
| Sanchez, Faith,27049 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Deng, Damien, A,16873 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Bradley, Melanie, G,13343 | 4720.27 | 0.00 | 0.00 | 0.00 | 4720.27 |
| Torres, Mariah,16380 | 195.95 | 0.00 | 0.00 | 0.00 | 195.95 |
| Taylor, Brianna,17027 | 230.90 | 0.00 | 0.00 | 51.96 | 178.94 |
| Foster, Antonio,12795 | 108.54 | 0.00 | 0.00 | 28.99 | 79.55 |
| Diaz, Katherine, P,11526 | 2376.96 | 0.00 | 0.00 | 2376.96 | 0.00 |
| Rodriguez, Nicholas, D,14604 | 137.95 | 0.00 | 0.00 | 23.97 | 113.98 |
| Wright, Jennifer,26505 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Evans, Maria,22544 | 127.28 | 0.00 | 0.00 | 127.28 | 0.00 |
| Washington, Hannah, A,29130 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Collins, Nathan, F,19704 | 1143.46 | 0.00 | 0.00 | 0.00 | 1143.46 |
| Powell, Blake, J,22371 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Smith, Tyler, J,20341 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Hall, Luke, E,14745 | 902.46 | 0.00 | 0.00 | 0.00 | 902.46 |
| Hernandez, Jamie,27283 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Ramirez, Brian, M,11618 | 2369.96 | 0.00 | 0.00 | 0.00 | 2369.96 |
| Zhao, Clarence, R,19826 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Lopez, Bailey, R,18557 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Xu, Louis,20104 | 66.53 | 0.00 | 0.00 | 0.00 | 66.53 |
| Harrison, Trevor, A,18055 | 143.91 | 0.00 | 0.00 | 0.00 | 143.91 |
| Rodriguez, Destiny, J,22739 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gonzales, Miranda,11660 | 324.72 | 0.00 | 0.00 | 0.00 | 324.72 |
| Barnes, Jeremy,21446 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Scott, Gabrielle,27061 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Morgan, Angela,24665 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Gray, Sara,29247 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Anderson, David, A,22097 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Brooks, Ian, W,28290 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Miller, Sydney, A,13440 | 4818.53 | 0.00 | 0.00 | 0.00 | 4818.53 |
| Cook, Seth,23010 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Hughes, Nathan, B,12113 | 4737.53 | 0.00 | 0.00 | 0.00 | 4737.53 |
| Collins, Sierra,18549 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Richardson, Arianna, C,12055 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Lee, James, J,28817 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Scott, Eric,28248 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Johnson, Xavier, R,23255 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Washington, Victoria,23557 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Clark, Emily, R,12086 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Moreno, Marie,27739 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Watson, Marcus,22715 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Taylor, Christian,20764 | 56.76 | 0.00 | 0.00 | 0.00 | 56.76 |
| Collins, Jose,24748 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rodriguez, Julia, A,26488 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Griffin, Isabelle,24986 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Taylor, Natalie, M,14338 | 828.74 | 0.00 | 0.00 | 0.00 | 828.74 |
| Turner, Jeremiah, F,19207 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Rubio, Kellie,27653 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Diaz, Brandon,23676 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Torres, Mackenzie,28153 | 570.47 | 0.00 | 0.00 | 0.00 | 570.47 |
| Lal, Caleb, R,15868 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Gomez, Krista,12760 | 273.18 | 0.00 | 0.00 | 0.00 | 273.18 |
| Suri, Carolyn, S,12972 | 175.71 | 0.00 | 0.00 | 0.00 | 175.71 |
| Blue, Makayla,19000 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Morgan, Juan, C,18821 | 91.97 | 0.00 | 0.00 | 0.00 | 91.97 |
| Yang, Aaron, C,25196 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Nelson, Luis,23488 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wilson, Grace,17539 | 205.92 | 0.00 | 0.00 | 0.00 | 205.92 |
| James, Maria,16243 | 91.97 | 0.00 | 0.00 | 0.00 | 91.97 |
| Peterson, Isabella,28080 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Harris, Samuel, M,24771 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Shan, Chad, M,24621 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Stewart, Alex, M,20084 | 63.15 | 0.00 | 0.00 | 0.00 | 63.15 |
| She, Shawn, J,16902 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Martin, Nicholas,23362 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Long, Jordyn,17338 | 47.25 | 0.00 | 0.00 | 0.00 | 47.25 |
| Robinson, Alyssa, C,23134 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Richardson, Charles, I,12114 | 4719.02 | 0.00 | 0.00 | 0.00 | 4719.02 |
| Mohamed, Samantha, A,29277 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Perez, Charles,26693 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Foster, Jessica,26069 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Hughes, Caroline, C,28302 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Clark, William,29021 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Carter, Madeline, A,27522 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Peterson, Morgan, J,16834 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Bennett, Isabelle, C,18674 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Watson, Richard,15943 | 365.41 | 0.00 | 0.00 | 0.00 | 365.41 |
| Foster, Carson, L,16959 | 135.35 | 0.00 | 0.00 | 0.00 | 135.35 |
| Roberts, Wyatt,15900 | 699.97 | 0.00 | 0.00 | 0.00 | 699.97 |
| Sanchez, Jeremiah, E,22265 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Howard, Brianna, D,24630 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martin, Thomas, A,16952 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| James, Richard, D,15760 | 109.23 | 0.00 | 0.00 | 0.00 | 109.23 |
| Gill, Robyn, J,12765 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Ross, Aaron, N,11888 | 2376.96 | 0.00 | 0.00 | 0.00 | 2376.96 |
| Smith, Hannah, J,25265 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Ramirez, Melanie, V,16363 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 |
| Ashe, Alexis, S,19414 | 1145.48 | 0.00 | 0.00 | 0.00 | 1145.48 |
| Green, Kaylee, C,26185 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Robinson, Lauren,27196 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Van, Bobby,27757 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Stewart, Cindy,14496 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Hughes, Antonio, P,15913 | 712.27 | 0.00 | 0.00 | 0.00 | 712.27 |
| Gonzalez, Amber, L,23879 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Hughes, Jasmine,27628 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Henderson, Logan, C,22366 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Flores, Gabriel,27111 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hall, Fernando,22100 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Scott, Sean, F,24755 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sanders, Stephanie, A,19746 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Henderson, Isabelle, K,16366 | 2563.35 | 0.00 | 0.00 | 0.00 | 2563.35 |
| Cox, Nathaniel, A,19661 | 2521.27 | 0.00 | 0.00 | 0.00 | 2521.27 |
| Evans, Elijah, S,25884 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Coleman, Stephanie,22264 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Gonzales, Jose,22014 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Patterson, Jeremy,13027 | 2319.26 | 0.00 | 0.00 | 0.00 | 2319.26 |
| Kelly, Trinity,26095 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Cooper, Andrea,29323 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Alexander, Jason,29328 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Roberts, Jordan, M,16800 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Stewart, Melissa,25173 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Moore, Jessica, J,20085 | 76.76 | 0.00 | 0.00 | 0.00 | 76.76 |
| Cooper, Brooke,19536 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Morris, Mason, J,22349 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Gonzales, Arianna, S,19710 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Flores, Julia, E,17263 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Simmons, Anna, K,12451 | 2367.92 | 0.00 | 0.00 | 0.00 | 2367.92 |
| Jones, Samantha,18317 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Ward, Cole,21490 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Moore, Chloe, L,26269 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Gonzales, Emily, P,21777 | 180.98 | 0.00 | 0.00 | 0.00 | 180.98 |
| Reed, Isaac, D,26074 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Foster, Caleb,27112 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Adams, Julia, N,26073 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Henderson, Hailey, C,17148 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Sanchez, Shelby,16021 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gonzalez, Madeline, B,18922 | 2326.96 | 0.00 | 0.00 | 0.00 | 2326.96 |
| Roberts, Hunter,28260 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Perry, Lauren,24816 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Carter, Jonathan,14578 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Gonzales, Jordan,23681 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Reed, Megan, A,18118 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Phillips, Haley, B,28079 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Adams, Carlos,19822 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Sanders, Lucas, W,26802 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| _SUM | 1806517.50 | 25543.71 | 492798.22 | 255388.12 | 1032787.45 |
Generated 2025-12-24 06:40:35.044 UTC