[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2390 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Griffin, Zachary,16990 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Bryant, Eric,13471 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Rogers, Gabrielle,24635 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Suri, Chelsea, L,26273 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Sara, Gerald, C,21716 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Kelly, Kaylee, W,14602 | 3150.54 | 0.00 | 699.10 | 0.00 | 2451.44 |
| Jai, Arturo, T,24180 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Cook, Bailey,24354 | 2418.05 | 0.00 | 0.00 | 0.00 | 2418.05 |
| She, Edwin,27417 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Nelson, Xavier,21328 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Clark, Xavier, L,18967 | 132.97 | 0.00 | 0.00 | 132.97 | 0.00 |
| Bradley, Riley,18142 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Hughes, Megan, W,13947 | 4605.04 | 0.00 | 0.00 | 2181.56 | 2423.48 |
| Gill, Daisy, E,26395 | 25.48 | 0.00 | 0.00 | 25.48 | 0.00 |
| Flores, Faith,18849 | 2366.96 | 0.00 | 0.00 | 0.00 | 2366.96 |
| Smith, Julia,21282 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Cooper, Marcus,26470 | 35.23 | 0.00 | 0.00 | 0.00 | 35.23 |
| Nath, Edwin,24181 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Perez, Ruben,18556 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Bennett, Gavin,17588 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Bell, Juan, L,17215 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Taylor, Morgan, D,16879 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Rogers, Jasmine, K,23243 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Beck, Calvin,29106 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Gonzalez, Jack, A,23254 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Simmons, Spencer, D,28279 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sharma, Priscilla, E,23911 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Wright, Jeremy, S,27223 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Rodriguez, Sydney, C,28001 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Scott, Stephanie,18518 | 2379.95 | 0.00 | 0.00 | 0.00 | 2379.95 |
Generated 2025-12-18 02:12:06.602 UTC