[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Perez, Amber, D,13318 | 214.26 | 0.00 | 0.00 | 116.91 | 97.35 |
| Campbell, Chloe,11212 | 760.93 | 0.00 | 0.00 | 307.78 | 453.15 |
| Roberts, Mason, D,11176 | 1106.68 | 0.00 | 0.00 | 693.99 | 412.69 |
| Jenkins, Samantha,11331 | 1290.33 | 0.00 | 0.00 | 822.35 | 467.98 |
| Powell, Katherine, C,14574 | 177.60 | 0.00 | 0.00 | 138.72 | 38.88 |
| Thompson, Jose,23731 | 4828.11 | 0.00 | 3578.27 | 1249.84 | 0.00 |
| Smith, Megan, J,26716 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Sanchez, Caitlin, M,22080 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Gonzalez, Madeline, B,18922 | 2326.96 | 0.00 | 0.00 | 0.00 | 2326.96 |
| Barnes, Blake, A,17865 | 1789.97 | 0.00 | 0.00 | 0.00 | 1789.97 |
| Thompson, Ryan, M,11330 | 1111.36 | 0.00 | 0.00 | 623.78 | 487.58 |
| Peterson, Brian,12892 | 419.47 | 0.00 | 0.00 | 156.27 | 263.20 |
| Gonzales, Melanie, C,18089 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Smith, Austin,13707 | 149.05 | 0.00 | 0.00 | 0.00 | 149.05 |
| Butler, Cassidy, L,21792 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Washington, Kayla, E,14655 | 174.96 | 0.00 | 0.00 | 174.96 | 0.00 |
| Phillips, James, G,16846 | 180.95 | 0.00 | 0.00 | 180.95 | 0.00 |
| Scott, Eric,28248 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Powell, Jasmine, A,11505 | 846.77 | 0.00 | 0.00 | 562.68 | 284.09 |
| Turner, Kaylee, M,16213 | 154.54 | 0.00 | 0.00 | 49.97 | 104.57 |
| Bradley, Rachel,15850 | 4813.04 | 0.00 | 0.00 | 2374.98 | 2438.06 |
| Collins, Hailey,11709 | 325.89 | 0.00 | 0.00 | 156.45 | 169.44 |
| Patterson, Hailey, I,11223 | 1155.90 | 0.00 | 0.00 | 637.86 | 518.04 |
| Kumar, Elijah,15197 | 156.92 | 0.00 | 0.00 | 49.97 | 106.95 |
| Powell, Spencer,14904 | 468.12 | 0.00 | 0.00 | 0.00 | 468.12 |
| Simmons, Jennifer,11262 | 1010.56 | 0.00 | 0.00 | 488.15 | 522.41 |
| Price, Lauren, J,14079 | 184.74 | 0.00 | 0.00 | 115.77 | 68.97 |
| Barnes, Ian, M,16106 | 133.54 | 0.00 | 0.00 | 100.94 | 32.60 |
| Ma, Tiffany,21577 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Foster, Abigail,19823 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Watson, Victoria,16125 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Jackson, Brianna,15377 | 97.91 | 0.00 | 0.00 | 97.91 | 0.00 |
| Turner, James, E,16841 | 126.96 | 0.00 | 0.00 | 126.96 | 0.00 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 330.95 | 668.27 |
| Evans, Jordan,29209 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Jenkins, Alexandra, D,11632 | 924.61 | 0.00 | 0.00 | 549.40 | 375.21 |
| Torres, Erin,12182 | 87.25 | 0.00 | 0.00 | 67.28 | 19.97 |
| Hill, Blake,11748 | 131.54 | 0.00 | 0.00 | 54.95 | 76.59 |
| Chandra, Allen,29327 | 53.99 | 0.00 | 0.00 | 53.99 | 0.00 |
| Patterson, Eduardo,11142 | 866.81 | 0.00 | 0.00 | 229.70 | 637.11 |
| Mitchell, Evan, R,24731 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sharma, Jackson,16876 | 151.84 | 0.00 | 0.00 | 34.89 | 116.95 |
| Lopez, Katelyn,11820 | 232.71 | 0.00 | 0.00 | 127.74 | 104.97 |
| James, Maria,16243 | 91.97 | 0.00 | 0.00 | 69.99 | 21.98 |
| Wood, Gavin,16964 | 108.54 | 0.00 | 0.00 | 108.54 | 0.00 |
| Wang, Austin, A,14632 | 84.97 | 0.00 | 0.00 | 9.99 | 74.98 |
| Ramirez, Richard, C,28239 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Mitchell, Alexandra,14455 | 218.93 | 0.00 | 0.00 | 23.97 | 194.96 |
| Nath, Alison, J,17116 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Lewis, Kaitlyn,15906 | 4761.03 | 0.00 | 0.00 | 0.00 | 4761.03 |
| Chandra, Brandy, P,11501 | 603.53 | 0.00 | 0.00 | 128.21 | 475.32 |
| Washington, Vanessa,23819 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Diaz, Ryan, J,16910 | 141.96 | 0.00 | 0.00 | 71.97 | 69.99 |
| White, Nicole,16731 | 155.91 | 0.00 | 0.00 | 84.96 | 70.95 |
| Coleman, Isabel, S,12530 | 337.90 | 0.00 | 0.00 | 262.92 | 74.98 |
| Chen, Jack, E,17579 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Hayes, Brittany,13941 | 286.82 | 0.00 | 0.00 | 38.88 | 247.94 |
| Sanders, Alexa, E,21741 | 4127.25 | 3578.27 | 0.00 | 548.98 | 0.00 |
| Perry, Jennifer, J,22120 | 5962.34 | 3578.27 | 0.00 | 2384.07 | 0.00 |
| Coleman, Destiny, W,12122 | 4814.04 | 0.00 | 0.00 | 4814.04 | 0.00 |
| Hughes, Caroline, C,28302 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Rowe, Todd,14586 | 233.94 | 0.00 | 0.00 | 0.00 | 233.94 |
Generated 2026-07-22 17:13:11.736 UTC