[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 515 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| She, Latoya, A,11750 | 8148.02 | 0.00 | 3399.99 | 0.00 | 4748.03 |
| Chow, Warren, L,24305 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Murphy, Seth, A,25704 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Arthur, Johnathan,18730 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Jones, Destiny,15171 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Hernandez, Marvin, A,23077 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Zheng, Christy,17069 | 4426.74 | 3578.27 | 0.00 | 0.00 | 848.47 |
| Romero, Erika,19958 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| Mehta, Chelsea,22951 | 4242.31 | 0.00 | 0.00 | 4242.31 | 0.00 |
| Romero, Joy, D,24886 | 80.47 | 0.00 | 0.00 | 0.00 | 80.47 |
| Xu, Randy, S,11969 | 8173.02 | 0.00 | 3399.99 | 2319.99 | 2453.04 |
| Ramos, Albert, E,27716 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Smith, Thomas,17068 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Srini, Roy,24888 | 2174.92 | 0.00 | 1000.44 | 0.00 | 1174.48 |
| Zhang, Brittney, W,19975 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
Generated 2025-11-06 12:20:38.863 UTC