[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 939 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Romero, Marie,20424 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Ross, Connor, J,20816 | 4228.72 | 0.00 | 3578.27 | 0.00 | 650.45 |
| Lin, Damien, L,23414 | 3391.03 | 0.00 | 0.00 | 2181.56 | 1209.47 |
| Lin, Rafael,14099 | 200.26 | 0.00 | 0.00 | 0.00 | 200.26 |
| Rubio, Natasha, K,13627 | 214.25 | 0.00 | 0.00 | 0.00 | 214.25 |
| Ross, Arianna, E,26774 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Diaz, Jacquelyn, K,18747 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Zheng, Vincent,18496 | 6121.71 | 0.00 | 3578.27 | 0.00 | 2543.44 |
| Nara, Jon,22006 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Munoz, Teresa, R,27712 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Collins, Jennifer,11364 | 4921.82 | 0.00 | 3374.99 | 0.00 | 1546.83 |
| Raman, Brett, L,22930 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Ruiz, Alfredo,21975 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Malhotra, Terrance, E,20223 | 187.38 | 0.00 | 0.00 | 0.00 | 187.38 |
| Diaz, Roberto, A,22202 | 4671.74 | 0.00 | 0.00 | 2181.56 | 2490.18 |
Generated 2025-12-23 17:11:04.456 UTC