[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 96 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanz, Mathew, L,14557 | 63.97 | 0.00 | 0.00 | 63.97 | 0.00 |
| Yuan, Kelsey, D,13034 | 94.71 | 0.00 | 0.00 | 0.00 | 94.71 |
| Gutierrez, Francis,25245 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Sanz, Eddie, A,19580 | 173.93 | 0.00 | 0.00 | 0.00 | 173.93 |
| Serrano, Max, E,12010 | 8203.50 | 0.00 | 3374.99 | 0.00 | 4828.51 |
| Zhou, Arturo, F,27910 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Ashe, Brad,25228 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Serrano, Lori,17066 | 105.75 | 0.00 | 0.00 | 0.00 | 105.75 |
| Liu, Omar, L,12252 | 3938.95 | 0.00 | 3374.99 | 0.00 | 563.96 |
| Raji, Carly, L,23346 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ramos, Gloria, A,21365 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sanz, Ross,11455 | 8142.03 | 0.00 | 3374.99 | 2319.99 | 2447.05 |
| Wu, Bianca, F,28485 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Chande, Willie, B,16163 | 2641.39 | 0.00 | 0.00 | 2071.42 | 569.97 |
Generated 2025-12-21 16:04:29.758 UTC