[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1281 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ashe, Tara, J,19093 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Guo, Ernest,25717 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Campbell, Seth,18716 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Pal, Christy, R,18739 | 5371.74 | 0.00 | 3578.27 | 0.00 | 1793.47 |
| Alonso, Gary, C,18767 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Parker, Evan, R,18729 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Rivera, Steven, T,19083 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Richardson, Katelyn,18930 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Ortega, Janet, L,11754 | 8163.53 | 0.00 | 3399.99 | 0.00 | 4763.54 |
| Kumar, Kenneth,11472 | 8165.82 | 0.00 | 3399.99 | 0.00 | 4765.83 |
| She, Rosa,18931 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Hernandez, Darren, A,18709 | 6098.54 | 0.00 | 3578.27 | 0.00 | 2520.27 |
| Chen, Steve, R,18902 | 4186.23 | 0.00 | 3578.27 | 607.96 | 0.00 |
| Sun, Candice, A,19568 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Nara, Priscilla,18907 | 4167.23 | 0.00 | 3578.27 | 588.96 | 0.00 |
Generated 2025-12-24 06:10:34.162 UTC