[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 50 > < TAKE 6 >
6 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Miller, Richard, J,16884 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hu, Jon,25664 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Watson, Chloe, O,19293 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Thompson, Wyatt,17194 | 111.45 | 0.00 | 0.00 | 0.00 | 111.45 |
| Pal, Jaime,22139 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Hernandez, Richard, M,20383 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
Generated 2025-12-23 11:44:29.723 UTC