[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 61 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martin, Ricky, C,16608 | 101.57 | 0.00 | 0.00 | 0.00 | 101.57 |
| Richardson, Abigail, S,14236 | 5710.23 | 0.00 | 0.00 | 2071.42 | 3638.81 |
| Ruiz, Bruce, W,16171 | 103.86 | 0.00 | 0.00 | 0.00 | 103.86 |
| Xie, Karla,18201 | 4157.73 | 0.00 | 3578.27 | 0.00 | 579.46 |
| Hayes, Eric, A,22964 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Kumar, Tommy,17297 | 100.25 | 0.00 | 0.00 | 0.00 | 100.25 |
| Fernandez, Holly, M,12675 | 6812.77 | 0.00 | 0.00 | 2071.42 | 4741.35 |
| Raji, Wayne, A,26161 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Rana, Stefanie, K,19616 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Moreno, Roberto, R,21206 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Cai, Susan,19101 | 104.42 | 0.00 | 0.00 | 0.00 | 104.42 |
| Gomez, Kathleen, J,16158 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Travers, Jimmy, V,12674 | 6829.47 | 0.00 | 0.00 | 2071.42 | 4758.05 |
| Guo, Glenn, J,18712 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Diaz, Cheryl, A,11092 | 8110.02 | 0.00 | 3374.99 | 2341.97 | 2393.06 |
Generated 2025-12-23 11:16:06.276 UTC