[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 6 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Andersen, Russell,14695 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Williams, Nathan,25200 | 100.09 | 0.00 | 0.00 | 0.00 | 100.09 |
| Murphy, Sydney, T,28252 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Parker, Jenna, A,25990 | 5847.04 | 0.00 | 3399.99 | 0.00 | 2447.05 |
| Serrano, Jerome, A,17722 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Powell, Marcus, A,20366 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Reed, Sara, T,12170 | 5908.26 | 0.00 | 3578.27 | 0.00 | 2329.99 |
| Bryant, Antonio, R,13016 | 4813.32 | 0.00 | 2443.35 | 0.00 | 2369.97 |
| Phillips, Jordan,25351 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Roberts, Katelyn,18348 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Ortega, Marc, C,22644 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Perry, Jacqueline,11670 | 100.27 | 0.00 | 0.00 | 0.00 | 100.27 |
Generated 2025-12-22 06:42:30.567 UTC