[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 566 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Patel, Deanna, H,27354 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Shen, Cedric,22209 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Xu, Kara, E,22212 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Xie, Drew, A,20218 | 104.69 | 0.00 | 0.00 | 0.00 | 104.69 |
| Martinez, Cynthia,22170 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Yang, Jon, V,11000 | 8248.99 | 3399.99 | 0.00 | 2341.97 | 2507.03 |
| Gutierrez, Cheryl, O,25213 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Jiménez, Alberto, C,15215 | 4468.56 | 0.00 | 0.00 | 2049.10 | 2419.46 |
| Raman, Jermaine, E,15228 | 4375.06 | 0.00 | 0.00 | 2049.10 | 2325.96 |
| Alvarez, Kendra, R,15267 | 2853.58 | 0.00 | 0.00 | 2049.10 | 804.48 |
| Raji, Michele,15183 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Sai, Ann,27339 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Lal, Shawna,17924 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Sharma, Terrence, N,17351 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Zheng, Aimee, H,24283 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Zheng, Rosa, G,16629 | 5933.26 | 3578.27 | 0.00 | 0.00 | 2354.99 |
| Vazquez, Daisy, L,25560 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Mehta, Marco,11007 | 8211.00 | 3399.99 | 0.00 | 2391.95 | 2419.06 |
| Malhotra, Mayra, E,15577 | 143.45 | 0.00 | 0.00 | 0.00 | 143.45 |
| Ward, Haley, J,16631 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Liang, Kelvin, L,16616 | 5915.54 | 3578.27 | 0.00 | 0.00 | 2337.27 |
| Cooper, Victoria, S,13637 | 6777.13 | 0.00 | 0.00 | 2049.10 | 4728.03 |
| Watson, Maria,17229 | 4471.74 | 0.00 | 3578.27 | 0.00 | 893.47 |
| Wang, Curtis, A,13108 | 5718.66 | 0.00 | 0.00 | 2071.42 | 3647.24 |
| Fernandez, Brenda, L,16493 | 4197.25 | 3578.27 | 0.00 | 0.00 | 618.98 |
| Liang, Martha,16525 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Suarez, Jacquelyn, C,11010 | 8088.04 | 3399.99 | 0.00 | 2294.99 | 2393.06 |
| Suarez, Kristi, D,23099 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 0.00 | 1179.97 |
| Madan, Toni,26668 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Ramos, Monique,16495 | 6002.23 | 3578.27 | 0.00 | 0.00 | 2423.96 |
| Sanders, Arianna, E,22859 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Wang, Trisha, V,17259 | 4404.73 | 0.00 | 3578.27 | 0.00 | 826.46 |
| Moreno, Jimmy, L,11029 | 6565.29 | 3399.99 | 0.00 | 0.00 | 3165.30 |
| Beck, Donna, J,18247 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Shen, Russell, M,11150 | 192.42 | 0.00 | 0.00 | 0.00 | 192.42 |
| Thompson, Fernando,16350 | 5903.19 | 3578.27 | 0.00 | 0.00 | 2324.92 |
| Ramos, Joe,12353 | 6765.46 | 0.00 | 2071.42 | 0.00 | 4694.04 |
| Xu, Casey, J,13158 | 221.91 | 0.00 | 0.00 | 0.00 | 221.91 |
| Garcia, Dominique,16528 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Wu, Clarence, L,13115 | 6779.42 | 0.00 | 0.00 | 2049.10 | 4730.32 |
| Alvarez, Janet, G,11006 | 8119.03 | 3399.99 | 0.00 | 2334.97 | 2384.07 |
| Diaz, Briana,13131 | 6737.15 | 0.00 | 0.00 | 2049.10 | 4688.05 |
| Rodriguez, Arthur,15438 | 3788.68 | 0.00 | 0.00 | 2071.42 | 1717.26 |
| Zeng, Barbara,23102 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Sutton, Jaime, L,16630 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Stewart, Ariana,16743 | 6070.59 | 3578.27 | 0.00 | 0.00 | 2492.32 |
| Raman, Shane,16661 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| Raje, Gilbert,11055 | 8168.01 | 3374.99 | 0.00 | 2394.97 | 2398.05 |
| Gill, Monique, L,17727 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Li, Elijah,16740 | 6099.10 | 3578.27 | 0.00 | 0.00 | 2520.83 |
| Li, Marshall,12687 | 6805.47 | 0.00 | 0.00 | 2071.42 | 4734.05 |
| Rodriguez, Ebony,14517 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Munoz, Deanna,11054 | 8223.02 | 3399.99 | 0.00 | 2403.97 | 2419.06 |
| Romero, Lawrence, C,16687 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Zhu, Gilbert,11921 | 63.24 | 0.00 | 0.00 | 0.00 | 63.24 |
| Rai, Alejandro, R,21990 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Rana, Evelyn, D,18262 | 142.45 | 0.00 | 0.00 | 0.00 | 142.45 |
| Perez, Joel,16684 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Ward, Brooke,13007 | 5671.24 | 0.00 | 0.00 | 2071.42 | 3599.82 |
| Nelson, Sophia,16664 | 4377.75 | 0.00 | 3578.27 | 799.48 | 0.00 |
| Hall, Jesse,26133 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Ye, Dennis, M,16638 | 5974.23 | 0.00 | 3578.27 | 0.00 | 2395.96 |
| Jimenez, Latasha, E,13121 | 121.25 | 0.00 | 0.00 | 0.00 | 121.25 |
| Lopez, Heidi,11052 | 8131.32 | 0.00 | 3374.99 | 2337.27 | 2419.06 |
| Stewart, Bryan, M,16928 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Lee, Dalton, J,16931 | 4767.73 | 0.00 | 3578.27 | 0.00 | 1189.46 |
| Sanz, Kellie,16708 | 4406.74 | 0.00 | 3578.27 | 0.00 | 828.47 |
| Zheng, Alan,11050 | 5007.30 | 0.00 | 3374.99 | 0.00 | 1632.31 |
| Raman, Patricia, T,16702 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Martinez, Manuel, J,15832 | 2611.41 | 0.00 | 0.00 | 2071.42 | 539.99 |
| Suarez, Melody, H,14276 | 5259.36 | 0.00 | 0.00 | 2049.10 | 3210.26 |
| Evans, Carlos, J,23538 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Andersen, Carl, J,11057 | 8088.04 | 0.00 | 3374.99 | 2319.99 | 2393.06 |
| Serrano, Javier, R,20256 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Nara, Tony, L,16713 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Price, Deb,24502 | 3623.32 | 0.00 | 0.00 | 2443.35 | 1179.97 |
| Cai, Jessie, A,12249 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Rai, Karl, M,25273 | 1898.07 | 0.00 | 699.10 | 0.00 | 1198.97 |
| Romero, Paula, B,16691 | 4471.74 | 0.00 | 3578.27 | 0.00 | 893.47 |
| Torres, Diane, M,25211 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Cox, Michelle, E,17328 | 4387.74 | 0.00 | 3578.27 | 0.00 | 809.47 |
| Ma, Amy, E,17309 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| Wang, Alejandro,17310 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Zhu, Alan,17320 | 4391.74 | 0.00 | 3578.27 | 0.00 | 813.47 |
| Lewis, Justin, L,28303 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Wilson, Zachary,25558 | 1307.06 | 0.00 | 699.10 | 0.00 | 607.96 |
| Dominguez, Diana, L,29292 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Chen, Cedric, R,17065 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Hu, Amy,14320 | 261.95 | 0.00 | 0.00 | 0.00 | 261.95 |
| Kumar, Deborah, K,17308 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Cai, Susan,19101 | 104.42 | 0.00 | 0.00 | 0.00 | 104.42 |
| Arun, Ruth, S,17294 | 4355.71 | 0.00 | 3578.27 | 0.00 | 777.44 |
| Gao, Todd, M,11061 | 8129.02 | 0.00 | 3374.99 | 2369.96 | 2384.07 |
| Beck, Alicia, L,17248 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Moreno, Beth,21980 | 4334.61 | 0.00 | 0.00 | 2443.35 | 1891.26 |
| Sanz, Victor,17295 | 4392.74 | 0.00 | 3578.27 | 0.00 | 814.47 |
| Deng, Clayton, G,17285 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Perez, Kevin, M,25565 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Rana, Darren, M,17257 | 4480.73 | 0.00 | 3578.27 | 0.00 | 902.46 |
| Sanz, Monique, R,24273 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Sai, Molly,14683 | 98.95 | 0.00 | 0.00 | 0.00 | 98.95 |
| Vazquez, Craig,28117 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Raji, Terry,15597 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Lopez, Luis, P,17334 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Rodriguez, Sergio, D,15239 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Price, Isabella, L,17278 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Wilson, Jasmine,17329 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Martin, Ethan, M,13998 | 245.25 | 0.00 | 0.00 | 97.97 | 147.28 |
| Jackson, Joshua,17235 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Zhao, Rosa, A,19672 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Vazquez, Shannon,26035 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Goel, Nichole, A,17277 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Allen, Alexandra, B,17293 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Price, Vanessa, A,23569 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Luo, Casey,11072 | 8194.00 | 0.00 | 3399.99 | 2395.96 | 2398.05 |
| Gonzalez, Ivan, C,19625 | 52.77 | 0.00 | 0.00 | 0.00 | 52.77 |
| Rai, Colleen,28933 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Torres, Gina,17904 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Nara, Edwin, R,11097 | 8099.03 | 0.00 | 3374.99 | 0.00 | 4724.04 |
| Serrano, Darren,29196 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Muñoz, Jaime, C,24506 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Yuan, Bradley,17920 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
Generated 2025-12-24 06:27:37.239 UTC