[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 74 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Townsend, Darren,18467 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Gill, Jay,27975 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Moreno, Felicia, A,12987 | 6759.47 | 0.00 | 0.00 | 2071.42 | 4688.05 |
| Chavez, Kurt, C,23563 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Liang, Gilbert,12242 | 3948.97 | 0.00 | 3374.99 | 0.00 | 573.98 |
| Perez, Brenda,11899 | 8189.50 | 0.00 | 3374.99 | 0.00 | 4814.51 |
| Shen, Karl, M,15151 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Zeng, Claudia, M,16696 | 4506.76 | 3578.27 | 0.00 | 0.00 | 928.49 |
| Deng, Jaime, R,21968 | 4722.88 | 0.00 | 0.00 | 2181.56 | 2541.32 |
| Cook, Kaylee,11904 | 8214.50 | 0.00 | 3399.99 | 0.00 | 4814.51 |
| Zhou, Laura, D,12683 | 6801.45 | 0.00 | 0.00 | 2071.42 | 4730.03 |
| Gonzalez, Ruth,12693 | 6820.47 | 0.00 | 0.00 | 2071.42 | 4749.05 |
| Arthur, Kristi, W,16675 | 4385.03 | 3578.27 | 0.00 | 0.00 | 806.76 |
| Ramos, Roy, A,24482 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
Generated 2025-12-22 03:06:43.783 UTC