[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1217 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Romero, Frank, M,15209 | 2916.56 | 0.00 | 0.00 | 2049.10 | 867.46 |
| She, Brittney, M,22942 | 3971.53 | 0.00 | 0.00 | 2181.56 | 1789.97 |
| Ramos, Briana, J,14303 | 3636.91 | 0.00 | 0.00 | 2049.10 | 1587.81 |
| She, Christine,16184 | 78.20 | 0.00 | 0.00 | 0.00 | 78.20 |
| Rai, Michele, M,26567 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| She, Tonya, L,16521 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Navarro, Jacquelyn,15465 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Vazquez, Casey, S,13132 | 6880.62 | 0.00 | 0.00 | 2049.10 | 4831.52 |
| Gomez, Danny, V,16636 | 5932.74 | 3578.27 | 0.00 | 0.00 | 2354.47 |
| Carson, Kristin, C,24459 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Yuan, Julie,22959 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Johnson, Elizabeth,11004 | 8196.01 | 3399.99 | 0.00 | 2376.96 | 2419.06 |
| Deng, Michele,21946 | 4659.80 | 0.00 | 0.00 | 2181.56 | 2478.24 |
| Ortega, Eddie,22908 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Tang, Dawn, R,16496 | 5960.23 | 3578.27 | 0.00 | 0.00 | 2381.96 |
| Gao, Bianca, C,13112 | 5717.89 | 0.00 | 0.00 | 2049.10 | 3668.79 |
| Chander, Yolanda,16519 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Shen, Dustin,27974 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Sai, Levi,16349 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Blanco, Wendy, J,19604 | 171.73 | 0.00 | 0.00 | 0.00 | 171.73 |
| Serrano, Max, E,12010 | 8203.50 | 0.00 | 3374.99 | 0.00 | 4828.51 |
| Raheem, Bethany, L,21965 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Sharma, Raul, E,16347 | 5918.50 | 3578.27 | 0.00 | 0.00 | 2340.23 |
| Martinez, Edgar, B,18741 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Chapman, Kathryn,11988 | 8078.02 | 0.00 | 3374.99 | 0.00 | 4703.03 |
| Prasad, Denise,18294 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Gao, Stacey,16662 | 4355.71 | 3578.27 | 0.00 | 777.44 | 0.00 |
| Navarro, Javier,14131 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Diaz, Ruben, A,25136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raje, Alison, J,12345 | 64.71 | 0.00 | 0.00 | 0.00 | 64.71 |
| Henderson, Xavier, K,12993 | 96.25 | 0.00 | 0.00 | 0.00 | 96.25 |
| Liang, Candice,22208 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Xu, Alan,16741 | 6056.61 | 3578.27 | 0.00 | 0.00 | 2478.34 |
| Moreno, Melody, R,11760 | 274.92 | 0.00 | 0.00 | 0.00 | 274.92 |
| Suri, Roy, M,17253 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Patterson, Melissa, E,12668 | 6839.46 | 0.00 | 0.00 | 2071.42 | 4768.04 |
| Gonzalez, Ebony,11034 | 6491.32 | 3399.99 | 0.00 | 0.00 | 3091.33 |
| Munoz, Audrey, V,12003 | 8256.50 | 0.00 | 3374.99 | 0.00 | 4881.51 |
| Liu, Autumn, J,20985 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Nara, Kelsey, A,24905 | 2195.91 | 0.00 | 0.00 | 1000.44 | 1195.47 |
| Martinez, Emmanuel, V,21370 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rai, Johnny, A,13135 | 6773.14 | 0.00 | 0.00 | 2049.10 | 4724.04 |
| Zheng, Jeffery, W,15030 | 3786.39 | 0.00 | 0.00 | 2071.42 | 1714.97 |
| Hernandez, Walter,13141 | 240.24 | 0.00 | 0.00 | 0.00 | 240.24 |
| Anand, Kelli, A,20451 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Romero, Roberto, A,18285 | 141.55 | 0.00 | 0.00 | 0.00 | 141.55 |
| Zhou, Autumn, L,25229 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Rubio, Sabrina, A,20984 | 4153.25 | 0.00 | 3578.27 | 0.00 | 574.98 |
| Romero, Renee, E,16639 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| Garcia, Edgar, A,17729 | 110.46 | 0.00 | 0.00 | 0.00 | 110.46 |
| Dominguez, Robin,16685 | 4183.23 | 0.00 | 3578.27 | 0.00 | 604.96 |
| Wang, Willie,29304 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Martin, Marc, J,11039 | 6636.58 | 0.00 | 3399.99 | 0.00 | 3236.59 |
| Rubio, Kendra,17047 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Goel, Tara, I,14347 | 2900.39 | 0.00 | 0.00 | 2071.42 | 828.97 |
| Dominguez, Theresa, L,18769 | 5304.25 | 0.00 | 3578.27 | 0.00 | 1725.98 |
| Prasad, Darren,12372 | 99.03 | 0.00 | 0.00 | 0.00 | 99.03 |
| Ma, Autumn,20994 | 4191.72 | 0.00 | 3578.27 | 0.00 | 613.45 |
| Coleman, Melanie, H,15639 | 34.57 | 0.00 | 0.00 | 0.00 | 34.57 |
| Luo, Kenneth, S,15211 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Scott, Savannah, E,16929 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
Generated 2025-12-24 05:59:47.101 UTC