[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 23 > < TAKE 16 >
16 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Liu, Jessie,11106 | 8079.05 | 0.00 | 3399.99 | 2294.99 | 2384.07 |
| Pal, Jenny,15132 | 151.94 | 0.00 | 0.00 | 0.00 | 151.94 |
| Liang, Margaret,17254 | 147.48 | 0.00 | 0.00 | 0.00 | 147.48 |
| Zeng, Jon, O,14310 | 5200.66 | 0.00 | 0.00 | 2071.42 | 3129.24 |
| Hernandez, Max,18192 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Tang, Shawn,25832 | 1850.86 | 0.00 | 699.10 | 0.00 | 1151.76 |
| Raje, Misty, A,23544 | 3971.01 | 0.00 | 0.00 | 2181.56 | 1789.45 |
| Diaz, Aaron, C,18695 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Sanz, Bruce,23117 | 3931.52 | 0.00 | 0.00 | 2181.56 | 1749.96 |
| Ye, Alejandro, W,15029 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Barnes, Alexia, D,15231 | 59.48 | 0.00 | 0.00 | 0.00 | 59.48 |
| Chander, Drew, J,25111 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Flores, Noah,17256 | 4362.74 | 0.00 | 3578.27 | 0.00 | 784.47 |
| Xu, Alicia,11370 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Navarro, Albert, L,21561 | 4947.78 | 0.00 | 2443.35 | 0.00 | 2504.43 |
| Hall, Mary, R,20277 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-22 00:48:21.078 UTC