[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 16 < SKIP 3500 > < TAKE 500 >
21 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Liang, Steve,14317 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Zhou, Brent,15434 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Yang, Alejandro, M,22176 | 100.46 | 0.00 | 0.00 | 0.00 | 100.46 |
| Lal, Bradley,13156 | 2663.69 | 0.00 | 0.00 | 2071.42 | 592.27 |
| Zhang, Ronnie,16656 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 |
| Scott, Savannah, E,16929 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Allen, Mary,21203 | 4633.90 | 0.00 | 2181.56 | 0.00 | 2452.34 |
| Kumar, Chad,11095 | 8158.01 | 0.00 | 3374.99 | 2363.96 | 2419.06 |
| Malhotra, Veronica, J,25922 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Arun, Troy, P,15221 | 4447.87 | 0.00 | 0.00 | 2071.42 | 2376.45 |
| Alonso, Brandi,17061 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Goel, Karl,18705 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Hernandez, Julio, J,23078 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Rana, Carla, K,19593 | 5306.54 | 0.00 | 3578.27 | 0.00 | 1728.27 |
| Hayes, Alexis,13048 | 190.23 | 0.00 | 0.00 | 0.00 | 190.23 |
| Chande, Kelli, C,22933 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Rana, Stefanie, K,19616 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Raji, Jaime, L,15037 | 3856.38 | 0.00 | 0.00 | 2071.42 | 1784.96 |
| Ramos, Briana, J,14303 | 3636.91 | 0.00 | 0.00 | 2049.10 | 1587.81 |
| Liu, Krystal, D,13526 | 4549.76 | 0.00 | 0.00 | 2071.42 | 2478.34 |
| Lopez, Jay, A,19965 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
Generated 2025-12-24 06:26:58.234 UTC