[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 |
|---|---|---|---|---|---|
| Wu, Clarence, L,13115 | 6779.42 | 0.00 | 2049.10 | 0.00 | 4730.32 |
| Diaz, Briana,13131 | 6737.15 | 0.00 | 2049.10 | 0.00 | 4688.05 |
| Xu, Karl,23321 | 3060.82 | 0.00 | 0.00 | 2443.35 | 617.47 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 8.99 | 64.97 |
| Powell, Lucas, T,18278 | 158.95 | 0.00 | 0.00 | 123.96 | 34.99 |
| Zhou, Autumn, L,25229 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Rodriguez, Jarrod,13636 | 6831.76 | 0.00 | 0.00 | 2071.42 | 4760.34 |
| Shan, Peter,24280 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Zeng, Ernest, M,12992 | 158.51 | 0.00 | 0.00 | 36.27 | 122.24 |
| Xu, Colleen,28956 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Evans, Carlos, J,23538 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Gonzales, Victoria,11751 | 8215.02 | 3399.99 | 0.00 | 2430.96 | 2384.07 |
| Raji, Michele,15183 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Fernandez, Holly, M,12675 | 6812.77 | 0.00 | 2071.42 | 2357.28 | 2384.07 |
| Suarez, Ricky,29066 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Chander, Devon,24612 | 2152.20 | 0.00 | 1000.44 | 1151.76 | 0.00 |
| Raje, Lindsey,24614 | 2120.93 | 0.00 | 1000.44 | 1120.49 | 0.00 |
| Andersen, Roger,24469 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Yuan, Terry, R,13646 | 6843.60 | 0.00 | 0.00 | 2049.10 | 4794.50 |
| Beck, April,14302 | 5140.73 | 0.00 | 0.00 | 2071.42 | 3069.31 |
| Carlson, Armando,17484 | 126.96 | 0.00 | 0.00 | 126.96 | 0.00 |
| Liang, Louis, M,12706 | 6851.41 | 0.00 | 2071.42 | 2331.95 | 2448.04 |
| Mehta, Ann, M,14518 | 126.95 | 0.00 | 0.00 | 63.97 | 62.98 |
| Gomez, Marvin, C,28479 | 831.33 | 0.00 | 0.00 | 831.33 | 0.00 |
| Lin, Kelvin, A,13075 | 6843.94 | 0.00 | 2071.42 | 2294.99 | 2477.53 |
| Shan, Sheena, J,21565 | 48.98 | 0.00 | 0.00 | 48.98 | 0.00 |
| Andersen, Ashlee, J,11059 | 116.93 | 0.00 | 0.00 | 116.93 | 0.00 |
| Xu, Casey, J,13158 | 221.91 | 0.00 | 0.00 | 64.97 | 156.94 |
| Moore, Natalie, W,18273 | 6104.21 | 3578.27 | 0.00 | 2525.94 | 0.00 |
| Prasad, Dominic, D,19962 | 46.75 | 0.00 | 0.00 | 16.27 | 30.48 |
| Ward, Jessica,15587 | 4423.38 | 0.00 | 0.00 | 2071.42 | 2351.96 |
| Prasad, Darren,12372 | 99.03 | 0.00 | 0.00 | 96.74 | 2.29 |
| Rodriguez, Arthur,15438 | 3788.68 | 0.00 | 0.00 | 2071.42 | 1717.26 |
| Andersen, Jenny,20259 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Lal, Devon, L,15237 | 66.26 | 0.00 | 0.00 | 34.99 | 31.27 |
| Zheng, Arturo, C,11467 | 47.92 | 0.00 | 0.00 | 0.00 | 47.92 |
| Andersen, Maurice,15206 | 98.96 | 0.00 | 0.00 | 63.97 | 34.99 |
| Goel, Christine, A,21231 | 3936.54 | 0.00 | 2181.56 | 0.00 | 1754.98 |
| Xu, Clarence,21877 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Cai, Jessie, A,12249 | 114.96 | 0.00 | 0.00 | 49.99 | 64.97 |
| Kapoor, Kaitlin, M,17072 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Moreno, Meghan, J,15152 | 4464.57 | 0.00 | 0.00 | 2049.10 | 2415.47 |
| Gao, Cara, B,15642 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Raji, Terry,15597 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Martin, Ethan, M,13998 | 245.25 | 0.00 | 0.00 | 97.97 | 147.28 |
| Ortega, Lawrence,14685 | 146.74 | 0.00 | 0.00 | 0.00 | 146.74 |
| Pal, Alison,13042 | 84.47 | 0.00 | 0.00 | 24.99 | 59.48 |
| Suri, Jillian, L,15180 | 4466.39 | 0.00 | 0.00 | 2071.42 | 2394.97 |
| Miller, Edward,11368 | 5106.24 | 3374.99 | 0.00 | 0.00 | 1731.25 |
| Lal, Kurt, R,14015 | 59.98 | 0.00 | 0.00 | 24.99 | 34.99 |
| Chander, Latoya, C,26138 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Zeng, Micah, A,25561 | 1288.06 | 699.10 | 0.00 | 0.00 | 588.96 |
| Ramos, Jay, D,21882 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Perry, Gavin, M,12578 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
| Zheng, Dawn, F,19579 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Navarro, Tyrone, K,25557 | 1262.87 | 699.10 | 0.00 | 0.00 | 563.77 |
| Stone, Brenda, J,12697 | 296.19 | 0.00 | 0.00 | 0.00 | 296.19 |
| Raji, Omar,15643 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Ortega, Linda, C,11756 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Goel, Tonya,29123 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Lu, Crystal, A,15145 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Sanchez, Candace, L,21567 | 4973.28 | 0.00 | 2443.35 | 0.00 | 2529.93 |
| Srini, Deanna,15182 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Bradley, Diane, A,15140 | 62.27 | 0.00 | 0.00 | 27.28 | 34.99 |
| Malhotra, Harold,15227 | 4469.56 | 0.00 | 0.00 | 2049.10 | 2420.46 |
| Nara, Cedric, M,21875 | 4921.69 | 0.00 | 2443.35 | 0.00 | 2478.34 |
| Xu, Alisha,14100 | 226.26 | 0.00 | 0.00 | 159.00 | 67.26 |
| Xu, Shawna,23419 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rubio, Nelson,26433 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
| Zheng, Kristen, J,24463 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Ortega, Meghan, E,22004 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
| Perez, Virginia, A,27494 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Sanz, Victor,17295 | 4392.74 | 3578.27 | 0.00 | 0.00 | 814.47 |
| Andersen, Rafael, E,12691 | 247.46 | 0.00 | 0.00 | 49.48 | 197.98 |
| Deng, Johnny,21409 | 35.00 | 0.00 | 0.00 | 35.00 | 0.00 |
| Raji, Derek, D,19591 | 63.42 | 0.00 | 0.00 | 63.42 | 0.00 |
| Xie, Mitchell, B,20993 | 4262.04 | 0.00 | 3578.27 | 683.77 | 0.00 |
| Anand, Alícia, J,29113 | 2453.04 | 0.00 | 0.00 | 2453.04 | 0.00 |
| Hu, Leah,11994 | 8169.03 | 0.00 | 3374.99 | 2374.98 | 2419.06 |
| Yuan, Grant, C,24909 | 2149.91 | 0.00 | 1000.44 | 1149.47 | 0.00 |
| Yang, Kevin, F,20605 | 84.96 | 0.00 | 0.00 | 84.96 | 0.00 |
| Martin, Byron, E,25217 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Sanz, Kellie,16708 | 4406.74 | 3578.27 | 0.00 | 828.47 | 0.00 |
| Suri, Douglas,19096 | 6090.59 | 0.00 | 3578.27 | 2512.32 | 0.00 |
| Martinez, Ann,12009 | 8195.50 | 0.00 | 3399.99 | 2376.45 | 2419.06 |
| Zhang, Tiffany, R,17318 | 43.97 | 0.00 | 0.00 | 43.97 | 0.00 |
| Becker, Julie,13614 | 114.21 | 0.00 | 0.00 | 86.93 | 27.28 |
| Gonzalez, Cynthia,15787 | 167.93 | 0.00 | 0.00 | 103.96 | 63.97 |
| Blanco, Kari,19627 | 41.75 | 0.00 | 0.00 | 41.75 | 0.00 |
| Perez, Martin,19577 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Ramos, Gloria, A,21365 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Raji, Grant, R,16185 | 28.98 | 0.00 | 0.00 | 28.98 | 0.00 |
| She, Kristin, L,19961 | 97.97 | 0.00 | 0.00 | 8.99 | 88.98 |
| Suri, Jarrod, E,12004 | 8114.04 | 0.00 | 3374.99 | 2319.99 | 2419.06 |
| Griffin, Olivia,21208 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Pal, Terrence, M,13037 | 59.98 | 0.00 | 0.00 | 34.99 | 24.99 |
| Li, Justin,14124 | 57.59 | 0.00 | 0.00 | 32.60 | 24.99 |
| Serrano, Rebekah,14130 | 3814.06 | 0.00 | 0.00 | 3814.06 | 0.00 |
| Gomez, Erik, T,29180 | 2452.04 | 0.00 | 0.00 | 2452.04 | 0.00 |
| Ye, Claudia, J,19102 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Goel, Mario, J,12360 | 6750.48 | 0.00 | 2071.42 | 2294.99 | 2384.07 |
| Chande, Ashlee, N,23096 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Raje, Arturo, C,14228 | 49.99 | 0.00 | 0.00 | 49.99 | 0.00 |
| Wu, Ernest, L,11147 | 8195.50 | 3374.99 | 0.00 | 2376.96 | 2443.55 |
| Pal, Donna, S,23572 | 3617.83 | 0.00 | 0.00 | 3617.83 | 0.00 |
| Zhang, Barbara,16338 | 169.43 | 0.00 | 0.00 | 169.43 | 0.00 |
| Perez, Rachael, D,26762 | 133.49 | 0.00 | 0.00 | 133.49 | 0.00 |
| Andersen, Deborah,19610 | 118.94 | 0.00 | 0.00 | 68.97 | 49.97 |
| Moreno, Robin,19563 | 5333.25 | 0.00 | 3578.27 | 1754.98 | 0.00 |
| Lu, Micah,22174 | 3007.83 | 0.00 | 2443.35 | 564.48 | 0.00 |
| Munoz, Gloria, L,19789 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Turner, Lucas,22948 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Ramos, Byron,14306 | 3653.23 | 0.00 | 0.00 | 2910.88 | 742.35 |
| Vazquez, Marc, H,24362 | 3600.77 | 0.00 | 0.00 | 3600.77 | 0.00 |
| McDonald, Brent,14068 | 77.27 | 0.00 | 0.00 | 27.28 | 49.99 |
| Wu, Lisa,26158 | 94.48 | 0.00 | 0.00 | 94.48 | 0.00 |
| Zhou, Warren,19791 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Diaz, Devin, D,15829 | 187.98 | 0.00 | 0.00 | 187.98 | 0.00 |
| Foster, Luke,15137 | 161.94 | 0.00 | 0.00 | 161.94 | 0.00 |
| Hall, Mary, R,20277 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Xu, Kara, E,22212 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
| Fernandez, Cassandra, C,14134 | 3835.07 | 0.00 | 0.00 | 3835.07 | 0.00 |
| Serrano, Hector, K,28308 | 588.96 | 0.00 | 0.00 | 588.96 | 0.00 |
| Vance, George, R,12038 | 66.76 | 0.00 | 0.00 | 2.29 | 64.47 |
| Serrano, Jacquelyn,21963 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
Generated 2026-07-21 19:38:59.007 UTC