[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Perez, Whitney,16619 | 97.58 | 0.00 | 0.00 | 67.59 | 29.99 |
| Jiménez, Deanna,28115 | 562.96 | 0.00 | 0.00 | 562.96 | 0.00 |
| Young, Marcus, A,18494 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Coleman, Brittany,15579 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Anderson, Emily, M,25220 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Zhou, Stacey, L,21374 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| He, Kelli, A,28872 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
Generated 2024-11-10 06:40:44.193 UTC