[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 969 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Luo, Shaun,27864 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Scott, Timothy,19631 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Rodriguez, Ruben,12589 | 2665.06 | 0.00 | 0.00 | 2049.10 | 615.96 |
| Vance, Marco,13124 | 87.93 | 0.00 | 0.00 | 0.00 | 87.93 |
| Martinez, Bruce, D,18452 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Andersen, Kate,14237 | 90.25 | 0.00 | 0.00 | 0.00 | 90.25 |
| Lee, Destiny,17058 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Saunders, Jillian,21178 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Rubio, Randall, M,17286 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Lal, Kurt, R,14015 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Raje, April, R,18744 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Navarro, Carolyn,11069 | 8104.05 | 0.00 | 3399.99 | 2319.99 | 2384.07 |
| Carson, Terrence,11356 | 5069.29 | 0.00 | 3374.99 | 0.00 | 1694.30 |
| Ramos, Kristine,17479 | 163.40 | 0.00 | 0.00 | 0.00 | 163.40 |
Generated 2025-12-22 02:09:41.825 UTC