[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 250 SHUFFLE SKIP 0 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Goel, Carly, C,12989 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Wang, Crystal, C,11112 | 8295.02 | 0.00 | 3374.99 | 0.00 | 4920.03 |
| Mehta, Carolyn,28205 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Ramirez, Isaiah,11905 | 8155.98 | 0.00 | 3374.99 | 0.00 | 4780.99 |
| Liu, Christy,19784 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Cai, Jessie, A,12249 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Sanz, Jésus,29313 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Blanco, Marc,24908 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Pal, Drew,11902 | 63.04 | 0.00 | 0.00 | 0.00 | 63.04 |
| Anand, Alison, J,24009 | 2746.04 | 0.00 | 0.00 | 2181.56 | 564.48 |
| Carlson, Jonathon, N,17073 | 78.97 | 0.00 | 0.00 | 0.00 | 78.97 |
| Shan, Colleen, D,15150 | 4379.08 | 0.00 | 0.00 | 2049.10 | 2329.98 |
| Goel, Ricardo, T,25961 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Liu, Alejandro, R,19555 | 6110.60 | 0.00 | 3578.27 | 0.00 | 2532.33 |
| Torres, Naomi, J,14061 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Ortega, Janet, L,11754 | 8163.53 | 0.00 | 3399.99 | 0.00 | 4763.54 |
| Kapoor, Candace,18282 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Pal, Sheena, D,21197 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Nara, Sharon,18482 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Wu, Margaret,28928 | 2473.05 | 0.00 | 0.00 | 0.00 | 2473.05 |
| Shan, Tasha,15192 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Vazquez, Marvin, K,21953 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Prasad, Arthur,14275 | 5158.37 | 0.00 | 0.00 | 2800.44 | 2357.93 |
| Arthur, Jay, R,12694 | 6785.13 | 0.00 | 0.00 | 2049.10 | 4736.03 |
| Barnes, Julia, R,21999 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Anand, Carly,25918 | 1260.58 | 0.00 | 699.10 | 0.00 | 561.48 |
| Washington, Abigail,23661 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Gao, Candice, M,17493 | 130.96 | 0.00 | 0.00 | 0.00 | 130.96 |
| Ye, Amy,11073 | 191.90 | 0.00 | 0.00 | 0.00 | 191.90 |
| Perez, Stefanie,27518 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Vazquez, Joan, B,16332 | 147.23 | 0.00 | 0.00 | 0.00 | 147.23 |
| Lu, Jeffery, B,19971 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Carlson, Mathew, A,23012 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Pal, Christine, I,18242 | 6121.71 | 0.00 | 3578.27 | 2543.44 | 0.00 |
| Suarez, Leslie, C,22955 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Chander, Andres, E,29460 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Blanco, Erik, J,29093 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Mehta, Regina,17245 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Madan, Kristopher, A,25238 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Mehta, Chelsea,22951 | 4242.31 | 0.00 | 0.00 | 2443.35 | 1798.96 |
| Ross, Brandon,14132 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Subram, Stefanie,12371 | 214.04 | 0.00 | 0.00 | 0.00 | 214.04 |
| She, Derek,15036 | 3785.08 | 0.00 | 0.00 | 2049.10 | 1735.98 |
| Goel, Carl, S,17249 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Carlson, Marc, W,17501 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Coleman, Luis, L,14230 | 5661.90 | 0.00 | 0.00 | 2049.10 | 3612.80 |
| Sanz, Arthur,27688 | 166.28 | 0.00 | 0.00 | 166.28 | 0.00 |
| Hernandez, Danny,27146 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Shen, Kelvin,22406 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Ortega, Dwayne, C,24615 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Gutierrez, Tabitha, A,21884 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Shen, Alisha, J,26438 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Madan, Johnathan, D,13626 | 6909.09 | 0.00 | 0.00 | 2049.10 | 4859.99 |
| Fernandez, Michele, M,24884 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Chandra, Dominique, H,26765 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Zhou, Colleen,23122 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Beck, Cedric, L,22403 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Zhu, Jamie, J,13140 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Navarro, Albert, L,21561 | 4947.78 | 0.00 | 2443.35 | 0.00 | 2504.43 |
| Xu, Peter, K,28204 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Hu, Leah,11994 | 8169.03 | 0.00 | 3374.99 | 0.00 | 4794.04 |
| Cai, Karen,22572 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Raje, Lacey, T,12358 | 6787.76 | 0.00 | 2071.42 | 0.00 | 4716.34 |
| Harris, Ian, W,14128 | 3836.38 | 0.00 | 0.00 | 2071.42 | 1764.96 |
| Mr., Smith, Leonard, J.,27972 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Li, Dawn, B,13962 | 40.22 | 0.00 | 0.00 | 0.00 | 40.22 |
| Alonso, Kristine,16686 | 4157.73 | 3578.27 | 0.00 | 0.00 | 579.46 |
| She, Corey, T,21214 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Prasad, Ross,28963 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| King, Evan,16637 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Black, Mindy, W,18696 | 6149.57 | 0.00 | 3578.27 | 0.00 | 2571.30 |
| Lee, Richard, I,23996 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Serrano, Marvin, E,17316 | 97.45 | 0.00 | 0.00 | 0.00 | 97.45 |
| Adams, Sydney,27367 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lopez, Mason, E,22923 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Zhu, Colin,19973 | 83.44 | 0.00 | 0.00 | 0.00 | 83.44 |
| Arun, Levi, A,11074 | 94.19 | 0.00 | 0.00 | 0.00 | 94.19 |
| Sharma, Jerry, C,13651 | 6812.12 | 0.00 | 0.00 | 2049.10 | 4763.02 |
| Ortega, Renee,18447 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Raje, Mario, S,20427 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Goel, April, C,16166 | 108.85 | 0.00 | 0.00 | 0.00 | 108.85 |
| Martin, Meghan, B,26773 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Stone, Denise,11032 | 6525.56 | 0.00 | 3374.99 | 0.00 | 3150.57 |
| Raje, Kurt,15210 | 2926.39 | 0.00 | 0.00 | 2071.42 | 854.97 |
| Parker, Timothy, C,22943 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Zhao, Heather,24596 | 4168.83 | 0.00 | 0.00 | 2443.35 | 1725.48 |
| Martin, Renee, L,17478 | 4758.24 | 0.00 | 3578.27 | 0.00 | 1179.97 |
| Rubio, Daisy, A,16181 | 170.06 | 0.00 | 0.00 | 0.00 | 170.06 |
| Martin, Ruben,22400 | 2737.82 | 0.00 | 0.00 | 2181.56 | 556.26 |
| Kumar, Deborah, K,17308 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Lopez, Toni, K,25140 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Lopez, Adriana, A,12002 | 8145.33 | 0.00 | 3374.99 | 0.00 | 4770.34 |
| Cox, Jared, E,28114 | 570.47 | 0.00 | 0.00 | 0.00 | 570.47 |
| Martinez, Stanley, Z,13668 | 114.21 | 0.00 | 0.00 | 78.98 | 35.23 |
| Lewis, Kayla,12013 | 3949.97 | 0.00 | 3399.99 | 0.00 | 549.98 |
| Srini, Joe,22180 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Navarro, Jill,22003 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Carson, Kelvin, A,11995 | 8249.01 | 0.00 | 3399.99 | 0.00 | 4849.02 |
| Deng, Carl,18284 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Travers, Jimmy, V,12674 | 6829.47 | 0.00 | 0.00 | 2071.42 | 4758.05 |
| Ortega, Alfredo, W,25958 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
| Gao, Randy,25113 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Raje, Shawn,17054 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Vazquez, Jonathon,17906 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Xu, Cedric,18198 | 4143.25 | 0.00 | 3578.27 | 0.00 | 564.98 |
| Ms., Rusek, Pearlie, J.,21945 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Huang, Mandy,18266 | 72.26 | 0.00 | 0.00 | 0.00 | 72.26 |
| Madan, Ann,21948 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Sun, Erica, P,26135 | 1967.45 | 0.00 | 0.00 | 782.99 | 1184.46 |
| Torres, Diane, M,25211 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Huang, Micah,25130 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sharma, Carl,21375 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Jay,16692 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Kapoor, Jarrod,28930 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Martin, Naomi, A,15593 | 116.26 | 0.00 | 0.00 | 0.00 | 116.26 |
| Fernandez, Carolyn, S,29302 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Roberts, Jordan,23432 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Dominguez, Roy, C,29189 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Shen, Bridget,17237 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Ramos, Kendra,24896 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Ortega, Lance, C,12354 | 6797.13 | 0.00 | 2049.10 | 0.00 | 4748.03 |
| Shen, Priscilla, A,28215 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Coleman, Paige, L,15263 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Chander, Brad, K,21382 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
Generated 2025-12-21 15:02:40.930 UTC