[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 46 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rai, Melvin, J,24604 | 3681.80 | 0.00 | 0.00 | 3681.80 | 0.00 |
| Pal, Sheena, D,21197 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
| Wang, Roger, P,24605 | 3627.81 | 0.00 | 0.00 | 3627.81 | 0.00 |
| Jimenez, Neil,22151 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Barnes, Isabella, J,25239 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Coleman, Paige, L,15263 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Serrano, Darren,29196 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Raman, Sergio,27866 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Gutierrez, Erika,17227 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Yang, Alan, L,15605 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Perez, Brett, M,28313 | 647.94 | 0.00 | 0.00 | 0.00 | 647.94 |
| Becker, Keith, P,27515 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Holt, Alisha,28350 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
Generated 2025-12-21 19:44:53.401 UTC