[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1031 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Garcia, Elizabeth, B,14757 | 1538.58 | 0.00 | 699.10 | 0.00 | 839.48 |
| Wood, Morgan, M,18760 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Collins, Eric, L,15275 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Alvarez, Victor,18022 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Pal, Tara,16395 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Zhang, Luis, R,16811 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Brown, Olivia,11218 | 39.58 | 0.00 | 0.00 | 0.00 | 39.58 |
| Bell, Anna, K,23394 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Srini, Erick, H,17947 | 3932.54 | 0.00 | 0.00 | 2181.56 | 1750.98 |
| Blanco, Adrienne, M,18132 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
| Sai, Cory, E,12501 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Murphy, Isaac, L,27225 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Davis, Kayla,16381 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Peterson, Brianna, W,16746 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Simmons, Devin, K,12102 | 5903.19 | 0.00 | 3578.27 | 0.00 | 2324.92 |
| Cooper, Kaitlyn, V,27801 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Edwards, Kevin, L,14734 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Serrano, Melinda,25681 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Gill, Joe,13766 | 3001.04 | 0.00 | 2181.56 | 0.00 | 819.48 |
| Mr., Ruggiero, Michael,21867 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Murphy, Stephanie, B,11213 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Baker, Andrea, L,15542 | 3117.96 | 0.00 | 0.00 | 782.99 | 2334.97 |
| Brooks, Bailey, M,15941 | 3105.27 | 0.00 | 0.00 | 782.99 | 2322.28 |
| Rivera, Brooke, L,26698 | 4442.16 | 0.00 | 0.00 | 2049.10 | 2393.06 |
| Tang, Omar, L,24027 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
| Nath, Karla,22317 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Alvarez, Shannon,11551 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Simmons, Rachel, E,16320 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Powell, Wyatt, L,12066 | 84.99 | 0.00 | 0.00 | 0.00 | 84.99 |
| Thompson, Elizabeth, W,11864 | 47.94 | 0.00 | 0.00 | 0.00 | 47.94 |
| Roberts, Jack, E,14736 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
Generated 2025-12-24 08:11:16.193 UTC