[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 42 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wu, Micah,17246 | 4380.04 | 0.00 | 3578.27 | 0.00 | 801.77 |
| Alvarez, Marc, B,18221 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Yang, Roger, A,28108 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Martin, Craig, M,25012 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Garcia, Dominique,16528 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| She, Marshall, D,18707 | 122.76 | 0.00 | 0.00 | 0.00 | 122.76 |
| Madan, Geoffrey, M,15241 | 51.91 | 0.00 | 0.00 | 0.00 | 51.91 |
| Kapoor, Brandy, I,15236 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Yuan, Grant, C,24909 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Chen, Crystal, M,26566 | 2016.95 | 0.00 | 0.00 | 782.99 | 1233.96 |
| Goel, Bradley,15803 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Kapoor, Bryant,22946 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
Generated 2025-12-23 07:15:08.364 UTC