[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 281 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ross, Natalie, J,12916 | 261.22 | 0.00 | 0.00 | 0.00 | 261.22 |
| Jones, Natalie, A,11845 | 197.20 | 0.00 | 0.00 | 0.00 | 197.20 |
| Wilson, Chloe, A,11640 | 409.12 | 0.00 | 0.00 | 0.00 | 409.12 |
| Rodriguez, Alexandra,21642 | 2620.40 | 0.00 | 0.00 | 2071.42 | 548.98 |
| Patterson, Taylor,12147 | 271.45 | 0.00 | 0.00 | 0.00 | 271.45 |
| Anderson, Destiny,12895 | 336.65 | 0.00 | 0.00 | 0.00 | 336.65 |
| Price, Jeremy,25989 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
Generated 2025-12-22 04:43:07.443 UTC