[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 47 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Coleman, Julian, L,24760 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Perry, Emily, F,26649 | 4433.17 | 0.00 | 0.00 | 2049.10 | 2384.07 |
| Carter, Gabrielle, B,16596 | 4486.54 | 0.00 | 0.00 | 2181.56 | 2304.98 |
| Suri, Raymond, H,17416 | 2370.96 | 0.00 | 0.00 | 0.00 | 2370.96 |
| Gao, Claudia,13690 | 7162.08 | 0.00 | 3578.27 | 0.00 | 3583.81 |
| Allen, Jenna, T,23484 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Romero, Kristine, W,16306 | 29.26 | 0.00 | 0.00 | 0.00 | 29.26 |
Generated 2025-12-23 07:27:41.722 UTC