[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 500 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Taylor, Jeremiah, M,29012 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Patterson, Alexis,21348 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Lal, Kyle,17360 | 122.18 | 0.00 | 0.00 | 0.00 | 122.18 |
| Richardson, Victoria, C,24817 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Campbell, Evan, W,24342 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Martin, Jeremiah, E,17345 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Sandberg, Nicole, M,12077 | 144.69 | 0.00 | 0.00 | 94.46 | 50.23 |
| Hall, Taylor, J,16995 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Griffin, Marcus,20756 | 34.56 | 0.00 | 0.00 | 0.00 | 34.56 |
| Jai, Adam,25095 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Jackson, Brianna,15377 | 97.91 | 0.00 | 0.00 | 74.98 | 22.93 |
| Alexander, Jordan,21412 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Carter, Luis, E,25883 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Jones, Michael, A,22107 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Simmons, Dylan,16133 | 107.85 | 0.00 | 0.00 | 38.88 | 68.97 |
| Campbell, Isabella, C,20350 | 3226.90 | 0.00 | 2071.42 | 0.00 | 1155.48 |
| Griffin, Melissa, L,28780 | 7.95 | 0.00 | 0.00 | 0.00 | 7.95 |
| Ramirez, Sydney,26700 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Green, Blake, P,11719 | 287.20 | 0.00 | 0.00 | 0.00 | 287.20 |
| Green, Xavier,23567 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cooper, Grace, C,16012 | 94.26 | 0.00 | 0.00 | 0.00 | 94.26 |
| Cook, Steven, J,27053 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Gray, Seth, M,20087 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| He, Micah,27401 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Chen, James, D,11641 | 303.20 | 0.00 | 0.00 | 21.49 | 281.71 |
| Wang, Karen, P,19553 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Martin, Brandon, S,21691 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Coleman, Lucas, A,27060 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Brown, Christian,22755 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hernandez, Jamie,27283 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
| Harris, Edward,27062 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Henderson, Ashley,11185 | 1381.37 | 0.00 | 0.00 | 232.80 | 1148.57 |
| Turner, Samuel,27420 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Russell, Fernando,27084 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Patterson, Austin, O,27024 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Harris, Natalie,23682 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Hayes, Arianna,25991 | 2845.52 | 0.00 | 0.00 | 2181.56 | 663.96 |
| Sanchez, Adrian, L,13179 | 190.17 | 0.00 | 0.00 | 0.00 | 190.17 |
| Ward, Natalie, J,13241 | 2325.96 | 0.00 | 0.00 | 0.00 | 2325.96 |
| Flores, Stephanie,25992 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Rogers, Sean, G,18685 | 124.46 | 0.00 | 0.00 | 0.00 | 124.46 |
| Thompson, Kayla, D,12363 | 273.90 | 0.00 | 0.00 | 0.00 | 273.90 |
| Turner, Adam, K,16109 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Carter, Jason,11724 | 210.09 | 0.00 | 0.00 | 113.86 | 96.23 |
| Sandberg, Chase,21904 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Malhotra, Kristi, S,15175 | 4850.33 | 0.00 | 0.00 | 0.00 | 4850.33 |
| Gray, Sebastian, B,13878 | 2366.96 | 0.00 | 0.00 | 0.00 | 2366.96 |
| Gonzalez, Gabriella, Z,15872 | 235.54 | 0.00 | 0.00 | 0.00 | 235.54 |
| Carter, Sydney,12959 | 203.92 | 0.00 | 0.00 | 0.00 | 203.92 |
| Flores, Julian,15846 | 4943.32 | 0.00 | 0.00 | 0.00 | 4943.32 |
| Butler, Benjamin, C,18972 | 2369.97 | 0.00 | 0.00 | 0.00 | 2369.97 |
| Carter, Madeline, A,27522 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Walker, Jacob, N,29027 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Morris, Seth,18959 | 2341.46 | 0.00 | 0.00 | 0.00 | 2341.46 |
| Chavez, Kara, P,13285 | 214.35 | 0.00 | 0.00 | 12.94 | 201.41 |
| Evans, Kaylee,19642 | 133.54 | 0.00 | 0.00 | 0.00 | 133.54 |
| Torres, Mackenzie,28153 | 570.47 | 0.00 | 0.00 | 0.00 | 570.47 |
| Jenkins, Megan, R,12074 | 261.38 | 0.00 | 0.00 | 0.00 | 261.38 |
| Bryant, Isabelle,23397 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Lee, Ian,19646 | 197.04 | 0.00 | 0.00 | 0.00 | 197.04 |
| Hernandez, Marcus,18595 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Adams, Jennifer,15362 | 4745.02 | 0.00 | 0.00 | 0.00 | 4745.02 |
| Lopez, Bailey, R,18557 | 1179.47 | 0.00 | 0.00 | 1179.47 | 0.00 |
| Ward, Jade, D,14661 | 195.02 | 0.00 | 0.00 | 0.00 | 195.02 |
| Griffin, Jason, L,11200 | 1267.11 | 0.00 | 0.00 | 391.08 | 876.03 |
| Jones, Natalie, A,11845 | 197.20 | 0.00 | 0.00 | 82.26 | 114.94 |
| Nelson, Jennifer,17147 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Moore, Jessica, J,20085 | 76.76 | 0.00 | 0.00 | 0.00 | 76.76 |
| Sanchez, Nicole, L,14874 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Collins, Alex, S,28781 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Sanders, Hailey,19647 | 282.04 | 0.00 | 0.00 | 0.00 | 282.04 |
| Roberts, Amanda,17175 | 2334.98 | 0.00 | 0.00 | 0.00 | 2334.98 |
| Griffin, Jennifer, B,14244 | 154.96 | 0.00 | 0.00 | 0.00 | 154.96 |
| Moore, Jennifer, A,21759 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Lewis, Ethan,27998 | 144.47 | 0.00 | 0.00 | 0.00 | 144.47 |
| Foster, Edward, R,18355 | 150.95 | 0.00 | 0.00 | 0.00 | 150.95 |
| Blanco, Armando, F,13918 | 2397.95 | 0.00 | 0.00 | 0.00 | 2397.95 |
| Edwards, Elijah, D,28157 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ramirez, Gabrielle, H,16000 | 4813.95 | 0.00 | 0.00 | 0.00 | 4813.95 |
| Powell, Caleb, G,21613 | 2610.58 | 0.00 | 0.00 | 2049.10 | 561.48 |
| Ruiz, Carrie, D,18644 | 135.44 | 0.00 | 0.00 | 100.46 | 34.98 |
| Anderson, Emma, A,18580 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Brown, Benjamin, D,15187 | 4725.32 | 0.00 | 0.00 | 0.00 | 4725.32 |
| Johnson, Christopher,11979 | 4813.76 | 0.00 | 0.00 | 2352.21 | 2461.55 |
| Gonzales, Luis,15856 | 116.25 | 0.00 | 0.00 | 37.27 | 78.98 |
| Simmons, Anna, K,12451 | 2367.92 | 0.00 | 0.00 | 0.00 | 2367.92 |
| Prasad, Summer, M,22143 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Kumar, Austin,20483 | 4400.06 | 0.00 | 0.00 | 2049.10 | 2350.96 |
| Foster, Jose, C,28785 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Taylor, Lucas, V,11523 | 2376.96 | 0.00 | 0.00 | 2376.96 | 0.00 |
| Williams, Zachary, B,27099 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Rogers, Carlos,19645 | 134.44 | 0.00 | 0.00 | 0.00 | 134.44 |
| Thompson, Xavier, R,15761 | 192.41 | 0.00 | 0.00 | 0.00 | 192.41 |
| Bell, Eduardo,27101 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Thomas, David,16836 | 3193.79 | 0.00 | 0.00 | 0.00 | 3193.79 |
| Hughes, Anna,19705 | 2341.97 | 0.00 | 0.00 | 0.00 | 2341.97 |
| Townsend, Jeremiah, I,26503 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Allen, Angel, G,15571 | 101.85 | 0.00 | 0.00 | 34.89 | 66.96 |
| Robinson, Julia,28121 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Anderson, Ashley,20680 | 3219.58 | 0.00 | 0.00 | 2049.10 | 1170.48 |
| Lal, Jonathan,20096 | 71.46 | 0.00 | 0.00 | 0.00 | 71.46 |
| Yang, Aaron, C,25196 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Taylor, Victoria,26013 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Hughes, Austin, P,18368 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Simmons, Brittany,29231 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Davis, Jasmine, M,26529 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Ward, Lucas, N,18363 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Thomas, Wyatt, R,12431 | 154.54 | 0.00 | 0.00 | 94.98 | 59.56 |
| James, Timothy,21331 | 2670.89 | 0.00 | 0.00 | 2670.89 | 0.00 |
| Gomez, Briana, A,28784 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Li, Kevin, S,25188 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ramirez, Jennifer, E,21311 | 4472.58 | 0.00 | 0.00 | 2049.10 | 2423.48 |
| Taylor, Edward, C,17442 | 319.88 | 0.00 | 0.00 | 230.90 | 88.98 |
| Sanchez, Stephanie,17867 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Carter, Bailey,21332 | 2616.86 | 0.00 | 0.00 | 2616.86 | 0.00 |
| Long, Rachel,28283 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jackson, Victoria,27019 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Simmons, Haley, T,26202 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Navarro, Jerome, B,11519 | 717.28 | 0.00 | 0.00 | 22.18 | 695.10 |
| Hughes, Nathan, B,12113 | 4737.53 | 0.00 | 0.00 | 2294.99 | 2442.54 |
| Jones, Zachary, J,27285 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Robinson, Dylan, L,14724 | 81.53 | 0.00 | 0.00 | 0.00 | 81.53 |
| Morris, Jessica,28967 | 8.99 | 0.00 | 0.00 | 8.99 | 0.00 |
| Collins, Connor, J,27270 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
Generated 2025-11-03 07:21:53.543 UTC