[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SKIP 1000 SKIP 0 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Lewis, Kaitlyn,15906 | 4761.03 | 0.00 | 0.00 | 0.00 | 4761.03 |
| Perry, Benjamin,29165 | 2407.04 | 0.00 | 0.00 | 2407.04 | 0.00 |
| Harris, Samuel, M,24771 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Garcia, Rachel, L,12986 | 4823.01 | 0.00 | 0.00 | 2369.97 | 2453.04 |
| Perez, Barry, M,27282 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Perez, Charles,26693 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Hughes, Caroline, C,28302 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Adams, Mason, T,20528 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Coleman, Ian,21276 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thompson, Lucas, O,21277 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jackson, Andrew,20479 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Li, Thomas,18116 | 2376.96 | 0.00 | 0.00 | 0.00 | 2376.96 |
| Murphy, Brianna, K,28342 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ross, David, M,17143 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Williams, Destiny, S,15881 | 564.99 | 0.00 | 0.00 | 564.99 | 0.00 |
| Mr., Sandstone, John, J,12903 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
| Russell, Richard,27633 | 22.26 | 0.00 | 0.00 | 0.00 | 22.26 |
| Torres, Abigail,25367 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kelly, Julia,23798 | 67.93 | 0.00 | 0.00 | 67.93 | 0.00 |
| Gill, Robyn, J,12765 | 1750.98 | 0.00 | 0.00 | 1750.98 | 0.00 |
| Anderson, Tyler, E,13148 | 1137.43 | 0.00 | 0.00 | 1137.43 | 0.00 |
| Smith, Hannah, J,25265 | 54.98 | 0.00 | 0.00 | 54.98 | 0.00 |
| Harris, Noah,29256 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Peterson, Melissa, S,24995 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martin, Joshua, A,27607 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Watson, Erin, B,22772 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Smith, Eduardo,20691 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Barnes, Kayla,24256 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Henderson, Justin, P,23591 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gray, Cindy, A,13198 | 114.95 | 0.00 | 0.00 | 99.97 | 14.98 |
| Morris, Jessica,28967 | 8.99 | 0.00 | 0.00 | 8.99 | 0.00 |
| Bradley, Evan,18506 | 101.94 | 0.00 | 0.00 | 0.00 | 101.94 |
| Washington, Adam, G,25437 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Lee, James, J,28817 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Gonzales, Paige,21702 | 91.94 | 0.00 | 0.00 | 39.98 | 51.96 |
| Diaz, Brandon,23676 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Bradley, Nathaniel,16955 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Jones, Kayla, C,18541 | 94.26 | 0.00 | 0.00 | 0.00 | 94.26 |
| White, Judith, R,14885 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Davis, Jonathan,29259 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Collins, Charles, B,29041 | 628.45 | 0.00 | 0.00 | 0.00 | 628.45 |
| Kapoor, Preston,21431 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Hill, Eric, G,25256 | 67.93 | 0.00 | 0.00 | 67.93 | 0.00 |
| Price, Rachel, D,25328 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Edwards, Logan,25002 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Flores, Cassidy, L,23368 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yuan, Brendan, S,24744 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Miller, Destiny,25157 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Phillips, Mackenzie,12444 | 228.43 | 0.00 | 0.00 | 113.96 | 114.47 |
| Mohamed, Samantha, A,29277 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Davis, Dylan,15556 | 588.96 | 0.00 | 0.00 | 588.96 | 0.00 |
| Gonzales, Cameron, L,29005 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Li, Eugene, A,15283 | 865.95 | 0.00 | 0.00 | 0.00 | 865.95 |
| Ross, Seth, M,18433 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Lewis, Rachel, J,14900 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Richardson, Erin, R,16331 | 88.85 | 0.00 | 0.00 | 38.88 | 49.97 |
| Simmons, Caleb, M,12193 | 4833.03 | 0.00 | 0.00 | 0.00 | 4833.03 |
| Turner, Mary,22015 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bell, Brooke, H,23253 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Johnson, Ian, E,21732 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Harris, Anthony,21447 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Nath, Alison, J,17116 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Richardson, Lauren, C,14867 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Wang, Zachary,22144 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Adams, Katherine, M,23518 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanchez, Jeremiah, E,22265 | 21.98 | 0.00 | 0.00 | 21.98 | 0.00 |
| Hernandez, Sierra,27393 | 123.98 | 0.00 | 0.00 | 123.98 | 0.00 |
| Mitchell, Bailey, B,26706 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Ross, Aaron, N,11888 | 2376.96 | 0.00 | 0.00 | 2376.96 | 0.00 |
| Garcia, Alexandra, J,14107 | 819.46 | 0.00 | 0.00 | 819.46 | 0.00 |
| Smith, Nathan,21764 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Harris, Seth, M,16140 | 2528.33 | 0.00 | 0.00 | 0.00 | 2528.33 |
| Lewis, Christopher,18755 | 86.96 | 0.00 | 0.00 | 0.00 | 86.96 |
| Hughes, Antonio, P,15913 | 712.27 | 0.00 | 0.00 | 0.00 | 712.27 |
| Sanchez, Katherine, S,24399 | 132.94 | 0.00 | 0.00 | 0.00 | 132.94 |
| Gonzalez, Amber, L,23879 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Sanchez, Grace,12080 | 2354.99 | 0.00 | 0.00 | 0.00 | 2354.99 |
| Johnson, Jonathan,22059 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hill, Katherine, L,26701 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jones, Dalton, T,18951 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
| Johnson, Jacob, I,28069 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Bradley, Jocelyn,23022 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Thomas, Matthew, K,13239 | 185.70 | 0.00 | 0.00 | 0.00 | 185.70 |
| Sanchez, Jared, J,25850 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Flores, Devin, A,15559 | 172.04 | 0.00 | 0.00 | 86.56 | 85.48 |
| Phillips, Andrea,18573 | 83.74 | 0.00 | 0.00 | 0.00 | 83.74 |
| Peterson, Morgan, J,16834 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Davis, Austin, E,13366 | 4749.04 | 0.00 | 0.00 | 0.00 | 4749.04 |
| Murphy, Maria,16011 | 3657.26 | 0.00 | 0.00 | 0.00 | 3657.26 |
| Turner, Kaylee, M,16213 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Kennedy, Bridget,22026 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Richardson, Nathaniel,12089 | 4710.03 | 0.00 | 0.00 | 2316.97 | 2393.06 |
| Russell, Ian, T,24746 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Barnes, Haley, J,21339 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Gonzales, Jordan,23681 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Phillips, Luis, G,20734 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Thompson, Brianna, X,18642 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Bryant, Jackson, J,25332 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ruiz, Philip,18077 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Moore, Ian, L,24639 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alexander, Jordan,21412 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Washington, Hannah, A,29130 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Gonzales, Trevor, K,16085 | 143.53 | 0.00 | 0.00 | 14.98 | 128.55 |
| Alexander, Paige, W,18604 | 59.25 | 0.00 | 0.00 | 37.27 | 21.98 |
| Hernandez, Jamie,27283 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
| Thompson, Kayla, D,12363 | 273.90 | 0.00 | 0.00 | 0.00 | 273.90 |
| Scott, Allison,14497 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Stewart, Gabriella,28034 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Zhao, Clarence, R,19826 | 71.97 | 0.00 | 0.00 | 71.97 | 0.00 |
| Lopez, Bailey, R,18557 | 1179.47 | 0.00 | 0.00 | 1179.47 | 0.00 |
| Sanders, Sean,14341 | 175.15 | 0.00 | 0.00 | 0.00 | 175.15 |
| Flores, Hannah,19525 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Ruiz, Carrie, D,18644 | 135.44 | 0.00 | 0.00 | 100.46 | 34.98 |
| Martinez, Joseph, E,29214 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Wu, Randy, J,11647 | 2365.94 | 0.00 | 0.00 | 2365.94 | 0.00 |
| Martin, James, M,19870 | 77.25 | 0.00 | 0.00 | 0.00 | 77.25 |
| Wilson, Emily,17400 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Brooks, Evan,23401 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Long, Sarah,17372 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Patterson, Eric, A,27384 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Perry, Eric,18314 | 115.73 | 0.00 | 0.00 | 0.00 | 115.73 |
| Flores, Gabriel,27111 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Mehta, Rebekah, B,27419 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Gonzalez, Molly,16370 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Brown, Dylan, J,12449 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
Generated 2024-11-10 10:18:13.432 UTC