[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 72 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sai, Ivan, E,17300 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Raje, Colleen, M,19084 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Suri, Douglas,19096 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Serrano, Joanna, J,26663 | 1976.94 | 0.00 | 0.00 | 782.99 | 1193.95 |
| Raje, Lindsey,24614 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Chandra, Harold, K,17236 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Kumar, Jenny, C,23429 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Prasad, Darren,12372 | 99.03 | 0.00 | 0.00 | 0.00 | 99.03 |
| Sharma, Clayton, D,12240 | 3964.98 | 0.00 | 3399.99 | 0.00 | 564.99 |
| Dominguez, Philip,15730 | 122.96 | 0.00 | 0.00 | 0.00 | 122.96 |
| Zhu, Jamie, J,13140 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Butler, Katherine, F,26760 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Liang, Brittney, R,26182 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Williams, Nicholas, A,25809 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
Generated 2025-12-22 02:22:17.339 UTC