[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 29 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| She, Jeffery, M,27149 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Li, Jaclyn,18281 | 6081.10 | 0.00 | 3578.27 | 0.00 | 2502.83 |
| Raman, Sergio,27866 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Rogers, Anna,21201 | 4921.69 | 0.00 | 2443.35 | 0.00 | 2478.34 |
| Xu, Alisha,14100 | 226.26 | 0.00 | 0.00 | 0.00 | 226.26 |
| Chande, Warren,17307 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| Martin, Gerald, K,17284 | 90.25 | 0.00 | 0.00 | 31.27 | 58.98 |
| Lopez, Stanley, M,28962 | 2477.53 | 0.00 | 0.00 | 0.00 | 2477.53 |
| Huang, Omar, C,14232 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Jai, Carl,27597 | 564.21 | 0.00 | 0.00 | 0.00 | 564.21 |
| Vazquez, Kristine, M,17736 | 4742.74 | 0.00 | 3578.27 | 0.00 | 1164.47 |
| Lopez, Donald, A,26740 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Dominguez, Rebekah,27877 | 1228.83 | 0.00 | 0.00 | 0.00 | 1228.83 |
| Cai, Trisha,18265 | 64.98 | 0.00 | 0.00 | 0.00 | 64.98 |
| Hernandez, Jaime,24170 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 0.00 | 782.99 | 578.46 |
| Raman, Roy,16348 | 5918.24 | 3578.27 | 0.00 | 0.00 | 2339.97 |
| Li, Elijah,16740 | 6099.10 | 3578.27 | 0.00 | 0.00 | 2520.83 |
| Nara, Devon, C,21964 | 103.49 | 0.00 | 0.00 | 0.00 | 103.49 |
| Long, Mariah, C,16730 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Sanchez, Nancy, L,22207 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Li, Alvin,26764 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Romero, Latasha,14220 | 5696.19 | 0.00 | 0.00 | 2071.42 | 3624.77 |
| Allen, Logan,15812 | 81.25 | 0.00 | 0.00 | 0.00 | 81.25 |
| Wu, Bianca, F,28485 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Mehta, Deanna, P,17280 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Hernandez, Mallory,29091 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Chow, Shannon,18444 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Nara, Gregory,26651 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Shen, Corey,26739 | 61.97 | 0.00 | 0.00 | 0.00 | 61.97 |
| Chen, Louis, J,17059 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Wu, Marshall, J,15590 | 4440.05 | 0.00 | 0.00 | 2049.10 | 2390.95 |
| Luo, Barbara,27978 | 29.48 | 0.00 | 0.00 | 29.48 | 0.00 |
| Sun, Christy,25218 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Suarez, Leslie, C,22955 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ma, Todd,19581 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Huang, Sandra, C,16523 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Garcia, Levi, G,21232 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Romero, Jessie,25030 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Patel, Abby,16029 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Zhou, Jon, L,11060 | 8153.02 | 0.00 | 3399.99 | 2319.99 | 2433.04 |
| Gutierrez, Pedro, S,15224 | 71.92 | 0.00 | 0.00 | 0.00 | 71.92 |
| Prasad, Preston, C,20812 | 4127.25 | 0.00 | 3578.27 | 0.00 | 548.98 |
| Carlson, Ebony,13959 | 6858.42 | 0.00 | 0.00 | 2049.10 | 4809.32 |
| Chander, Tonya,15794 | 113.97 | 0.00 | 0.00 | 0.00 | 113.97 |
| Romero, Erika,19958 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| Serrano, Reginald, J,13025 | 2690.40 | 0.00 | 0.00 | 2071.42 | 618.98 |
| Sharma, Dustin, M,18484 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Browning, Janet,19979 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Lopez, Adriana, A,12002 | 8145.33 | 0.00 | 3374.99 | 0.00 | 4770.34 |
| Raje, Casey, A,14686 | 203.46 | 0.00 | 0.00 | 0.00 | 203.46 |
| Srini, Cindy, E,26026 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Deng, Willie, J,27876 | 1214.85 | 0.00 | 0.00 | 0.00 | 1214.85 |
| Powell, Kaitlyn,19598 | 5310.53 | 0.00 | 3578.27 | 0.00 | 1732.26 |
| Navarro, Mathew, A,19673 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Lu, Krystal,17049 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
Generated 2025-12-21 17:12:21.772 UTC