[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Ruiz, Julio,11005 | 8121.33 | 3374.99 | 0.00 | 4746.34 | 0.00 |
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 4733.05 | 0.00 |
| Xu, Martha, C,16351 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Gutierrez, Jonathon, R,16529 | 4752.75 | 3578.27 | 0.00 | 1174.48 | 0.00 |
| Fernandez, Manuel, A,16514 | 4761.74 | 3578.27 | 0.00 | 1183.47 | 0.00 |
| Liang, Kelvin, L,16616 | 5915.54 | 3578.27 | 0.00 | 0.00 | 2337.27 |
| Fernandez, Brenda, L,16493 | 4197.25 | 3578.27 | 0.00 | 0.00 | 618.98 |
| Liang, Martha,16525 | 4752.75 | 3578.27 | 0.00 | 1174.48 | 0.00 |
| Holt, Krystal,16518 | 4698.76 | 3578.27 | 0.00 | 1120.49 | 0.00 |
| Huang, Eugene, L,11001 | 6383.88 | 3374.99 | 0.00 | 2419.93 | 588.96 |
| Huang, Damien,16524 | 4733.75 | 3578.27 | 0.00 | 1155.48 | 0.00 |
| Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 1179.97 | 0.00 |
| Raman, Roy,16348 | 5918.24 | 3578.27 | 0.00 | 0.00 | 2339.97 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 2412.96 | 778.62 |
| Gomez, Danny, V,16636 | 5932.74 | 3578.27 | 0.00 | 0.00 | 2354.47 |
| Thompson, Fernando,16350 | 5903.19 | 3578.27 | 0.00 | 0.00 | 2324.92 |
| Sai, Harold,11026 | 6575.79 | 3399.99 | 0.00 | 2399.47 | 776.33 |
| Sharma, Raul, E,16347 | 5918.50 | 3578.27 | 0.00 | 0.00 | 2340.23 |
| Carlson, Shannon, C,11009 | 8091.33 | 3374.99 | 0.00 | 4716.34 | 0.00 |
| Raje, Gilbert,11055 | 8168.01 | 3374.99 | 0.00 | 4793.02 | 0.00 |
| Diaz, Gloria,25270 | 1854.58 | 699.10 | 0.00 | 0.00 | 1155.48 |
| Xu, Alan,16741 | 6056.61 | 3578.27 | 0.00 | 2478.34 | 0.00 |
| Ramos, Theresa, G,11031 | 6478.60 | 3399.99 | 0.00 | 0.00 | 3078.61 |
| Rubio, Kendra,17047 | 4347.76 | 3578.27 | 0.00 | 769.49 | 0.00 |
| Jones, Emily,16659 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Sharma, Sharon, T,25294 | 1882.57 | 699.10 | 0.00 | 0.00 | 1183.47 |
| Dominguez, Wendy,11035 | 6451.31 | 3374.99 | 0.00 | 0.00 | 3076.32 |
| Shan, Mario,25271 | 1854.58 | 699.10 | 0.00 | 0.00 | 1155.48 |
| Scott, Savannah, E,16929 | 4733.75 | 3578.27 | 0.00 | 1155.48 | 0.00 |
| Lu, Rosa, A,16663 | 4471.74 | 3578.27 | 0.00 | 893.47 | 0.00 |
| Goel, Derek,17045 | 4480.73 | 3578.27 | 0.00 | 902.46 | 0.00 |
| Raman, Patricia, T,16702 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Nara, Tony, L,16713 | 6090.59 | 3578.27 | 0.00 | 2512.32 | 0.00 |
| Xie, Cristina, C,17050 | 4496.23 | 3578.27 | 0.00 | 917.96 | 0.00 |
| King, Evan,16637 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Romero, Paula, B,16691 | 4471.74 | 3578.27 | 0.00 | 893.47 | 0.00 |
| Flores, Adam, L,11044 | 6515.30 | 3374.99 | 0.00 | 0.00 | 3140.31 |
| Cox, Michelle, E,17328 | 4387.74 | 3578.27 | 0.00 | 0.00 | 809.47 |
| Zhu, Alan,17320 | 4391.74 | 3578.27 | 0.00 | 0.00 | 813.47 |
| Wilson, Zachary,25558 | 1307.06 | 699.10 | 0.00 | 0.00 | 607.96 |
| Arun, Ruth, S,17294 | 4355.71 | 3578.27 | 0.00 | 0.00 | 777.44 |
| Gao, Todd, M,11061 | 8129.02 | 3374.99 | 0.00 | 4754.03 | 0.00 |
| Gray, Stephanie,17064 | 4506.76 | 3578.27 | 0.00 | 928.49 | 0.00 |
| Wang, Trisha, V,17259 | 4404.73 | 3578.27 | 0.00 | 0.00 | 826.46 |
| Deng, Clayton, G,17285 | 6093.20 | 3578.27 | 0.00 | 2514.93 | 0.00 |
| Sharma, Terrence, N,17351 | 6117.69 | 3578.27 | 0.00 | 0.00 | 2539.42 |
| Green, Jonathan, A,17332 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Zhou, Jon, L,11060 | 8153.02 | 3399.99 | 0.00 | 4753.03 | 0.00 |
| Green, Fernando,17258 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Chander, Omar, W,17241 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Lopez, Luis, P,17334 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Raman, Michele,17233 | 4347.76 | 3578.27 | 0.00 | 769.49 | 0.00 |
| Navarro, Tyrone, K,25557 | 1262.87 | 699.10 | 0.00 | 0.00 | 563.77 |
| Flores, Noah,17256 | 4362.74 | 3578.27 | 0.00 | 0.00 | 784.47 |
| Perry, Maria, N,17728 | 4730.03 | 3578.27 | 0.00 | 1151.76 | 0.00 |
| Li, Karen, K,17921 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Butler, Jason,17510 | 4369.74 | 3578.27 | 0.00 | 0.00 | 791.47 |
| Nara, Edwin, R,11097 | 8099.03 | 3374.99 | 0.00 | 2304.98 | 2419.06 |
| Garcia, Ivan, L,17354 | 6029.57 | 3578.27 | 0.00 | 0.00 | 2451.30 |
| Jimenez, Gary, E,16609 | 344.04 | 0.00 | 0.00 | 344.04 | 0.00 |
| Sai, Ann,27339 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Andersen, Tonya, N,13527 | 4529.04 | 0.00 | 2049.10 | 0.00 | 2479.94 |
| Raje, Devon,29289 | 2433.04 | 0.00 | 0.00 | 2433.04 | 0.00 |
| Jai, Bonnie,11977 | 8212.50 | 0.00 | 3399.99 | 2350.96 | 2461.55 |
| Malhotra, Mayra, E,15577 | 143.45 | 0.00 | 0.00 | 83.97 | 59.48 |
| Munoz, Cheryl, C,13632 | 6838.46 | 0.00 | 0.00 | 2071.42 | 4767.04 |
| Sanchez, Terrance,19584 | 116.74 | 0.00 | 0.00 | 116.74 | 0.00 |
| Cooper, Victoria, S,13637 | 6777.13 | 0.00 | 0.00 | 2049.10 | 4728.03 |
| Ramos, Marie, A,14308 | 5140.40 | 0.00 | 0.00 | 2049.10 | 3091.30 |
| Perez, Ross, E,14307 | 196.26 | 0.00 | 0.00 | 163.99 | 32.27 |
| Xie, Dustin,22204 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Hu, Glenn, R,24897 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanders, Arianna, E,22859 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Roberts, Jordan,23432 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Sanchez, George, M,12680 | 6880.10 | 0.00 | 2049.10 | 2369.97 | 2461.03 |
| Patel, Monica, J,25234 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Madan, Summer, D,12347 | 6839.12 | 0.00 | 2049.10 | 2370.96 | 2419.06 |
| Zeng, Barbara,23102 | 2730.54 | 0.00 | 2181.56 | 0.00 | 548.98 |
| Chapman, Kathryn,11988 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Xu, Karl,23321 | 3060.82 | 0.00 | 0.00 | 2443.35 | 617.47 |
| Rodriguez, Pedro, L,17911 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| He, Aimee, A,11093 | 8180.00 | 3399.99 | 0.00 | 4780.01 | 0.00 |
| Ross, Adam,11099 | 8215.99 | 3399.99 | 0.00 | 4816.00 | 0.00 |
| Zhou, Louis, C,17912 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Yuan, Louis, C,18193 | 4145.54 | 3578.27 | 0.00 | 0.00 | 567.27 |
| Chander, Damien,11080 | 8204.02 | 3374.99 | 0.00 | 4829.03 | 0.00 |
| Anand, Andrés,11096 | 8063.04 | 3374.99 | 0.00 | 2294.99 | 2393.06 |
| Tang, Bridget,17730 | 4752.23 | 3578.27 | 0.00 | 1173.96 | 0.00 |
| Gill, Alberto, P,17733 | 4758.24 | 3578.27 | 0.00 | 0.00 | 1179.97 |
| Li, Lacey,17515 | 4143.26 | 3578.27 | 0.00 | 564.99 | 0.00 |
| Raje, Cristina, S,17917 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Suri, Cesar,17512 | 4170.54 | 3578.27 | 0.00 | 592.27 | 0.00 |
| Xu, Tracy, L,17916 | 4787.74 | 3578.27 | 0.00 | 0.00 | 1209.47 |
| Williams, Anna, R,17504 | 4362.74 | 3578.27 | 0.00 | 0.00 | 784.47 |
| Patel, Douglas,17927 | 4726.04 | 3578.27 | 0.00 | 0.00 | 1147.77 |
| Anderson, Blake,11076 | 8159.04 | 3399.99 | 0.00 | 4759.05 | 0.00 |
| Yang, Connor,17735 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Zeng, Micah, A,25561 | 1288.06 | 699.10 | 0.00 | 0.00 | 588.96 |
| Schmidt, Shane,17922 | 4821.72 | 3578.27 | 0.00 | 0.00 | 1243.45 |
| Griffin, Caroline,17726 | 4721.73 | 3578.27 | 0.00 | 1143.46 | 0.00 |
| Yang, Curtis,11110 | 8093.03 | 3399.99 | 0.00 | 2294.99 | 2398.05 |
| Hall, Jeremiah, M,18250 | 6058.21 | 3578.27 | 0.00 | 2479.94 | 0.00 |
| Gomez, Alfredo, C,18200 | 4150.53 | 3578.27 | 0.00 | 0.00 | 572.26 |
| Lin, Autumn, E,18272 | 6056.61 | 3578.27 | 0.00 | 2478.34 | 0.00 |
| Griffin, Rachel,18255 | 6067.20 | 3578.27 | 0.00 | 0.00 | 2488.93 |
| Yang, Heather,18275 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Jiménez, Beth, H,11120 | 8242.49 | 3374.99 | 0.00 | 2394.46 | 2473.04 |
| Chapman, Preston, O,18268 | 6102.19 | 3578.27 | 0.00 | 0.00 | 2523.92 |
| Chander, Alison,18249 | 6044.59 | 3578.27 | 0.00 | 2466.32 | 0.00 |
| Chande, Lindsay,18244 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Sharma, Jodi, N,18260 | 6035.60 | 3578.27 | 0.00 | 2457.33 | 0.00 |
| Pal, Christine, I,18242 | 6121.71 | 3578.27 | 0.00 | 2543.44 | 0.00 |
| Sun, Alvin,18252 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Li, Jaclyn,18281 | 6081.10 | 3578.27 | 0.00 | 0.00 | 2502.83 |
| Gomez, Derrick,18694 | 6035.60 | 3578.27 | 0.00 | 2457.33 | 0.00 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 8.99 | 64.97 |
| Nelson, Julia, L,11102 | 102.91 | 0.00 | 0.00 | 0.00 | 102.91 |
| Xu, Colleen,28956 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Diaz, Ricky, E,18335 | 6035.60 | 3578.27 | 0.00 | 0.00 | 2457.33 |
| Nath, Tasha, J,18487 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Phillips, Jeremy, E,18495 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Townsend, Darren,18467 | 5279.26 | 3578.27 | 0.00 | 1700.99 | 0.00 |
| Zhao, Ernest, C,18700 | 5328.23 | 3578.27 | 0.00 | 1749.96 | 0.00 |
| Black, Mindy, W,18696 | 6149.57 | 3578.27 | 0.00 | 2571.30 | 0.00 |
| Martinez, Tina, J,18461 | 4748.24 | 3578.27 | 0.00 | 0.00 | 1169.97 |
Generated 2026-07-22 11:10:13.883 UTC