[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 30 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Srini, Brandy, W,26988 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Bryant, Vanessa,12929 | 4820.31 | 0.00 | 2443.35 | 0.00 | 2376.96 |
| Ramirez, Melissa,28019 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hayes, Aaron, A,15568 | 3112.97 | 0.00 | 0.00 | 782.99 | 2329.98 |
| Robinson, Rachel, J,28014 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Hayes, Melanie, G,25099 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Perry, Connor,17041 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Evans, Chloe,20348 | 2511.32 | 0.00 | 0.00 | 0.00 | 2511.32 |
| Vazquez, Derrick,14966 | 2746.55 | 0.00 | 0.00 | 2181.56 | 564.99 |
| Davis, Robert,14755 | 1592.57 | 0.00 | 699.10 | 0.00 | 893.47 |
| Cooper, Abigail, D,24329 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Munoz, Melody, C,11340 | 4413.06 | 0.00 | 0.00 | 4413.06 | 0.00 |
| Harris, Nicole, M,20349 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Guo, Don,18742 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Navarro, Joan,19180 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-12-21 15:13:55.644 UTC