[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 76 > < TAKE 48 >
48 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zeng, Louis,18903 | 4143.74 | 0.00 | 3578.27 | 565.47 | 0.00 |
| Nath, Keith,19617 | 61.75 | 0.00 | 0.00 | 0.00 | 61.75 |
| Alonso, Danny, S,18217 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Serrano, Darren,29196 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Alexander, Alyssa, M,17282 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Sun, Leah,17734 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Lal, Darrell,19953 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Jai, Melvin, M,27722 | 564.21 | 0.00 | 0.00 | 0.00 | 564.21 |
| Smith, Arthur,18240 | 6098.58 | 0.00 | 3578.27 | 2520.31 | 0.00 |
| Xie, Derek,14287 | 5141.43 | 0.00 | 0.00 | 2049.10 | 3092.33 |
| She, Tamara, M,14224 | 5621.22 | 0.00 | 0.00 | 2049.10 | 3572.12 |
| Romero, Max, C,29316 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Campbell, Devin,23653 | 3975.03 | 0.00 | 0.00 | 2181.56 | 1793.47 |
| Rodriguez, Pedro, L,17911 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Goel, Gilbert,15596 | 4460.04 | 0.00 | 0.00 | 2049.10 | 2410.94 |
| Andersen, Jodi,26766 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Collins, Jennifer,11364 | 4921.82 | 0.00 | 3374.99 | 0.00 | 1546.83 |
| Alonso, Joanna, M,27862 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Rai, Brendan, A,21569 | 4960.16 | 0.00 | 0.00 | 2443.35 | 2516.81 |
| Johnsen, Jerry,26670 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lu, Martha, R,21255 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Vazquez, Carolyn,23650 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Arthur, Johnathan,18730 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Tang, Drew, W,15178 | 4445.06 | 0.00 | 0.00 | 2049.10 | 2395.96 |
| Chande, Tonya,11992 | 8123.03 | 0.00 | 3399.99 | 0.00 | 4723.04 |
| Xu, Colin,15790 | 2668.38 | 0.00 | 0.00 | 2071.42 | 596.96 |
| Luo, Colin, L,21210 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Navarro, Casey,19795 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Blanco, Lee, M,16660 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Malhotra, Brett, E,18731 | 6054.06 | 0.00 | 3578.27 | 0.00 | 2475.79 |
| Shen, Cedric,22209 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Sharma, Tracy,17731 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Cox, Nicole, V,22950 | 3917.54 | 0.00 | 0.00 | 3917.54 | 0.00 |
| Vazquez, Andy,19620 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Sharma, Cedric, A,14060 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Mehta, Cindy, A,21943 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Sanchez, Patrick, W,24382 | 143.78 | 0.00 | 0.00 | 0.00 | 143.78 |
| Fernandez, Ronald,28939 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Ms., Schultz, Barbara, R.,15811 | 71.16 | 0.00 | 0.00 | 0.00 | 71.16 |
| Martin, Beth, K,23317 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Goel, Christine, A,21231 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Raje, Ashlee, E,16658 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Chander, Julie, E,18763 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Sai, Evelyn,20415 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Liu, Warren,15014 | 3860.87 | 0.00 | 0.00 | 2071.42 | 1789.45 |
| Alonso, Casey, E,23422 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Gonzalez, Marco,27598 | 556.26 | 0.00 | 0.00 | 0.00 | 556.26 |
| Suri, Carmen, E,24250 | 2738.49 | 0.00 | 0.00 | 2181.56 | 556.93 |
Generated 2025-12-23 05:11:28.229 UTC