[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 63 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chander, Drew, J,25111 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Chandra, Jarrod,24171 | 3006.31 | 0.00 | 0.00 | 2443.35 | 562.96 |
| Gonzalez, Joel, A,15043 | 3846.89 | 0.00 | 0.00 | 2071.42 | 1775.47 |
| Luo, Lacey,24175 | 2743.04 | 0.00 | 0.00 | 2181.56 | 561.48 |
| Shen, Leonard, J,24271 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Browning, Jay, M,24251 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Gomez, Teresa, D,24164 | 2760.02 | 0.00 | 0.00 | 2181.56 | 578.46 |
| Tang, Drew, W,15178 | 4445.06 | 0.00 | 0.00 | 2049.10 | 2395.96 |
| Gutierrez, Micheal, S,27299 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Perez, Bryant, L,15042 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Kumar, Derek, M,15135 | 4381.39 | 0.00 | 0.00 | 2071.42 | 2309.97 |
| Blanco, Robyn, R,24179 | 3052.31 | 0.00 | 0.00 | 2443.35 | 608.96 |
| Li, Edwin,26967 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Moreno, Dana, D,15033 | 3797.40 | 0.00 | 0.00 | 2071.42 | 1725.98 |
| Mr., Shen, Alan,24257 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Srini, Manuel,24168 | 2790.52 | 0.00 | 0.00 | 2181.56 | 608.96 |
| Sara, Clifford, M,24178 | 2810.53 | 0.00 | 0.00 | 2181.56 | 628.97 |
| Sanchez, Andre,15595 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Ye, Alvin, B,15575 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Dominguez, Josue, R,15600 | 4590.40 | 0.00 | 0.00 | 2071.42 | 2518.98 |
| Shan, Shaun,24274 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Malhotra, Kristopher, L,15265 | 2897.57 | 0.00 | 0.00 | 2049.10 | 848.47 |
| Gao, Cara, B,15642 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Srini, Carolyn, S,27371 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Alvarez, Kristy,15588 | 4486.07 | 0.00 | 0.00 | 2049.10 | 2436.97 |
| Alonso, Meghan, A,24457 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| She, Roger, L,15724 | 4359.07 | 0.00 | 0.00 | 2049.10 | 2309.97 |
| Diaz, Carolyn, C,24360 | 3626.82 | 0.00 | 0.00 | 2443.35 | 1183.47 |
| Suri, Shane, L,25126 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Deng, Priscilla, M,25127 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Arun, Troy, P,15221 | 4447.87 | 0.00 | 0.00 | 2071.42 | 2376.45 |
Generated 2025-11-06 17:42:49.156 UTC