[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 691 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Blanco, Jésus, E,20448 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Hernandez, Marvin, A,23077 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Thompson, Justin,22954 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Rubio, Derrick, P,23525 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Suri, Evelyn, A,21223 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Hernandez, Isaac,25813 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Raman, Ronald, M,17077 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Kumar, Jenny, C,23429 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Lopez, Rachael,23425 | 3951.52 | 0.00 | 0.00 | 2181.56 | 1769.96 |
| Navarro, Bruce, D,17353 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Taylor, Devin, L,12248 | 3939.98 | 0.00 | 3399.99 | 0.00 | 539.99 |
| Martinez, Frederick,11991 | 8128.02 | 0.00 | 3374.99 | 0.00 | 4753.03 |
| Raman, Candace, M,11766 | 8280.48 | 0.00 | 3399.99 | 0.00 | 4880.49 |
| Gomez, Kendra, J,23320 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Raji, Christy,15584 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Cook, Kaylee,11904 | 8214.50 | 0.00 | 3399.99 | 0.00 | 4814.51 |
| Sai, Harold,11026 | 6575.79 | 3399.99 | 0.00 | 0.00 | 3175.80 |
| Martinez, Clifford,23087 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Guo, Glenn, J,18712 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Ashe, Deanna,20284 | 5328.23 | 0.00 | 3578.27 | 0.00 | 1749.96 |
| Sharma, Donna,11998 | 6962.10 | 0.00 | 3374.99 | 0.00 | 3587.11 |
| Tang, Jenny, E,14210 | 5621.24 | 0.00 | 0.00 | 2071.42 | 3549.82 |
| Henderson, Angela, T,11898 | 8179.03 | 0.00 | 3399.99 | 0.00 | 4779.04 |
| Zhang, Jon,28111 | 865.31 | 0.00 | 0.00 | 0.00 | 865.31 |
| Sai, Emmanuel,23417 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Green, Alex, K,20317 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Kapoor, Brandy, I,15236 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Ashe, Kathryn,16168 | 80.11 | 0.00 | 0.00 | 0.00 | 80.11 |
| Stewart, Ariana,16743 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Xu, Rafael, N,21195 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Navarro, Albert, L,21561 | 4947.78 | 0.00 | 0.00 | 2443.35 | 2504.43 |
| Suarez, Melody, H,14276 | 5259.36 | 0.00 | 0.00 | 2049.10 | 3210.26 |
| Xie, Derek,14287 | 5141.43 | 0.00 | 0.00 | 2049.10 | 3092.33 |
| Ramos, Joe,12353 | 6765.46 | 0.00 | 0.00 | 2071.42 | 4694.04 |
| Malhotra, Janelle,26425 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Subram, Kristi, N,15025 | 128.94 | 0.00 | 0.00 | 0.00 | 128.94 |
| Xu, Wesley, K,29182 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gill, Gina, F,24177 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Thomas, Sydney,14322 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Subram, Meredith, S,14261 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Guo, Alisha, P,23571 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Blanco, Wendy, J,19604 | 171.73 | 0.00 | 0.00 | 0.00 | 171.73 |
| Carter, Amber, E,16679 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Wang, Jaclyn, M,17063 | 100.25 | 0.00 | 0.00 | 0.00 | 100.25 |
| Moreno, Melody, R,11760 | 274.92 | 0.00 | 0.00 | 0.00 | 274.92 |
| Ortega, Monique, C,12355 | 6818.11 | 0.00 | 2049.10 | 0.00 | 4769.01 |
| She, Tonya, L,16521 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Subram, Arthur, E,27350 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Zhang, Tiffany, R,17318 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Mehta, Marie, L,29102 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Kumar, Keith, M,25224 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ma, Autumn,20994 | 4191.72 | 0.00 | 3578.27 | 0.00 | 613.45 |
| Raman, Raymond, R,19588 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Martin, Natasha, N,27490 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| He, Jake, M,24472 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Ms., Sanchez, Madalena, J.,13020 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Simmons, Jordyn,16494 | 5961.20 | 3578.27 | 0.00 | 0.00 | 2382.93 |
| Johnson, Brianna, J,17319 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gonzalez, Virginia,11929 | 4965.78 | 0.00 | 3374.99 | 0.00 | 1590.79 |
| Munoz, Cheryl, C,13632 | 6838.46 | 0.00 | 0.00 | 2071.42 | 4767.04 |
| Moore, Devin, J,16167 | 102.57 | 0.00 | 0.00 | 0.00 | 102.57 |
| Zhang, Ronnie,16656 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Gill, Lee, L,27694 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Ruiz, Carolyn, M,27863 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Sai, Levi,16349 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Moreno, Roberto, R,21206 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Tang, Colin,14323 | 5222.02 | 0.00 | 0.00 | 2071.42 | 3150.60 |
| Zeng, Krystal, A,25814 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Gonzalez, Jay, C,14238 | 5642.90 | 0.00 | 0.00 | 2049.10 | 3593.80 |
| Ortega, Lance, C,12354 | 6797.13 | 0.00 | 2049.10 | 0.00 | 4748.03 |
| Serrano, Dwayne,16695 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Shen, Karla, E,22925 | 134.93 | 0.00 | 0.00 | 0.00 | 134.93 |
| Zeng, Amy,24242 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Alonso, Lance, I,14057 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Hernandez, Jessie, A,24172 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Chande, Willie, B,16163 | 2641.39 | 0.00 | 0.00 | 2071.42 | 569.97 |
| Romero, Renee, E,16639 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Gonzalez, George, L,11942 | 4792.29 | 0.00 | 3399.99 | 614.96 | 777.34 |
| Munoz, Theresa, M,13953 | 6840.75 | 0.00 | 0.00 | 2071.42 | 4769.33 |
| Hu, Alejandro,13125 | 138.54 | 0.00 | 0.00 | 0.00 | 138.54 |
| Sanz, Rodney,16926 | 44.95 | 0.00 | 0.00 | 0.00 | 44.95 |
| Sullivan, Ruth,27723 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Alvarez, Adrienne, L,17067 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Henderson, Marcus, D,15212 | 68.96 | 0.00 | 0.00 | 0.00 | 68.96 |
| Alonso, Armando, M,13647 | 6793.15 | 0.00 | 0.00 | 2049.10 | 4744.05 |
| Prasad, Francisco,16628 | 187.58 | 0.00 | 0.00 | 0.00 | 187.58 |
| Alonso, Jimmy, T,18280 | 126.56 | 0.00 | 0.00 | 0.00 | 126.56 |
| Rubio, Daisy, A,16181 | 170.06 | 0.00 | 0.00 | 0.00 | 170.06 |
| Zhou, Gilbert,24475 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Saunders, Brandy,11946 | 4697.31 | 0.00 | 3399.99 | 0.00 | 1297.32 |
| Vazquez, Joan, B,16332 | 147.23 | 0.00 | 0.00 | 0.00 | 147.23 |
| Raje, April, R,18744 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Thompson, Fernando,16350 | 5903.19 | 3578.27 | 0.00 | 0.00 | 2324.92 |
| Dominguez, Kristi, M,13644 | 6864.46 | 0.00 | 0.00 | 2071.42 | 4793.04 |
| Zhao, Bianca,13971 | 6772.13 | 0.00 | 0.00 | 2049.10 | 4723.03 |
| Yuan, Darrell,18271 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Van, Brett,26166 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Travers, Danny,12587 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Schmidt, Joe, M,22905 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Serrano, Neil, L,17076 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Hernandez, Ross,14677 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Suarez, Gina,20248 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Deng, Kurt, D,13635 | 215.74 | 0.00 | 0.00 | 0.00 | 215.74 |
| Weber, Levi, A,13120 | 205.39 | 0.00 | 0.00 | 0.00 | 205.39 |
| Chen, Jake,22845 | 4633.90 | 0.00 | 0.00 | 2181.56 | 2452.34 |
| Collins, Jennifer,11364 | 4921.82 | 0.00 | 3374.99 | 0.00 | 1546.83 |
| Lal, Bradley,13156 | 2663.69 | 0.00 | 0.00 | 2071.42 | 592.27 |
| Arthur, Carla,16710 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Zheng, Jenny, R,11947 | 4747.30 | 0.00 | 3374.99 | 0.00 | 1372.31 |
| Diaz, Roberto, A,22202 | 4671.74 | 0.00 | 0.00 | 2181.56 | 2490.18 |
| Shan, Gregory,20614 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Navarro, Eddie, C,24504 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Moore, Olivia, A,25231 | 2189.90 | 0.00 | 0.00 | 1000.44 | 1189.46 |
| Dominguez, Rebekah,27877 | 1228.83 | 0.00 | 0.00 | 0.00 | 1228.83 |
| Alonso, Darren,27501 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Zhao, Jorge,16711 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| Vance, George, R,12038 | 66.76 | 0.00 | 0.00 | 0.00 | 66.76 |
| Muñoz, Pedro, A,23433 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Romero, Gina,14234 | 5687.72 | 0.00 | 0.00 | 2071.42 | 3616.30 |
| Goel, Marshall, M,27691 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Suri, Allen,21553 | 4666.50 | 0.00 | 0.00 | 2181.56 | 2484.94 |
| Clark, Joshua, A,26137 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Xu, Tasha, E,11948 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
Generated 2026-01-04 05:40:35.999 UTC