[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 749 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Luo, Julie, M,29121 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Xu, Kristen,15751 | 4446.40 | 0.00 | 0.00 | 2071.42 | 2374.98 |
| Navarro, Kristy, J,19570 | 74.94 | 0.00 | 0.00 | 0.00 | 74.94 |
| Goel, Ricardo, T,25961 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Guo, Jaclyn,13119 | 6829.45 | 0.00 | 0.00 | 2071.42 | 4758.03 |
| Hernandez, Jaime,24170 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Chavez, Clayton,21949 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Gonzalez, George, L,11942 | 4792.29 | 0.00 | 3399.99 | 614.96 | 777.34 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Dominguez, Wendy,11035 | 6451.31 | 0.00 | 3374.99 | 0.00 | 3076.32 |
| Ramos, Jaime,15720 | 70.22 | 0.00 | 0.00 | 0.00 | 70.22 |
| Liang, Darryl,26658 | 1390.95 | 0.00 | 0.00 | 1390.95 | 0.00 |
| Prasad, Edgar, E,17306 | 117.96 | 0.00 | 0.00 | 0.00 | 117.96 |
| Zeng, Louis,18903 | 4143.74 | 0.00 | 3578.27 | 565.47 | 0.00 |
| Ramos, Naomi, M,23656 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Gill, Kristy,13669 | 102.43 | 0.00 | 0.00 | 0.00 | 102.43 |
| Kapoor, Ruben, D,11109 | 8245.01 | 0.00 | 3374.99 | 2476.96 | 2393.06 |
| Subram, Cory, B,27599 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Hill, Kaylee, L,11918 | 8204.99 | 0.00 | 3399.99 | 0.00 | 4805.00 |
| Alonso, Danny, S,18217 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Martinez, Anna, J,12994 | 6855.44 | 0.00 | 0.00 | 2071.42 | 4784.02 |
| Coleman, Luis, L,14230 | 5661.90 | 0.00 | 0.00 | 2049.10 | 3612.80 |
| Nath, Cassie,24606 | 2155.92 | 0.00 | 1000.44 | 1155.48 | 0.00 |
| Sai, Ross, A,21966 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Li, Vincent, D,21207 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Chander, Damien,11080 | 8204.02 | 0.00 | 3374.99 | 2359.98 | 2469.05 |
| Wu, Aimee,16690 | 165.07 | 0.00 | 0.00 | 0.00 | 165.07 |
| Andersen, Calvin,22920 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Jai, Gregory,16342 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Zhou, Steve, C,20263 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Jai, Ethan,15217 | 41.26 | 0.00 | 0.00 | 0.00 | 41.26 |
| Serrano, Danny,24381 | 3970.52 | 0.00 | 0.00 | 2181.56 | 1788.96 |
| Romero, Desiree, J,17239 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Prasad, Clifford,15604 | 66.75 | 0.00 | 0.00 | 0.00 | 66.75 |
| Nara, Lindsay, M,25247 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Vazquez, Rodney, M,13047 | 241.93 | 0.00 | 0.00 | 0.00 | 241.93 |
| Cai, Vincent, L,11757 | 58.05 | 0.00 | 0.00 | 0.00 | 58.05 |
| Chande, Jaclyn, S,18698 | 5314.25 | 0.00 | 3578.27 | 1735.98 | 0.00 |
| Suri, Phillip,17914 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Serrano, Alberto, L,15800 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Hernandez, Bruce,17919 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Walker, Seth, E,27689 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Sullivan, Summer, E,21181 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Subram, Tabitha, C,17511 | 4150.53 | 0.00 | 3578.27 | 572.26 | 0.00 |
| Lin, Rafael,14099 | 200.26 | 0.00 | 0.00 | 0.00 | 200.26 |
| Arun, Candace, J,21393 | 4925.17 | 0.00 | 2443.35 | 0.00 | 2481.82 |
| Pal, Gilbert,27744 | 643.95 | 0.00 | 0.00 | 643.95 | 0.00 |
| Dominguez, Andy, L,14126 | 135.55 | 0.00 | 0.00 | 0.00 | 135.55 |
| Flores, Antonio, D,14259 | 3630.93 | 0.00 | 0.00 | 2049.10 | 1581.83 |
| Moreno, Danny, M,29458 | 811.32 | 0.00 | 0.00 | 0.00 | 811.32 |
| Torres, Mathew, L,18900 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Raji, Colleen,27707 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Lal, Alicia,15734 | 4426.41 | 0.00 | 0.00 | 2071.42 | 2354.99 |
| Lopez, Kristopher, L,21560 | 4702.39 | 0.00 | 0.00 | 2181.56 | 2520.83 |
| Gill, Diana,25710 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Malhotra, Stanley, H,11453 | 8176.98 | 0.00 | 3374.99 | 2382.93 | 2419.06 |
| Ortega, Briana, L,29346 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Sanchez, Henry,26968 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Li, Warren, R,29185 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Luo, Lacey,24175 | 2743.04 | 0.00 | 0.00 | 2181.56 | 561.48 |
| King, Kevin, W,21402 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Li, Jaclyn,18281 | 6081.10 | 0.00 | 3578.27 | 0.00 | 2502.83 |
Generated 2025-12-23 09:17:47.321 UTC