[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 50 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Huang, Jake,19589 | 95.26 | 0.00 | 0.00 | 0.00 | 95.26 |
| Deng, Peter, A,24006 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Dominguez, Sabrina, M,28116 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Martinez, Ivan,27872 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Shen, Nichole,12999 | 6840.46 | 0.00 | 0.00 | 2071.42 | 4769.04 |
| Liu, Dawn, C,21960 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Zhang, Louis, K,20227 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
Generated 2025-12-21 20:47:50.932 UTC