[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE SKIP 1500
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Diaz, Hunter, S,27242 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Price, Mariah, C,20745 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Mitchell, Evan, R,24731 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Robinson, Joseph,28141 | 94.48 | 0.00 | 0.00 | 94.48 | 0.00 |
| Miller, Destiny,25157 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Butler, Jonathan,26180 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ward, Jade, D,14661 | 195.02 | 0.00 | 0.00 | 74.98 | 120.04 |
Generated 2024-09-20 07:34:46.850 UTC