[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 531 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Srini, Darren, P,15591 | 4346.38 | 0.00 | 0.00 | 2049.10 | 2297.28 |
| Andersen, Gilbert, T,27353 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Gill, Javier,15645 | 3785.08 | 0.00 | 0.00 | 2049.10 | 1735.98 |
| Rai, Calvin,15229 | 2833.57 | 0.00 | 0.00 | 2049.10 | 784.47 |
| Kapoor, Cesar, J,24302 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Prasad, Ebony,24368 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Gutierrez, Kristine, G,25133 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Chen, Clayton, A,15219 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Subram, Troy, R,19607 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Hernandez, Ebony, S,23574 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Hu, Lacey,19948 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Hernandez, Jill, L,13003 | 230.25 | 0.00 | 0.00 | 6.28 | 223.97 |
| Smith, Tina, K,19793 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Hill, Kaylee, L,11918 | 8204.99 | 0.00 | 3399.99 | 0.00 | 4805.00 |
| Zeng, Alisha, A,15727 | 134.46 | 0.00 | 0.00 | 0.00 | 134.46 |
| Sanz, Nelson, M,14056 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Henderson, Alexia, M,15717 | 4411.37 | 0.00 | 0.00 | 2049.10 | 2362.27 |
| Moreno, Lori, M,15226 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Vazquez, Marc, H,24362 | 3600.77 | 0.00 | 0.00 | 2443.35 | 1157.42 |
| Nara, Willie,24460 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Raji, Terry,15597 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Serrano, Danny,24381 | 3970.52 | 0.00 | 0.00 | 2181.56 | 1788.96 |
| Raje, Carly, J,15576 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Wu, Marshall, J,15590 | 4440.05 | 0.00 | 0.00 | 2049.10 | 2390.95 |
| Serrano, Beth,24304 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Luo, Melvin,24366 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Suri, Marie,24281 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Blanco, Victor,15586 | 4469.37 | 0.00 | 0.00 | 2071.42 | 2397.95 |
| He, Gilbert,15589 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Diaz, Megan, A,24303 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Chander, Roger,25214 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Cai, Jeffery, A,15582 | 2907.56 | 0.00 | 0.00 | 2049.10 | 858.46 |
| Anand, Chad,24484 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Patel, Whitney, F,24468 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Goel, Dawn,23535 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wang, Rosa, I,11993 | 8131.32 | 0.00 | 3374.99 | 0.00 | 4756.33 |
| Ramos, Diane, L,18300 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Rana, Ross,25240 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Zeng, Brittney, K,13670 | 178.45 | 0.00 | 0.00 | 24.49 | 153.96 |
| Beck, Derek,17322 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Hernandez, Ross,14677 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Ramos, Michele, J,19574 | 96.74 | 0.00 | 0.00 | 0.00 | 96.74 |
| Liang, Louis, M,12706 | 6851.41 | 0.00 | 0.00 | 2071.42 | 4779.99 |
| Guo, Cedric, R,27487 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Serrano, Alberto, L,15800 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Munoz, Sheila,27488 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Mr., Schmidt, Steve,15789 | 4486.07 | 0.00 | 0.00 | 2049.10 | 2436.97 |
| Travers, Alexa, A,24466 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Shan, Thomas, N,27483 | 1382.46 | 0.00 | 0.00 | 782.99 | 599.47 |
| Zheng, Barbara,27493 | 1353.46 | 0.00 | 0.00 | 782.99 | 570.47 |
| Ruiz, Marie, J,27498 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Zhou, Ernest, P,15792 | 2645.40 | 0.00 | 0.00 | 2071.42 | 573.98 |
| Guo, Rosa, M,24474 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Gomez, Kathleen, J,16158 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Yuan, Alicia,25225 | 2129.92 | 0.00 | 0.00 | 1000.44 | 1129.48 |
| Zheng, Kristen, J,24463 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Lal, Gabriel,27473 | 1398.46 | 0.00 | 0.00 | 782.99 | 615.47 |
| Li, Margaret,15753 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Alonso, Diana, L,24590 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Sun, Dennis, K,24481 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Navarro, Eddie, C,24504 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Wang, Roger, P,24605 | 3627.81 | 0.00 | 0.00 | 3627.81 | 0.00 |
| Vazquez, Rebekah, A,15784 | 4379.09 | 0.00 | 0.00 | 2049.10 | 2329.99 |
| Deng, Jodi,16161 | 2700.05 | 0.00 | 0.00 | 2049.10 | 650.95 |
| Ye, Steve,29087 | 810.32 | 0.00 | 0.00 | 0.00 | 810.32 |
| Yang, Shannon,12001 | 8113.01 | 0.00 | 3374.99 | 0.00 | 4738.02 |
| Alvarez, Desiree,13005 | 223.97 | 0.00 | 0.00 | 0.00 | 223.97 |
| Navarro, Julio, M,25822 | 1819.59 | 0.00 | 699.10 | 0.00 | 1120.49 |
| Kumar, Alejandro,14055 | 5177.40 | 0.00 | 0.00 | 2049.10 | 3128.30 |
| Andersen, Deborah,19610 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Blanco, Philip, M,15603 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Sanz, Cheryl, G,14046 | 5645.24 | 0.00 | 0.00 | 3340.26 | 2304.98 |
| Clark, Madison, A,14062 | 5647.92 | 0.00 | 0.00 | 3272.94 | 2374.98 |
| Dominguez, Darren, M,13966 | 6842.12 | 0.00 | 0.00 | 2049.10 | 4793.02 |
| Ma, Laura, L,24503 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Liang, Amy,16164 | 2639.08 | 0.00 | 0.00 | 2049.10 | 589.98 |
| Patel, Monica, J,25234 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Goldberg, Mindy,16159 | 4411.65 | 0.00 | 0.00 | 2071.42 | 2340.23 |
| Sun, Suzanne, P,24587 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Ma, Franklin,24485 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Kumar, Bridget,15802 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Hill, Luis,27500 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Hernandez, Javier, A,16156 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Xu, Dawn,27873 | 1249.84 | 0.00 | 0.00 | 1249.84 | 0.00 |
| Gomez, Tabitha, L,16688 | 6081.10 | 3578.27 | 0.00 | 2502.83 | 0.00 |
| Patterson, Kyle,11448 | 8132.01 | 0.00 | 3374.99 | 2318.96 | 2438.06 |
| Raji, Kathryn, C,21995 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Cai, Shannon,26156 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Pal, Willie, J,11755 | 46.25 | 0.00 | 0.00 | 0.00 | 46.25 |
| Suarez, Ruben,14031 | 6964.42 | 0.00 | 0.00 | 2049.10 | 4915.32 |
| Guo, Aimee,17075 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Hu, Alvin, E,11449 | 8130.32 | 0.00 | 3374.99 | 2362.27 | 2393.06 |
| Fernandez, Candace,11105 | 8095.99 | 0.00 | 3399.99 | 2294.99 | 2401.01 |
| Liu, Jessie,11106 | 8079.05 | 0.00 | 3399.99 | 2294.99 | 2384.07 |
| Gao, Todd, M,11061 | 8129.02 | 3374.99 | 0.00 | 2369.96 | 2384.07 |
| Ramos, Marc,18212 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Lal, Tara, S,18697 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Price, Ian, J,22401 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Kumar, Tony, P,19783 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Tang, Sharon, M,15823 | 67.96 | 0.00 | 0.00 | 0.00 | 67.96 |
| Black, Shaun, M,17355 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Nara, Cristina, R,19792 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Diaz, Marc,11058 | 8248.02 | 3399.99 | 0.00 | 2374.98 | 2473.05 |
| Raman, Patricia, T,16702 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Sanchez, Levi, A,27745 | 617.47 | 0.00 | 0.00 | 617.47 | 0.00 |
| Sharma, Kelvin, D,26655 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Munoz, Deanna,11054 | 8223.02 | 3399.99 | 0.00 | 2403.97 | 2419.06 |
| Chander, Bethany, K,11446 | 8237.01 | 0.00 | 3399.99 | 2354.98 | 2482.04 |
| He, Aimee, A,11093 | 8180.00 | 0.00 | 3399.99 | 2360.95 | 2419.06 |
| Navarro, Melinda,11454 | 8089.04 | 0.00 | 3374.99 | 2294.99 | 2419.06 |
| Kumar, Karl, J,14218 | 5651.88 | 0.00 | 0.00 | 2049.10 | 3602.78 |
| Vance, Jillian, D,15230 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Huang, Mandy,18266 | 72.26 | 0.00 | 0.00 | 0.00 | 72.26 |
| Blanco, Erik, J,29093 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Ruiz, Melody,13621 | 167.40 | 0.00 | 0.00 | 0.00 | 167.40 |
| Raje, Mario, S,20427 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Alexander, Gail, C,14682 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Perez, Allen, B,14229 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Guo, Leah, R,19562 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Goel, Barbara,12988 | 6915.44 | 0.00 | 0.00 | 2049.10 | 4866.34 |
| Diaz, Gerald, M,25118 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Beck, Bonnie, A,29097 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Romero, Latasha,14220 | 5696.19 | 0.00 | 0.00 | 2071.42 | 3624.77 |
| Yang, Curtis,11110 | 8093.03 | 0.00 | 3399.99 | 2294.99 | 2398.05 |
Generated 2025-11-06 19:22:09.252 UTC