[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 23 < SKIP 250 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Patterson, Kyle,11448 | 8132.01 | 0.00 | 3374.99 | 2318.96 | 2438.06 |
| Rana, Jermaine, S,28927 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Martinez, Emma,16734 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Chande, Alvin, W,24893 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Xu, Alicia,11370 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Navarro, Lori,21182 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Martin, Jésus,28324 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Suri, Carmen, E,24250 | 2738.49 | 0.00 | 0.00 | 2181.56 | 556.93 |
| Kumar, Bridget,15802 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Ramos, Byron,14306 | 3653.23 | 0.00 | 0.00 | 2071.42 | 1581.81 |
| Ma, Jeffery,18264 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Bell, Isabella,27698 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Jiménez, Daisy,21944 | 4713.89 | 0.00 | 0.00 | 2181.56 | 2532.33 |
| Malhotra, Geoffrey, W,18298 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Blanco, Wendy, J,19604 | 171.73 | 0.00 | 0.00 | 0.00 | 171.73 |
| Rubio, Beth,20240 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Zeng, Tiffany, B,21890 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Zhao, Heather,24596 | 4168.83 | 0.00 | 0.00 | 2443.35 | 1725.48 |
| Lewis, Jasmine,13964 | 6806.45 | 0.00 | 0.00 | 2071.42 | 4735.03 |
| Andersen, Nina,18338 | 6124.58 | 0.00 | 3578.27 | 0.00 | 2546.31 |
| Anand, Bradley,19626 | 39.46 | 0.00 | 0.00 | 0.00 | 39.46 |
| Ma, Louis,21879 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Li, Alvin,26764 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Garcia, Troy, M,29290 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Deng, Russell, J,20314 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Gomez, Danny, V,16636 | 5932.74 | 3578.27 | 0.00 | 0.00 | 2354.47 |
| Andersen, Karl, M,23105 | 3361.53 | 0.00 | 0.00 | 3361.53 | 0.00 |
| Vazquez, Carolyn,23650 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raje, Shawn,17054 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Suri, Kari,25266 | 57.98 | 0.00 | 0.00 | 0.00 | 57.98 |
| Travers, Danny,12587 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| West, Colleen, C,13128 | 6817.14 | 0.00 | 0.00 | 2049.10 | 4768.04 |
| Shen, Mitchell, M,22904 | 4759.99 | 0.00 | 0.00 | 2181.56 | 2578.43 |
| Gutierrez, Micheal, S,27299 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Cai, Karen,22572 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Turner, Savannah, E,23430 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhang, Cara,12351 | 117.97 | 0.00 | 0.00 | 0.00 | 117.97 |
| Nath, Rafael,23533 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Navarro, Jaime, T,27690 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Luo, Barbara,27978 | 29.48 | 0.00 | 0.00 | 29.48 | 0.00 |
| Patel, Virginia, R,11366 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Alonso, Meredith, M,20621 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| She, Valerie, C,20226 | 6067.20 | 0.00 | 3578.27 | 0.00 | 2488.93 |
| Bhat, Yolanda,15225 | 4401.41 | 0.00 | 0.00 | 2071.42 | 2329.99 |
| Martin, Randall, B,19560 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Harris, Thomas,24002 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| West, Nathan,24370 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Suri, Phillip,17914 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Li, Lacey,17515 | 4143.26 | 0.00 | 3578.27 | 0.00 | 564.99 |
| Watson, Adrian, K,13641 | 144.74 | 0.00 | 0.00 | 0.00 | 144.74 |
| Martinez, Abby,29333 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Flores, Antonio, D,14259 | 3630.93 | 0.00 | 0.00 | 2049.10 | 1581.83 |
| Vazquez, Bruce, P,20417 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Rivera, Devin, J,25109 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lu, Ronnie,19950 | 6098.54 | 0.00 | 3578.27 | 0.00 | 2520.27 |
| Ashe, Marshall,28932 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Gutierrez, Pedro, S,15224 | 71.92 | 0.00 | 0.00 | 0.00 | 71.92 |
| Ferrier, Linda, D,13149 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Simpson, Sharon, L,25123 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Black, Rafael,11966 | 55.76 | 0.00 | 0.00 | 0.00 | 55.76 |
| Andersen, Nicolas, A,27594 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Powell, Aaron,25241 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Munoz, Sheila,27488 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Long, Isabelle, W,23104 | 3490.03 | 0.00 | 0.00 | 3490.03 | 0.00 |
| Perez, Carmen, C,13139 | 6854.45 | 0.00 | 0.00 | 2071.42 | 4783.03 |
| Rodriguez, Jonathan, J,13046 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Gill, Hector, M,26187 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Sun, Mandy, L,16694 | 78.20 | 0.00 | 0.00 | 0.00 | 78.20 |
| Munoz, Gary, D,20230 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Gonzalez, Michele, D,18491 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Prasad, Arthur,14275 | 5158.37 | 0.00 | 0.00 | 2800.44 | 2357.93 |
| Johnston, Joanna, L,17296 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Ye, Gilbert,29344 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Flores, Miranda,17243 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Hill, James, S,29317 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Xu, Julie,18301 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Raje, Casey, A,14686 | 203.46 | 0.00 | 0.00 | 0.00 | 203.46 |
| Zhang, Jon,28111 | 865.31 | 0.00 | 0.00 | 0.00 | 865.31 |
| Kelly, Emma, A,15646 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Butler, Austin, W,18293 | 74.24 | 0.00 | 0.00 | 74.24 | 0.00 |
| Moreno, Deanna,28941 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Lopez, Jay, A,19965 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Lal, Kate,21557 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Ma, Christy,15020 | 40.26 | 0.00 | 0.00 | 0.00 | 40.26 |
| Andersen, Willie, M,27970 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Guo, Ernest,25717 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Bailey, Destiny, C,22941 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Rogers, Seth, R,14318 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Cai, Amy,24920 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Luo, Nina,27495 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Pal, Lacey, K,26571 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Becker, Kara,21167 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Wang, Martha, D,24272 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Garcia, Dominique,16528 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Mehta, Carolyn,28205 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Rai, Rafael, H,18715 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Li, Barbara,15788 | 4443.38 | 0.00 | 0.00 | 2071.42 | 2371.96 |
| Sharma, Jodi, N,18260 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Rodriguez, Frederick, S,24458 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Dominguez, Jimmy,21959 | 4702.39 | 0.00 | 0.00 | 2181.56 | 2520.83 |
| Goel, Yolanda, M,26435 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Torres, Kristy, M,13035 | 2638.06 | 0.00 | 0.00 | 2049.10 | 588.96 |
| Alexander, Hailey, C,19666 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Alonso, Gary, C,18767 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Sai, Rachael,11912 | 8095.32 | 0.00 | 3374.99 | 0.00 | 4720.33 |
| Malhotra, Douglas, L,22960 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hayes, Eric, A,22964 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Ortega, Joanna,17909 | 4761.74 | 0.00 | 3578.27 | 0.00 | 1183.47 |
| Garcia, Charles, M,20250 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Kapoor, Candace,18282 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Flores, Katherine,21180 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Carson, Mitchell,13623 | 99.20 | 0.00 | 0.00 | 0.00 | 99.20 |
| Zeng, Cara,20444 | 6085.59 | 0.00 | 3578.27 | 0.00 | 2507.32 |
| Perez, Martin,19577 | 6037.89 | 0.00 | 3578.27 | 0.00 | 2459.62 |
| Kapoor, Denise, M,18725 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Lal, Leonard,26160 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Luo, Nichole, A,29296 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| She, Keith, L,26563 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Brown, Cameron, D,13041 | 153.95 | 0.00 | 0.00 | 0.00 | 153.95 |
| Ramos, Leslie,15733 | 4443.55 | 0.00 | 0.00 | 2049.10 | 2394.45 |
| Shen, Devon, G,27358 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Goel, Carl, S,17249 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Zhou, Warren,19791 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Yuan, Willie,23421 | 4208.31 | 0.00 | 0.00 | 2443.35 | 1764.96 |
Generated 2025-12-23 06:05:41.532 UTC