[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 40 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanz, Renee, L,14319 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Nath, Alvin, R,29301 | 134.98 | 0.00 | 0.00 | 0.00 | 134.98 |
| Torres, Bailey,18259 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Liu, Clarence,19797 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Kumar, Lacey,13960 | 6871.74 | 0.00 | 0.00 | 2071.42 | 4800.32 |
| Jai, Drew, M,21562 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Munoz, Craig, V,13076 | 6862.14 | 0.00 | 0.00 | 2049.10 | 4813.04 |
| Chander, Misty,17333 | 80.94 | 0.00 | 0.00 | 0.00 | 80.94 |
| Shen, Gilbert, C,12005 | 6984.81 | 0.00 | 3399.99 | 0.00 | 3584.82 |
| Raji, Andres, E,13955 | 6888.44 | 0.00 | 0.00 | 2071.42 | 4817.02 |
| Clark, Sydney,16610 | 67.58 | 0.00 | 0.00 | 0.00 | 67.58 |
| Sun, Erica, P,26135 | 1967.45 | 0.00 | 0.00 | 782.99 | 1184.46 |
Generated 2025-12-22 00:09:15.935 UTC