[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 221 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Diaz, Randall, T,29345 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Patel, Jillian,26667 | 1390.95 | 0.00 | 0.00 | 782.99 | 607.96 |
| Jai, Lacey, C,11371 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Gutierrez, Desiree,15216 | 101.74 | 0.00 | 0.00 | 0.00 | 101.74 |
| Navarro, Kristy, J,19570 | 74.94 | 0.00 | 0.00 | 0.00 | 74.94 |
| Diaz, Roberto, A,22202 | 4671.74 | 0.00 | 0.00 | 2181.56 | 2490.18 |
| Goel, April, C,16166 | 108.85 | 0.00 | 0.00 | 0.00 | 108.85 |
| Guo, Krystal, S,17381 | 188.93 | 0.00 | 0.00 | 0.00 | 188.93 |
| Rubio, Randall, M,17286 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Long, Alexis,22580 | 3051.31 | 0.00 | 0.00 | 2443.35 | 607.96 |
| Rubio, Larry,14223 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Travers, Alexa, A,24466 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Vazquez, Theresa, F,22581 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Yuan, Roger,19622 | 61.75 | 0.00 | 0.00 | 0.00 | 61.75 |
| She, Valerie, C,20226 | 6067.20 | 0.00 | 3578.27 | 0.00 | 2488.93 |
Generated 2025-12-24 05:57:46.140 UTC