[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 375 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Weber, Deanna, L,14855 | 3759.08 | 0.00 | 0.00 | 2049.10 | 1709.98 |
| Liu, Warren,15014 | 3860.87 | 0.00 | 0.00 | 2071.42 | 1789.45 |
| Dominguez, Neil, K,23663 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Ross, Arianna, E,26774 | 1331.97 | 0.00 | 0.00 | 1331.97 | 0.00 |
| Gao, Micah, W,25106 | 2170.92 | 0.00 | 0.00 | 1000.44 | 1170.48 |
| Serrano, Mallory, E,26751 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Stone, Denise,11032 | 6525.56 | 3374.99 | 0.00 | 0.00 | 3150.57 |
| Rai, Calvin,15229 | 2833.57 | 0.00 | 0.00 | 2049.10 | 784.47 |
| Shen, Brendan, L,14305 | 3652.20 | 0.00 | 0.00 | 2049.10 | 1603.10 |
| Goel, Tara, I,14347 | 2900.39 | 0.00 | 0.00 | 2071.42 | 828.97 |
| Zhang, Damien, C,26758 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Lal, Cristina, M,14671 | 2934.37 | 0.00 | 0.00 | 2071.42 | 862.95 |
| Luo, Christine, J,24159 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Lin, Sandra, A,25052 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Shan, Tasha,15192 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Jones, Destiny,15171 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Chander, Melvin, L,24266 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Raje, Kurt,15210 | 2926.39 | 0.00 | 0.00 | 2071.42 | 854.97 |
| Wang, Lacey,24173 | 2771.52 | 0.00 | 0.00 | 2181.56 | 589.96 |
| Lin, Jake,24248 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Ma, Roger, V,15130 | 5215.40 | 0.00 | 0.00 | 2049.10 | 3166.30 |
| Huang, Rosa, P,15181 | 4448.38 | 0.00 | 0.00 | 2071.42 | 2376.96 |
| Ortega, Latasha,24270 | 2844.51 | 0.00 | 0.00 | 2181.56 | 662.95 |
| Gomez, Teresa, D,24164 | 2760.02 | 0.00 | 0.00 | 2181.56 | 578.46 |
| Gao, Randy,25113 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Raji, Jaime, L,15037 | 3856.38 | 0.00 | 0.00 | 2071.42 | 1784.96 |
| Li, Edwin,26967 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Vazquez, Diane, D,11987 | 279.23 | 0.00 | 0.00 | 0.00 | 279.23 |
| Zeng, Alvin, M,11118 | 115.85 | 0.00 | 0.00 | 0.00 | 115.85 |
| Ramos, Craig,14209 | 193.97 | 0.00 | 0.00 | 4.99 | 188.98 |
| Wood, Jacqueline,16705 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Zhu, Roger, J,28098 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Gill, Meredith, E,24268 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Arun, Levi, A,11074 | 94.19 | 0.00 | 0.00 | 49.97 | 44.22 |
| Raje, Shawn,17054 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| She, Mandy, K,21972 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Henderson, Xavier, K,12993 | 96.25 | 0.00 | 0.00 | 0.00 | 96.25 |
| Rai, Christy,16683 | 69.87 | 0.00 | 0.00 | 0.00 | 69.87 |
| Beck, Alisha, E,11463 | 47.92 | 0.00 | 0.00 | 7.95 | 39.97 |
| Yang, Clarence, D,25121 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Srini, Manuel,24168 | 2790.52 | 0.00 | 0.00 | 2181.56 | 608.96 |
| Raman, Ruben,15580 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Sanchez, Andre,15595 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Wu, Shannon, F,15268 | 2840.91 | 0.00 | 0.00 | 2071.42 | 769.49 |
| Sai, Ann,27339 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Suri, Patricia, E,15436 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Alonso, Meghan, A,24457 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Prasad, Ebony,24368 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Deng, Priscilla, M,25127 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Deng, Kate, L,15723 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Subram, Douglas,27352 | 1357.97 | 0.00 | 0.00 | 782.99 | 574.98 |
| Prasad, Henry, M,24364 | 3965.52 | 0.00 | 0.00 | 2181.56 | 1783.96 |
| Arun, Troy, P,15221 | 4447.87 | 0.00 | 0.00 | 2071.42 | 2376.45 |
| Bell, Stephanie, A,27370 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Huang, Lacey, J,11951 | 63.52 | 0.00 | 0.00 | 0.00 | 63.52 |
| Kovar, Mayra, J,17312 | 4471.74 | 3578.27 | 0.00 | 0.00 | 893.47 |
| Guo, Lisa, S,17314 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Ruiz, Francis, D,21381 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Schmidt, Danny, M,28926 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Srini, Candace,15437 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Sara, Ross,24367 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Gutierrez, Cheryl, O,25213 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Moreno, Lori, M,15226 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Sai, Tina, L,15425 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Rana, Henry,27342 | 1348.46 | 0.00 | 0.00 | 782.99 | 565.47 |
| Nara, Willie,24460 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Fernandez, Donald, C,24462 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Ward, Jessica,15587 | 4423.38 | 0.00 | 0.00 | 2071.42 | 2351.96 |
| Davis, Morgan, J,27359 | 1344.47 | 0.00 | 0.00 | 782.99 | 561.48 |
| Garcia, Roy, H,15585 | 4367.02 | 0.00 | 0.00 | 2049.10 | 2317.92 |
| Luo, Melvin,24366 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Blanco, Victor,15586 | 4469.37 | 0.00 | 0.00 | 2071.42 | 2397.95 |
| Lopez, Mayra, E,27356 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Luo, Ashlee,23534 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Raji, Michele,15183 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Ma, Franklin,24485 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Nara, Dawn, M,21891 | 4921.69 | 0.00 | 2443.35 | 0.00 | 2478.34 |
| Munoz, Cheryl, C,13632 | 6838.46 | 0.00 | 0.00 | 2071.42 | 4767.04 |
| Munoz, Theresa, M,13953 | 6840.75 | 0.00 | 0.00 | 2071.42 | 4769.33 |
| Watson, Maria,17229 | 4471.74 | 3578.27 | 0.00 | 0.00 | 893.47 |
| Gray, Faith,22914 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Andersen, Willie, M,27970 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Lin, Kelvin, A,13075 | 6843.94 | 0.00 | 0.00 | 2071.42 | 4772.52 |
| Sanders, Arianna, E,22859 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wang, Trisha, V,17259 | 4404.73 | 3578.27 | 0.00 | 0.00 | 826.46 |
| Yuan, Cassie, J,24453 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Ramos, Joe,12353 | 6765.46 | 0.00 | 2071.42 | 0.00 | 4694.04 |
| Xu, Casey, J,13158 | 221.91 | 0.00 | 0.00 | 64.97 | 156.94 |
| Zhu, Dawn,26661 | 1912.47 | 0.00 | 0.00 | 782.99 | 1129.48 |
| Rodriguez, Arthur,15438 | 3788.68 | 0.00 | 0.00 | 2071.42 | 1717.26 |
| Perez, Evelyn,14346 | 3583.26 | 0.00 | 0.00 | 2071.42 | 1511.84 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 8.99 | 64.97 |
| Liu, Autumn, J,20985 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Serrano, Julio,20992 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| Zheng, Jeffery, W,15030 | 3786.39 | 0.00 | 0.00 | 2071.42 | 1714.97 |
| Rodriguez, Allen, L,17732 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Ruiz, Bruce, W,16171 | 103.86 | 0.00 | 0.00 | 0.00 | 103.86 |
| Prasad, Darren,12372 | 99.03 | 0.00 | 0.00 | 89.46 | 9.57 |
| Ms., Schultz, Barbara, R.,15811 | 71.16 | 0.00 | 0.00 | 0.00 | 71.16 |
| Romero, Latasha,14220 | 5696.19 | 0.00 | 0.00 | 2071.42 | 3624.77 |
| Jimenez, Latasha, E,13121 | 121.25 | 0.00 | 0.00 | 0.00 | 121.25 |
| Serrano, Derrick,16707 | 4377.75 | 3578.27 | 0.00 | 0.00 | 799.48 |
| Gomez, Anne,13045 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Xu, Barbara,29195 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Cai, Cedric,19559 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Evans, Carlos, J,23538 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Price, Deb,24502 | 3623.32 | 0.00 | 0.00 | 2443.35 | 1179.97 |
| Gutierrez, Desiree,15216 | 101.74 | 0.00 | 0.00 | 27.28 | 74.46 |
| Rai, Clayton, K,20446 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Pal, Casey,16522 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Lal, Barbara, W,23101 | 2795.01 | 0.00 | 0.00 | 2181.56 | 613.45 |
| Sai, Molly,14683 | 98.95 | 0.00 | 0.00 | 18.97 | 79.98 |
| Jackson, Eduardo, C,11749 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Rodriguez, Sergio, D,15239 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 0.00 | 3623.79 |
| Vazquez, Shannon,26035 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Prasad, Dominic, D,19962 | 46.75 | 0.00 | 0.00 | 0.00 | 46.75 |
| Bailey, Melissa, C,19572 | 82.25 | 0.00 | 0.00 | 0.00 | 82.25 |
| Nath, Katie, A,23434 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Muñoz, Jaime, C,24506 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Suri, Troy, M,12251 | 3924.97 | 0.00 | 3374.99 | 0.00 | 549.98 |
| Vazquez, Ruben, B,14301 | 5142.75 | 0.00 | 0.00 | 2071.42 | 3071.33 |
| Lopez, Adriana, A,12002 | 8145.33 | 0.00 | 3374.99 | 0.00 | 4770.34 |
| Saunders, Bobby, D,22205 | 120.48 | 0.00 | 0.00 | 0.00 | 120.48 |
| Sharma, Christian,15809 | 62.59 | 0.00 | 0.00 | 32.60 | 29.99 |
Generated 2025-11-03 08:12:31.194 UTC