[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 40 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Diaz, Caroline,20572 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Sharma, Johnny,19834 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Collins, Evan,15255 | 1587.47 | 0.00 | 782.99 | 0.00 | 804.48 |
| Alvarez, Ruben,12543 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Allen, James, V,28565 | 58.47 | 0.00 | 0.00 | 0.00 | 58.47 |
| Green, Jackson, S,17475 | 2370.96 | 0.00 | 0.00 | 0.00 | 2370.96 |
| Simmons, Eduardo,24350 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Flores, Marissa,15998 | 2371.96 | 0.00 | 0.00 | 0.00 | 2371.96 |
| Brown, Olivia,11218 | 39.58 | 0.00 | 0.00 | 0.00 | 39.58 |
| Rivera, Isaiah, K,23011 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Green, Amanda,21808 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Murphy, Gabriella, D,29148 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
Generated 2025-12-22 06:42:35.949 UTC