[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanchez, Jarrod,18880 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Alvarez, Jaime, C,28058 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Lopez, Jackson,13288 | 4573.50 | 0.00 | 0.00 | 2181.56 | 2391.94 |
| Simmons, Carson, A,19129 | 639.45 | 0.00 | 0.00 | 0.00 | 639.45 |
| Allen, Isaiah, A,12529 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Jimenez, Lori, C,21024 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Kumar, Jason,13375 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Perry, Samantha, F,24776 | 91.58 | 0.00 | 0.00 | 0.00 | 91.58 |
| Cooper, Cole, C,19707 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Sara, Francisco, A,12296 | 9586.37 | 0.00 | 0.00 | 2451.30 | 7135.07 |
| Price, Blake,27018 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| James, Marcus, E,23719 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raji, Alicia,18404 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wilson, Lauren, A,14887 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Brooks, Kaitlyn, S,15475 | 1587.46 | 0.00 | 0.00 | 782.99 | 804.47 |
| Rogers, Jasmine, K,23243 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Perez, Miguel,13184 | 220.46 | 0.00 | 0.00 | 0.00 | 220.46 |
| Hall, Brianna,16069 | 579.97 | 0.00 | 0.00 | 0.00 | 579.97 |
| Griffin, Taylor, E,23269 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Lee, Ryan,16055 | 66.44 | 0.00 | 0.00 | 0.00 | 66.44 |
| Simmons, Spencer, D,28279 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Walker, Lucas,23089 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Washington, Seth, J,25851 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Liang, Cara, M,13515 | 2369.97 | 0.00 | 0.00 | 0.00 | 2369.97 |
| Hernandez, Jan, L,11803 | 229.95 | 0.00 | 0.00 | 0.00 | 229.95 |
| Powell, Brandon,23081 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| She, Suzanne,28902 | 2529.93 | 0.00 | 0.00 | 0.00 | 2529.93 |
| Griffin, Alexis, S,25376 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Xu, Kristin, D,20925 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Jackson, Jeremiah, A,18400 | 2409.95 | 0.00 | 0.00 | 0.00 | 2409.95 |
| Collins, Fernando, M,25461 | 1775.97 | 0.00 | 0.00 | 0.00 | 1775.97 |
| Nelson, Marcus, N,19903 | 3177.94 | 0.00 | 0.00 | 782.99 | 2394.95 |
| Blanco, Arthur,21913 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Yuan, Kate,18973 | 567.27 | 0.00 | 0.00 | 0.00 | 567.27 |
| Washington, Sarah, C,13855 | 3095.52 | 0.00 | 0.00 | 2181.56 | 913.96 |
| Adams, Elijah, L,13214 | 4501.55 | 0.00 | 2181.56 | 0.00 | 2319.99 |
| Xie, Damien,20553 | 2354.98 | 0.00 | 0.00 | 0.00 | 2354.98 |
| Sanders, Danielle, J,15358 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Xie, Kate, J,26832 | 80.47 | 0.00 | 0.00 | 0.00 | 80.47 |
| Perez, Carla,11567 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Simmons, Blake,12951 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Martin, Jose, C,15079 | 2731.54 | 0.00 | 0.00 | 2181.56 | 549.98 |
| Butler, Alexia, F,23882 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Browning, Carolyn,22478 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Cook, Katelyn, E,12787 | 53.56 | 0.00 | 0.00 | 0.00 | 53.56 |
| Nath, Raul,27881 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Ramirez, Jacqueline, R,21487 | 548.98 | 0.00 | 0.00 | 548.98 | 0.00 |
| Wilson, Brandon,23334 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Johnston, Charles,16727 | 2451.30 | 0.00 | 0.00 | 0.00 | 2451.30 |
| Sanders, Jared, C,25529 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Washington, Edward,11518 | 82.20 | 0.00 | 0.00 | 0.00 | 82.20 |
| Moore, Miguel,18312 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Hayes, Elizabeth, L,17663 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Perry, Dylan, M,17568 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Chen, Alvin,26863 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Walker, Natalie,12894 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Ward, Evan, S,14365 | 1804.92 | 0.00 | 0.00 | 1000.44 | 804.48 |
| Collins, Gabrielle,15975 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Sharma, Casey, A,12814 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Tang, Melvin, R,13663 | 15.23 | 0.00 | 0.00 | 15.23 | 0.00 |
| Li, Gabriel, J,13395 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Davis, Emma,23024 | 106.95 | 0.00 | 0.00 | 0.00 | 106.95 |
Generated 2025-12-23 08:06:48.205 UTC