[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1559 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ramos, Dana, D,25919 | 1248.08 | 0.00 | 699.10 | 0.00 | 548.98 |
| Johnson, Morgan, E,12011 | 4735.81 | 0.00 | 3374.99 | 0.00 | 1360.82 |
| Collins, Andrea,12250 | 3964.98 | 0.00 | 3399.99 | 0.00 | 564.99 |
| Zheng, Jaclyn, F,11910 | 8113.03 | 0.00 | 3374.99 | 0.00 | 4738.04 |
| Lewis, Kayla,12013 | 3949.97 | 0.00 | 3399.99 | 0.00 | 549.98 |
| Garcia, Ruth,20623 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| She, Valerie, C,20226 | 6067.20 | 0.00 | 3578.27 | 0.00 | 2488.93 |
| Tang, Willie, A,25939 | 1264.57 | 0.00 | 699.10 | 0.00 | 565.47 |
| Navarro, Theresa,20627 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| She, Rafael, I,20152 | 4142.75 | 0.00 | 3578.27 | 564.48 | 0.00 |
| Perez, Molly,25941 | 1255.36 | 0.00 | 699.10 | 0.00 | 556.26 |
| Johnson, Chloe, L,20617 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Gonzalez, Virginia,11929 | 4965.78 | 0.00 | 3374.99 | 0.00 | 1590.79 |
| Cook, Victoria, J,20620 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Goel, Ricardo, T,25961 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Mr., Rodgers, Scott, M.,20211 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Andersen, Tracy,20815 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Allen, Luis, C,26019 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Yuan, Marshall, P,19978 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Yuan, Rafael, J,20625 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Ortega, Alfredo, W,25958 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
| Harrison, Colleen, L,20219 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Suarez, Jerome, L,20622 | 6139.59 | 0.00 | 3578.27 | 0.00 | 2561.32 |
| Xu, Rafael, N,21195 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Rodriguez, Rachael, M,11944 | 4776.27 | 0.00 | 3374.99 | 0.00 | 1401.28 |
| Yuan, Lacey, W,12349 | 6772.14 | 0.00 | 2049.10 | 0.00 | 4723.04 |
| Chapman, Clifford, C,21168 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Xu, Randy, S,11969 | 8173.02 | 0.00 | 3399.99 | 0.00 | 4773.03 |
| Yuan, Chad, C,21173 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Becker, Kara,21167 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Zhang, Louis, K,20227 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Munoz, Casey, W,12570 | 2654.06 | 0.00 | 2049.10 | 0.00 | 604.96 |
| Nath, Cassie,24606 | 2155.92 | 0.00 | 1000.44 | 1155.48 | 0.00 |
| Shan, Colin,25921 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Huang, Crystal, L,26023 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Xu, Barbara,14074 | 59.88 | 0.00 | 0.00 | 0.00 | 59.88 |
| Madan, Jay, L,20156 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| Rai, Grant, R,12573 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
| She, Jaime, D,28482 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Lin, Kelvin, A,13075 | 6843.94 | 0.00 | 0.00 | 2071.42 | 4772.52 |
| Lopez, Barry, R,26020 | 1932.46 | 0.00 | 782.99 | 0.00 | 1149.47 |
| Gomez, Arthur,24917 | 2179.91 | 0.00 | 0.00 | 1000.44 | 1179.47 |
| Hernandez, Jill, L,13003 | 230.25 | 0.00 | 0.00 | 0.00 | 230.25 |
| Nara, Katrina, Z,24608 | 2120.93 | 0.00 | 1000.44 | 0.00 | 1120.49 |
| Jimenez, Joy,28312 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Zeng, Alisha, A,15727 | 134.46 | 0.00 | 0.00 | 0.00 | 134.46 |
| Sai, Terrance,19106 | 64.95 | 0.00 | 0.00 | 0.00 | 64.95 |
| Romero, Max, C,29316 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Huang, Micah,25130 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Carter, Sophia, D,25230 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Vazquez, Arthur,28480 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Carlson, Tanya,16183 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Sanz, Rodney,16926 | 44.95 | 0.00 | 0.00 | 0.00 | 44.95 |
| Ye, Marshall, R,26559 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Ramos, Victor, D,24246 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Black, Michele,13995 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Gonzalez, Meredith,22171 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Sanz, Nelson, M,14056 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Gomez, Nelson, L,29053 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Hu, Crystal,27980 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Sai, Rachael,11912 | 8095.32 | 0.00 | 3374.99 | 0.00 | 4720.33 |
| Raje, Raul, L,26785 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| She, Sheena, R,23008 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Sanz, Roy, R,11917 | 8121.33 | 0.00 | 3399.99 | 0.00 | 4721.34 |
| Gutierrez, Armando,29310 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Alexander, Gail, C,14682 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Arthur, Raymond, S,20228 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Gutierrez, Gary, C,12701 | 6868.44 | 0.00 | 0.00 | 2071.42 | 4797.02 |
| Gill, Mallory, P,16698 | 197.88 | 0.00 | 0.00 | 0.00 | 197.88 |
| Martinez, Frederick,11991 | 8128.02 | 0.00 | 3374.99 | 0.00 | 4753.03 |
| Hu, Alejandro,13125 | 138.54 | 0.00 | 0.00 | 0.00 | 138.54 |
| Navarro, Francis, J,27520 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Sharma, Mario, J,25928 | 1316.05 | 0.00 | 699.10 | 0.00 | 616.95 |
| Alonso, Krista, P,20212 | 100.74 | 0.00 | 0.00 | 0.00 | 100.74 |
| Chande, Alvin, W,24893 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Srini, Veronica,11996 | 7058.70 | 0.00 | 3374.99 | 1291.77 | 2391.94 |
| Serrano, Leslie, T,14014 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Perez, Brett, M,28313 | 647.94 | 0.00 | 0.00 | 0.00 | 647.94 |
| Rivera, Mariah,20261 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Shan, Yolanda,12702 | 6911.10 | 0.00 | 0.00 | 2049.10 | 4862.00 |
| Cai, Warren,24918 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Raje, Rafael, M,13000 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Chow, Christy, M,12681 | 6784.13 | 0.00 | 0.00 | 2049.10 | 4735.03 |
| Sanz, Hector,27344 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Zeng, Brittney, K,13670 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Ye, Tamara, A,20243 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Huang, Colleen, S,21379 | 2992.33 | 0.00 | 0.00 | 2443.35 | 548.98 |
| Gomez, Jill,29315 | 103.96 | 0.00 | 0.00 | 0.00 | 103.96 |
| Hernandez, Leslie, D,12990 | 6829.47 | 0.00 | 0.00 | 2071.42 | 4758.05 |
| Shen, Nichole,12999 | 6840.46 | 0.00 | 0.00 | 2071.42 | 4769.04 |
| Madan, Erick, W,14212 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Raje, Jodi, E,19630 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Gonzalez, Ruth,12693 | 6820.47 | 0.00 | 0.00 | 2071.42 | 4749.05 |
| Arun, Barry,27700 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Goel, Alejandro, K,13077 | 6766.63 | 0.00 | 0.00 | 2049.10 | 4717.53 |
| Pal, Alison,13042 | 84.47 | 0.00 | 0.00 | 0.00 | 84.47 |
| Vazquez, Joe, C,20418 | 4207.24 | 0.00 | 3578.27 | 0.00 | 628.97 |
| Jimenez, Naomi,24922 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Martinez, Anna, J,12994 | 6855.44 | 0.00 | 0.00 | 2071.42 | 4784.02 |
| Malhotra, Veronica, J,25922 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Rivera, Devin, J,25109 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Li, Vincent, D,21207 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Zeng, Cara,20444 | 6085.59 | 0.00 | 3578.27 | 0.00 | 2507.32 |
| Vazquez, Carolyn,23650 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jones, Ethan,13051 | 6831.74 | 0.00 | 0.00 | 2071.42 | 4760.32 |
| Martin, Anna, L,20988 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Hayes, Eric, A,22964 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Zhou, Trisha, B,12686 | 6864.46 | 0.00 | 0.00 | 2071.42 | 4793.04 |
| Yuan, Deborah,12021 | 4043.46 | 0.00 | 3399.99 | 0.00 | 643.47 |
| Perez, Geoffrey, P,21000 | 2721.55 | 0.00 | 2181.56 | 0.00 | 539.99 |
| Xu, Keith, J,25124 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Prasad, Preston, C,20812 | 4127.25 | 0.00 | 3578.27 | 0.00 | 548.98 |
| Madan, Joe,29300 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Lopez, Brenda,26592 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Perez, Ronald,25944 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Serrano, Jésus, B,12991 | 5641.90 | 0.00 | 0.00 | 2049.10 | 3592.80 |
| Xie, Clarence,22402 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Liang, Gilbert,12242 | 3948.97 | 0.00 | 3374.99 | 0.00 | 573.98 |
| Cai, Willie, S,25960 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Raje, Shawn,17054 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Shan, Deborah,20624 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Gomez, Sheila, J,21165 | 4673.88 | 0.00 | 2181.56 | 0.00 | 2492.32 |
| She, Mandy, K,21972 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Lu, Margaret, D,20814 | 4186.23 | 0.00 | 3578.27 | 0.00 | 607.96 |
Generated 2025-12-23 06:05:30.844 UTC