[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 44 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xu, Rafael, A,21885 | 4641.85 | 0.00 | 0.00 | 2181.56 | 2460.29 |
| Raheem, Bethany, L,21965 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Cai, Tiffany,18204 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Vazquez, Carolyn,23650 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Moreno, Roberto, R,21206 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Ashe, Maurice,20430 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Liu, Jessie,11106 | 8079.05 | 0.00 | 3399.99 | 2294.99 | 2384.07 |
| Cai, Candice,26747 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Travers, Danny,12587 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Garcia, Brandy,26028 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Gomez, Derrick,18694 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Alvarez, Marvin,23651 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
Generated 2025-12-22 01:23:26.092 UTC