[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 45 < SKIP 125 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chavez, Kurt, C,23563 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Gonzalez, Dominique, J,27976 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Fernandez, Arthur, J,22399 | 2785.05 | 0.00 | 0.00 | 2181.56 | 603.49 |
| Sanchez, Michele,23543 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Sai, Kari, E,14231 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Sanchez, Lydia, S,12579 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Vance, Monica, G,12338 | 8265.00 | 0.00 | 3374.99 | 0.00 | 4890.01 |
| Srini, Manuel,24168 | 2790.52 | 0.00 | 0.00 | 2181.56 | 608.96 |
| Guo, Clarence,20265 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Serrano, Tyrone,11360 | 5025.80 | 0.00 | 3399.99 | 0.00 | 1625.81 |
| Goel, Carl, S,17249 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Li, Colin, J,18445 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Alonso, Meghan, A,24457 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Kumar, Tamara, A,25222 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Sullivan, Dominic, M,22840 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Yuan, Grant, C,24909 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Sara, Jarrod,20626 | 6038.56 | 0.00 | 3578.27 | 0.00 | 2460.29 |
| Dominguez, Stacy, S,19105 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Sara, Candace,21380 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Wu, Margaret,28928 | 2473.05 | 0.00 | 0.00 | 0.00 | 2473.05 |
| Mehta, Carolyn,28205 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Suarez, Linda,16665 | 81.81 | 0.00 | 0.00 | 0.00 | 81.81 |
| Moyer, Mario,23420 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Arthur, Regina, A,19089 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Lal, Franklin, A,14101 | 3679.90 | 0.00 | 0.00 | 2049.10 | 1630.80 |
| Moreno, Leslie, C,11114 | 122.89 | 0.00 | 0.00 | 0.00 | 122.89 |
| Shan, Brad, H,19605 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Lopez, Savannah,25709 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Martinez, Pamela, A,13529 | 4614.86 | 0.00 | 0.00 | 2071.42 | 2543.44 |
| Patterson, Kyle,11448 | 8132.01 | 0.00 | 3374.99 | 2318.96 | 2438.06 |
| Russell, Stephanie,20255 | 75.48 | 0.00 | 0.00 | 0.00 | 75.48 |
| Goel, Gilbert,15596 | 4460.04 | 0.00 | 0.00 | 2049.10 | 2410.94 |
| Weber, Levi, A,13120 | 205.39 | 0.00 | 0.00 | 0.00 | 205.39 |
| Chander, Keith, A,24174 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Xu, Mindy,20246 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Smith, Tina, K,19793 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Gonzalez, Jay, C,14238 | 5642.90 | 0.00 | 0.00 | 2049.10 | 3593.80 |
| Thompson, Michael, M,26148 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Prasad, Harold,19608 | 68.45 | 0.00 | 0.00 | 0.00 | 68.45 |
| Malhotra, Tina, C,27584 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Ye, Leah,11077 | 8169.03 | 0.00 | 3374.99 | 2374.98 | 2419.06 |
| She, Corey, T,21214 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 0.00 | 782.99 | 578.46 |
| Ferrier, Mathew,23426 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Allen, Devin,15806 | 102.85 | 0.00 | 0.00 | 0.00 | 102.85 |
| Gao, Erica, R,19087 | 47.20 | 0.00 | 0.00 | 36.96 | 10.24 |
| Cai, Jeffery, A,15582 | 2907.56 | 0.00 | 0.00 | 2049.10 | 858.46 |
| Blue, Richard,12006 | 144.74 | 0.00 | 0.00 | 0.00 | 144.74 |
| Mr., Rodgers, Scott, M.,20211 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Ramos, Lance, S,28949 | 2473.05 | 0.00 | 0.00 | 0.00 | 2473.05 |
| Liu, Randy,15015 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Rubio, Derrick, P,23525 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Smith, Christian, L,14313 | 222.44 | 0.00 | 0.00 | 0.00 | 222.44 |
| Luo, Shaun,27864 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Serrano, Dwayne,16695 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Diaz, Devin, D,15829 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Shan, Johnny,11999 | 7043.27 | 0.00 | 3399.99 | 0.00 | 3643.28 |
| Carlson, Eddie,23347 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hernandez, Audrey,18290 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Lin, Jorge,27593 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Martin, Felicia, L,15018 | 112.46 | 0.00 | 0.00 | 0.00 | 112.46 |
| Patterson, Ashley, R,18736 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
Generated 2025-12-23 11:59:20.185 UTC