[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Reed, Morgan, E,28779 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Long, Xavier,11251 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| Martinez, Matthew, L,16009 | 170.45 | 0.00 | 0.00 | 0.00 | 170.45 |
| Baker, Gabriella,17404 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Davis, Nicholas,13201 | 73.16 | 0.00 | 0.00 | 0.00 | 73.16 |
| Thomas, Victoria, A,15536 | 249.53 | 0.00 | 0.00 | 0.00 | 249.53 |
| Thompson, Ryan, M,11330 | 1111.36 | 0.00 | 0.00 | 623.78 | 487.58 |
| Griffin, Jason, L,11200 | 1267.11 | 0.00 | 0.00 | 724.21 | 542.90 |
| Garcia, Henry, B,11287 | 1009.24 | 0.00 | 0.00 | 572.88 | 436.36 |
| Sharma, Jackson,16876 | 151.84 | 0.00 | 0.00 | 34.89 | 116.95 |
| Nelson, Adam, B,27402 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Foster, Antonio,12795 | 108.54 | 0.00 | 0.00 | 66.26 | 42.28 |
| Moreno, Renee, C,12936 | 265.22 | 0.00 | 0.00 | 0.00 | 265.22 |
| Scott, Adam,15863 | 243.01 | 0.00 | 0.00 | 171.43 | 71.58 |
| Clark, Joseph, D,15395 | 4780.02 | 0.00 | 0.00 | 2360.96 | 2419.06 |
| Simmons, Jennifer,11262 | 1010.56 | 0.00 | 0.00 | 488.15 | 522.41 |
| Williams, Ryan, R,22247 | 5978.61 | 3578.27 | 0.00 | 0.00 | 2400.34 |
| Cooper, Ariana,17348 | 205.42 | 0.00 | 0.00 | 84.96 | 120.46 |
| Carter, Jose, H,12532 | 235.72 | 0.00 | 0.00 | 0.00 | 235.72 |
| Dominguez, Meghan,14370 | 122.56 | 0.00 | 0.00 | 0.00 | 122.56 |
| White, Edward, J,15847 | 205.46 | 0.00 | 0.00 | 119.98 | 85.48 |
| Chandra, Brandy, P,11501 | 603.53 | 0.00 | 0.00 | 128.21 | 475.32 |
| Campbell, Hunter,17422 | 174.92 | 0.00 | 0.00 | 0.00 | 174.92 |
| Peterson, Christina,28976 | 94.48 | 0.00 | 0.00 | 94.48 | 0.00 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 330.95 | 668.27 |
| Martin, Gina, E,11078 | 793.27 | 0.00 | 0.00 | 480.26 | 313.01 |
| Clark, Emily, R,12086 | 2294.99 | 0.00 | 0.00 | 2294.99 | 0.00 |
| Baker, Mason, A,13270 | 2394.95 | 0.00 | 0.00 | 0.00 | 2394.95 |
| Hernandez, José, M,11253 | 696.61 | 0.00 | 0.00 | 372.94 | 323.67 |
| Rodriguez, Richard,12969 | 180.79 | 0.00 | 0.00 | 73.54 | 107.25 |
| Roberts, Mason, D,11176 | 1106.68 | 0.00 | 0.00 | 693.99 | 412.69 |
| Taylor, Madison, A,11802 | 215.29 | 0.00 | 0.00 | 155.73 | 59.56 |
| Young, Kaylee, S,13756 | 298.49 | 0.00 | 0.00 | 298.49 | 0.00 |
| Richardson, Devin, G,21318 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Ross, Isabelle, D,18554 | 155.45 | 0.00 | 0.00 | 155.45 | 0.00 |
| Brown, Nicholas, S,11506 | 675.64 | 0.00 | 0.00 | 401.27 | 274.37 |
| Flores, Brandon, L,25621 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Flores, Zachary, H,23376 | 5314.25 | 0.00 | 3578.27 | 1735.98 | 0.00 |
| Jackson, Charles, P,11277 | 1305.66 | 0.00 | 0.00 | 790.61 | 515.05 |
| Wright, Katelyn, A,14502 | 122.26 | 0.00 | 0.00 | 84.97 | 37.29 |
| Johnson, James,23498 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Watson, Marcus,22715 | 85.48 | 0.00 | 0.00 | 85.48 | 0.00 |
| Stewart, Alexandria,17476 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Ross, Antonio,18322 | 148.89 | 0.00 | 0.00 | 118.41 | 30.48 |
| Sanchez, Lucas, L,23351 | 4828.11 | 0.00 | 3578.27 | 1249.84 | 0.00 |
| Martinez, Jill,24235 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Reed, Sean, L,14597 | 4803.31 | 0.00 | 0.00 | 2384.25 | 2419.06 |
| Russell, Isabella, A,11507 | 645.78 | 0.00 | 0.00 | 278.85 | 366.93 |
| Campbell, Chloe,11212 | 760.93 | 0.00 | 0.00 | 307.78 | 453.15 |
| Russell, Jacqueline,18391 | 100.96 | 0.00 | 0.00 | 100.96 | 0.00 |
| Dominguez, Erika, C,21251 | 191.27 | 0.00 | 0.00 | 24.99 | 166.28 |
| Peterson, Brian,12892 | 419.47 | 0.00 | 0.00 | 156.27 | 263.20 |
| Peterson, Jared,11502 | 829.37 | 0.00 | 0.00 | 446.84 | 382.53 |
| Thompson, Ethan,19989 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Malhotra, Brenda,13391 | 2405.47 | 0.00 | 0.00 | 0.00 | 2405.47 |
| James, Jeremiah, S,11661 | 287.70 | 0.00 | 0.00 | 104.97 | 182.73 |
| Smith, Justin, P,19827 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Adams, Jennifer,15362 | 4745.02 | 0.00 | 0.00 | 2351.96 | 2393.06 |
| Mitchell, Savannah,26115 | 3052.80 | 0.00 | 0.00 | 2443.35 | 609.45 |
| Bell, Alex, M,16754 | 3118.60 | 0.00 | 0.00 | 756.33 | 2362.27 |
| Turner, Jose,11784 | 272.69 | 0.00 | 0.00 | 144.97 | 127.72 |
| Murphy, Catherine, L,16506 | 92.05 | 0.00 | 0.00 | 92.05 | 0.00 |
| Green, Samuel, D,14096 | 174.73 | 0.00 | 0.00 | 67.27 | 107.46 |
| Townsend, Bryan,14077 | 180.73 | 0.00 | 0.00 | 0.00 | 180.73 |
| Taylor, Jeremiah, M,29012 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Griffin, Haley, L,18925 | 82.18 | 0.00 | 0.00 | 45.22 | 36.96 |
| Perez, Amber, D,13318 | 214.26 | 0.00 | 0.00 | 116.91 | 97.35 |
| Harris, Isabella,17119 | 214.90 | 0.00 | 0.00 | 214.90 | 0.00 |
| Hall, Kaylee, E,19751 | 37.27 | 0.00 | 0.00 | 32.28 | 4.99 |
| Ross, Xavier, A,12202 | 171.47 | 0.00 | 0.00 | 99.53 | 71.94 |
| Young, Julia, J,27414 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hall, Elizabeth, L,13474 | 339.48 | 0.00 | 0.00 | 83.95 | 255.53 |
| Brooks, Victoria, H,16479 | 158.51 | 0.00 | 0.00 | 36.96 | 121.55 |
| Thomas, Dylan,19873 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Bailey, Jessica, L,12945 | 218.44 | 0.00 | 0.00 | 49.97 | 168.47 |
| Allen, Angel, G,15571 | 101.85 | 0.00 | 0.00 | 44.88 | 56.97 |
| Sharma, Samuel,27725 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Moore, Anthony, M,24730 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Li, Connor,20186 | 3191.91 | 0.00 | 2071.42 | 0.00 | 1120.49 |
| Sanders, Xavier,16721 | 73.75 | 0.00 | 0.00 | 23.78 | 49.97 |
| Martin, John, A,14436 | 4776.01 | 0.00 | 0.00 | 2356.95 | 2419.06 |
| Davis, Jonathan,29259 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Navarro, Jerome, B,11519 | 717.28 | 0.00 | 0.00 | 451.41 | 265.87 |
| Thompson, Kaitlyn, L,12430 | 223.93 | 0.00 | 0.00 | 148.95 | 74.98 |
| Powell, Jasmine, A,11505 | 846.77 | 0.00 | 0.00 | 562.68 | 284.09 |
| Bailey, Marcus, L,18329 | 146.53 | 0.00 | 0.00 | 23.78 | 122.75 |
| Rubio, Kellie,27653 | 128.97 | 0.00 | 0.00 | 128.97 | 0.00 |
| Sanders, Alexa, E,21741 | 4127.25 | 3578.27 | 0.00 | 548.98 | 0.00 |
| Long, Brandon, M,16110 | 650.47 | 0.00 | 0.00 | 0.00 | 650.47 |
| Bennett, Jennifer, G,13708 | 123.94 | 0.00 | 0.00 | 123.94 | 0.00 |
| White, Nicole,16731 | 155.91 | 0.00 | 0.00 | 84.96 | 70.95 |
| Brooks, Lucas, S,16089 | 342.03 | 0.00 | 0.00 | 180.98 | 161.05 |
| Mehta, Carmen, C,27436 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Perry, Jennifer, J,22120 | 5962.34 | 3578.27 | 0.00 | 2384.07 | 0.00 |
| Allen, Amanda,22353 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Long, Natalie,14363 | 192.34 | 0.00 | 0.00 | 14.98 | 177.36 |
| Coleman, Destiny, W,12122 | 4814.04 | 0.00 | 0.00 | 4814.04 | 0.00 |
| She, Kenneth,16096 | 212.01 | 0.00 | 0.00 | 188.04 | 23.97 |
| Stewart, Allison, R,18826 | 166.43 | 0.00 | 0.00 | 69.99 | 96.44 |
| Hughes, Caroline, C,28302 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Lal, Luke, L,11019 | 698.23 | 0.00 | 0.00 | 305.18 | 393.05 |
| Moore, Wyatt, F,18971 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Hall, Taylor, J,16995 | 1735.98 | 0.00 | 0.00 | 1735.98 | 0.00 |
| Garcia, Patricia,11651 | 226.43 | 0.00 | 0.00 | 204.94 | 21.49 |
| Zhang, Robert,18855 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Jenkins, Alexandra, D,11632 | 924.61 | 0.00 | 0.00 | 549.40 | 375.21 |
| Thomas, Emily,21803 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Moore, Hunter,14897 | 196.27 | 0.00 | 0.00 | 146.04 | 50.23 |
| Jackson, Brianna,15377 | 97.91 | 0.00 | 0.00 | 97.91 | 0.00 |
| Hernandez, Marcus,18595 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Miller, Kayla, A,23673 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Cooper, Brian, L,13760 | 128.84 | 0.00 | 0.00 | 92.25 | 36.59 |
| Brown, Benjamin, D,15187 | 4725.32 | 0.00 | 0.00 | 2304.98 | 2420.34 |
| Foster, Kayla,19693 | 71.95 | 0.00 | 0.00 | 71.95 | 0.00 |
| Baker, Isaiah,12106 | 169.54 | 0.00 | 0.00 | 37.29 | 132.25 |
| Moore, Matthew, W,13267 | 109.95 | 0.00 | 0.00 | 79.97 | 29.98 |
| Davis, Ethan,13660 | 4750.01 | 0.00 | 0.00 | 2351.96 | 2398.05 |
| Ward, Ian,12056 | 213.92 | 0.00 | 0.00 | 68.97 | 144.95 |
| Rodriguez, Alexis, L,15244 | 179.19 | 0.00 | 0.00 | 125.23 | 53.96 |
| Gomez, Krista,12760 | 273.18 | 0.00 | 0.00 | 273.18 | 0.00 |
| Wang, Benjamin, R,27454 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Lopez, Carlos,18617 | 1147.77 | 0.00 | 0.00 | 1147.77 | 0.00 |
| Smith, Lucas, P,18090 | 64.91 | 0.00 | 0.00 | 64.91 | 0.00 |
| Gray, Seth, M,20087 | 85.48 | 0.00 | 0.00 | 85.48 | 0.00 |
| Edwards, Connor,16950 | 211.01 | 0.00 | 0.00 | 124.06 | 86.95 |
Generated 2026-07-22 11:58:28.488 UTC