[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 23 < SKIP 312 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Kumar, Colin,29188 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Nara, Willie,24460 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Vazquez, Anne,16027 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Madan, Patricia, L,22988 | 4194.33 | 0.00 | 0.00 | 2443.35 | 1750.98 |
| Arthur, Regina, A,19089 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Martin, Reginald,14054 | 210.77 | 0.00 | 0.00 | 0.00 | 210.77 |
| Smith, Kristi, M,21962 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Mehta, Mayra,12998 | 5694.90 | 0.00 | 0.00 | 2049.10 | 3645.80 |
| Gray, Jeremiah,23331 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Xu, Willie, C,13160 | 6839.46 | 0.00 | 0.00 | 2071.42 | 4768.04 |
| Prasad, Henry, M,24364 | 3965.52 | 0.00 | 0.00 | 2181.56 | 1783.96 |
| Lin, Jeffery, J,27347 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Sanz, Ross,11455 | 8142.03 | 0.00 | 3374.99 | 2319.99 | 2447.05 |
| Arun, Gerald,25940 | 1277.56 | 0.00 | 699.10 | 0.00 | 578.46 |
| Li, Margaret,15753 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Goel, Carl, S,17249 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Raji, Sheena, J,18213 | 6070.59 | 0.00 | 3578.27 | 2492.32 | 0.00 |
| Serrano, Gloria, G,21556 | 4930.68 | 0.00 | 2443.35 | 0.00 | 2487.33 |
| Ramos, Paula, W,21376 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhao, Colin, D,24241 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Li, Warren, R,29185 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Vazquez, Danny, J,26033 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Pal, Christy, R,18739 | 5371.74 | 0.00 | 3578.27 | 0.00 | 1793.47 |
| Sara, Phillip, R,25116 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gomez, Gary,15640 | 34.57 | 0.00 | 0.00 | 2.29 | 32.28 |
| Evans, Jonathan, D,15185 | 4393.70 | 0.00 | 0.00 | 2071.42 | 2322.28 |
| Guo, Leah, R,19562 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Vazquez, Neil, K,28719 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Davis, Morgan, J,27359 | 1344.47 | 0.00 | 0.00 | 782.99 | 561.48 |
| Suri, Patricia, E,15436 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Serrano, Danny,24381 | 3970.52 | 0.00 | 0.00 | 2181.56 | 1788.96 |
| Ye, Vincent,13013 | 256.24 | 0.00 | 0.00 | 0.00 | 256.24 |
| Griffin, Caroline,17726 | 4721.73 | 0.00 | 3578.27 | 0.00 | 1143.46 |
| Sanchez, Bryant, C,13113 | 6832.41 | 0.00 | 0.00 | 2071.42 | 4760.99 |
| Subram, Cory, B,27599 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Sanz, Lance,22573 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Green, Fernando,17258 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Garcia, Ivan, L,17354 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Chen, Jon,26920 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Hernandez, Tabitha, L,19603 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Long, Megan, J,15791 | 42.26 | 0.00 | 0.00 | 0.00 | 42.26 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Lu, Jaclyn, D,11047 | 6582.33 | 3399.99 | 0.00 | 0.00 | 3182.34 |
| Zimmerman, Tiffany, E,23325 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Munoz, Tanya,23436 | 3950.52 | 0.00 | 0.00 | 2181.56 | 1768.96 |
| Ramos, Diane, L,18300 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Deng, Deborah,23324 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Collins, James, E,26742 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Srini, Kristopher, A,23997 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Mehta, Carolyn,28205 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Hernandez, Marvin, A,23077 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Vazquez, Joe, C,20418 | 4207.24 | 0.00 | 3578.27 | 0.00 | 628.97 |
| Coleman, Paige, L,15263 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Rodriguez, Heidi, L,25120 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Prasad, Carmen, L,18928 | 6095.08 | 0.00 | 3578.27 | 0.00 | 2516.81 |
| Subram, Nancy, C,29291 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Zheng, Arturo, C,11467 | 47.92 | 0.00 | 0.00 | 0.00 | 47.92 |
| Gao, Jon, C,11456 | 8224.46 | 0.00 | 3399.99 | 2391.43 | 2433.04 |
| Raje, Alison, J,12345 | 64.71 | 0.00 | 0.00 | 0.00 | 64.71 |
| Gonzales, Lucas,29463 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Sanchez, Troy, H,25559 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Yuan, Cassie, J,24453 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Sanz, Jésus,29313 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Xu, Kathryn,25210 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Madan, Brandy, A,27687 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Liu, Jenny,16165 | 81.81 | 0.00 | 0.00 | 0.00 | 81.81 |
| Madan, Rachael, R,16486 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Raman, Candace, M,11766 | 8280.48 | 0.00 | 3399.99 | 0.00 | 4880.49 |
| Anderson, Emily, M,25220 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Martin, Arthur, L,28943 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Andersen, Mitchell, H,25026 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Serrano, Joy, L,14069 | 173.94 | 0.00 | 0.00 | 0.00 | 173.94 |
| Navarro, Bruce, D,17353 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Jiménez, Brandi,24378 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Chander, Kelvin, E,27879 | 1313.34 | 0.00 | 0.00 | 0.00 | 1313.34 |
| Guo, Louis, D,15764 | 4413.39 | 0.00 | 0.00 | 2071.42 | 2341.97 |
| Ward, Shelby,26132 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Zheng, Kristen, J,24463 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Guo, Glenn, J,18712 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Raje, Lindsay, L,20613 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Gill, Joanna,26186 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Nara, Grant,12995 | 6850.58 | 0.00 | 0.00 | 2049.10 | 4801.48 |
| Wang, Roger, P,24605 | 3627.81 | 0.00 | 0.00 | 3627.81 | 0.00 |
| Wang, Martha, D,24272 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Alvarez, Adrienne, L,17067 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Navarro, Marc,16346 | 37.55 | 0.00 | 0.00 | 0.00 | 37.55 |
| Rana, Molly,21554 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Gao, Jake, A,19955 | 173.45 | 0.00 | 0.00 | 0.00 | 173.45 |
| Diaz, Cheryl, A,11092 | 8110.02 | 0.00 | 3374.99 | 2341.97 | 2393.06 |
| Rai, Tasha, L,24301 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Li, Crystal, L,14325 | 5152.70 | 0.00 | 0.00 | 2049.10 | 3103.60 |
| Johnson, Chloe, L,20617 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Russell, Jonathan,18896 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Diaz, Felicia, J,15026 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Andersen, Nicolas, A,27594 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hernandez, Javier, A,16156 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Sai, Evelyn,20415 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Rivera, Jada,21970 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Jai, Melvin, M,27722 | 564.21 | 0.00 | 0.00 | 0.00 | 564.21 |
| Huang, Amy, C,12244 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Beck, Bonnie, A,29097 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Sanz, Jimmy,25810 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Suri, Arthur,26190 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Perez, Rachael, D,26762 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Gill, Kristy,13669 | 102.43 | 0.00 | 0.00 | 0.00 | 102.43 |
| Ye, Christy,14219 | 5744.22 | 0.00 | 0.00 | 2071.42 | 3672.80 |
| Lin, Damien, L,23414 | 3391.03 | 0.00 | 0.00 | 2181.56 | 1209.47 |
| Chapman, Jodi, L,22966 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| White, Kayla,26424 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Nara, Tonya, C,17251 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Zhao, Shannon,19807 | 35.47 | 0.00 | 0.00 | 0.00 | 35.47 |
| Chen, Tiffany, A,23348 | 4167.31 | 0.00 | 0.00 | 2443.35 | 1723.96 |
| Moreno, Janet, L,15592 | 59.98 | 0.00 | 0.00 | 24.99 | 34.99 |
| Perez, Patricia,25022 | 1564.92 | 0.00 | 0.00 | 1000.44 | 564.48 |
| Fernandez, Ross, R,11763 | 76.65 | 0.00 | 0.00 | 24.49 | 52.16 |
| Chandra, Andre, L,25262 | 35.72 | 0.00 | 0.00 | 0.00 | 35.72 |
| Kumar, Alejandro,14055 | 5177.40 | 0.00 | 0.00 | 2049.10 | 3128.30 |
| Dominguez, Roberto, A,26917 | 1339.25 | 0.00 | 0.00 | 782.99 | 556.26 |
| Prasad, Denise,18294 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| He, Jake, M,24472 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Evans, Adam, H,25820 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Cox, Nicole, V,22950 | 3917.54 | 0.00 | 0.00 | 3917.54 | 0.00 |
| Edwards, Carlos,16680 | 104.86 | 0.00 | 0.00 | 0.00 | 104.86 |
| Yuan, Sharon,12008 | 55.76 | 0.00 | 0.00 | 0.00 | 55.76 |
Generated 2025-12-24 06:06:22.992 UTC