[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 1125 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sun, Jorge,16025 | 3831.89 | 0.00 | 0.00 | 2071.42 | 1760.47 |
| Li, Lacey,17515 | 4143.26 | 0.00 | 3578.27 | 0.00 | 564.99 |
| Bhat, Yolanda,15225 | 4401.41 | 0.00 | 0.00 | 2071.42 | 2329.99 |
| Vazquez, Marc, H,24362 | 3600.77 | 0.00 | 0.00 | 2443.35 | 1157.42 |
| Flores, Miranda,17243 | 83.98 | 0.00 | 0.00 | 53.99 | 29.99 |
| Serrano, Javier, R,20256 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Pal, Christine, I,18242 | 6121.71 | 0.00 | 3578.27 | 2543.44 | 0.00 |
| Yang, Alan, L,15605 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Vance, Phillip,29308 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Liu, Jessie,11106 | 8079.05 | 0.00 | 3399.99 | 2294.99 | 2384.07 |
| Romero, Wendy, H,11372 | 4965.81 | 0.00 | 3374.99 | 0.00 | 1590.82 |
| Ferrier, Jaclyn, D,17299 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Sai, Clifford,25128 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Ortega, Gloria, R,19558 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Garcia, Ruth,20623 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Raji, Arturo,23998 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Madan, Roy,15716 | 4467.06 | 0.00 | 0.00 | 2049.10 | 2417.96 |
| Martin, Gerald, K,17284 | 90.25 | 0.00 | 0.00 | 31.27 | 58.98 |
| Anand, Katrina, L,18726 | 5314.25 | 0.00 | 3578.27 | 1735.98 | 0.00 |
| Shen, Barbara,22030 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Lopez, Clifford, E,27709 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Sanz, Renee, L,14319 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Ross, Mya, E,27715 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Munoz, Darren,23539 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Rubio, Tanya, I,15598 | 167.93 | 0.00 | 0.00 | 0.00 | 167.93 |
| She, Jaime, D,28482 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Zhu, Tiffany,26437 | 1953.47 | 0.00 | 0.00 | 782.99 | 1170.48 |
| Lopez, Stanley, M,28962 | 2477.53 | 0.00 | 0.00 | 0.00 | 2477.53 |
| Romero, Mallory,26434 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Shan, Tasha,15192 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Tang, Nina,27485 | 1354.71 | 0.00 | 0.00 | 782.99 | 571.72 |
| Kovár, Barry, A,21570 | 4705.48 | 0.00 | 2181.56 | 0.00 | 2523.92 |
| Nara, Cristina, R,19792 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Rodriguez, Joel, C,16488 | 119.95 | 0.00 | 0.00 | 119.95 | 0.00 |
| Ma, Franklin,24485 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Raman, Cindy,16157 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Anand, Jodi,26129 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Xie, Mitchell, B,20993 | 4262.04 | 0.00 | 3578.27 | 0.00 | 683.77 |
| Hernandez, Audrey,18290 | 84.96 | 0.00 | 0.00 | 8.99 | 75.97 |
| Yuan, Marshall, P,19978 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Zhu, Erica,25221 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Yang, Stacey,14215 | 5665.89 | 0.00 | 0.00 | 2049.10 | 3616.79 |
| Patel, Harold,24585 | 3366.02 | 0.00 | 0.00 | 2181.56 | 1184.46 |
| Rai, Raul, R,15133 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| She, Clarence, L,24901 | 2174.92 | 0.00 | 0.00 | 2174.92 | 0.00 |
| Li, Kristen, R,15153 | 113.97 | 0.00 | 0.00 | 88.98 | 24.99 |
| Tang, Cristina, D,19623 | 153.93 | 0.00 | 0.00 | 0.00 | 153.93 |
| Mr., Spencer, Phil,19960 | 6120.11 | 0.00 | 3578.27 | 0.00 | 2541.84 |
| Vance, Henry,27986 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Ward, Jessica,15587 | 4423.38 | 0.00 | 0.00 | 2071.42 | 2351.96 |
| Sharma, Tracy,17731 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Lu, Willie,21191 | 4169.33 | 0.00 | 2443.35 | 0.00 | 1725.98 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Arthur, Regina, A,19089 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Weber, Cory,16739 | 81.26 | 0.00 | 0.00 | 31.27 | 49.99 |
| Sanz, Linda, P,22945 | 12.94 | 0.00 | 0.00 | 12.94 | 0.00 |
| Kumar, Tamara, A,25222 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Suri, Erick,16635 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Johnson, Elizabeth,11004 | 8196.01 | 3399.99 | 0.00 | 2376.96 | 2419.06 |
| Raje, Bonnie,20629 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Subram, Ross, L,23085 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Anand, Carly,25918 | 1260.58 | 0.00 | 699.10 | 0.00 | 561.48 |
| Lal, Nicolas, D,21212 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Andersen, Jaime,25268 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Wang, Willie,29304 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Patterson, Kyle,11448 | 8132.01 | 0.00 | 3374.99 | 2318.96 | 2438.06 |
| Baker, Luke, J,22952 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Lopez, Cesar,17500 | 156.96 | 0.00 | 0.00 | 0.00 | 156.96 |
| Shen, Kathryn, R,21957 | 4919.30 | 0.00 | 2443.35 | 0.00 | 2475.95 |
| Diaz, Dana, C,12361 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Chen, Rosa,23435 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Zhang, Aimee,26025 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Gomez, Anne,13045 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Xu, Randy, S,11969 | 8173.02 | 0.00 | 3399.99 | 2319.99 | 2453.04 |
| Jai, Calvin, S,22918 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Parker, Gabriella,21394 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Carlson, Marc, W,17501 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Sanders, Arianna, E,22859 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzalez, Francisco, L,12245 | 3967.26 | 0.00 | 3399.99 | 0.00 | 567.27 |
| Martinez, Stanley, Z,13668 | 114.21 | 0.00 | 0.00 | 106.26 | 7.95 |
| Gill, Latasha, M,25713 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Vazquez, Craig,28117 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Zheng, Christy,17069 | 4426.74 | 3578.27 | 0.00 | 0.00 | 848.47 |
| Gutierrez, Joy, A,18466 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Yang, Todd, J,19094 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Sanz, Paula,26430 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Raman, César, C,24004 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Flores, Alexandra, C,26165 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Kumar, Deborah, K,17308 | 6021.62 | 3578.27 | 0.00 | 0.00 | 2443.35 |
| Xu, Barbara,29195 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Arun, Levi, A,11074 | 94.19 | 0.00 | 0.00 | 49.97 | 44.22 |
| Anand, Johnny,14058 | 5652.52 | 0.00 | 0.00 | 3355.24 | 2297.28 |
| Sanz, Kellie,16708 | 4406.74 | 3578.27 | 0.00 | 0.00 | 828.47 |
| Kumar, Keith, M,25224 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lal, Corey, H,23313 | 2906.03 | 0.00 | 0.00 | 2181.56 | 724.47 |
| Xu, Martha, C,16351 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Sai, Holly, V,26769 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Thompson, Michael, M,26148 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Henderson, Paige, C,17325 | 54.94 | 0.00 | 0.00 | 0.00 | 54.94 |
| Sara, Ebony,24923 | 2159.40 | 0.00 | 0.00 | 1000.44 | 1158.96 |
| Liang, Randy, E,28958 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Jai, Warren, S,16483 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Gutierrez, Kristine, G,25133 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Hernandez, Victor, T,23537 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Fernandez, Ronald,28939 | 14.98 | 0.00 | 0.00 | 14.98 | 0.00 |
| Chander, Dustin,11895 | 8149.04 | 0.00 | 3374.99 | 2354.99 | 2419.06 |
| Kumar, Jaime, O,29061 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Xu, Barbara,14074 | 59.88 | 0.00 | 0.00 | 0.00 | 59.88 |
| Lal, Terry,18277 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Ye, Valerie, C,28948 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Dominguez, Gerald, E,20631 | 71.96 | 0.00 | 0.00 | 0.00 | 71.96 |
| Yang, Tiffany, K,21215 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Jai, Maurice,22932 | 4169.33 | 0.00 | 0.00 | 4169.33 | 0.00 |
| Ruiz, Leslie, J,26032 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Blanco, Brandi, L,20986 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Mehta, Edgar,11761 | 8149.49 | 0.00 | 3399.99 | 2356.44 | 2393.06 |
| Madan, Michele, A,12676 | 6859.46 | 0.00 | 2071.42 | 0.00 | 4788.04 |
| Chande, Casey,26149 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Raji, Kathryn, C,21995 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Fernandez, Marie,28929 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Zeng, Alvin, M,11118 | 115.85 | 0.00 | 0.00 | 0.00 | 115.85 |
| Carson, Kristin, C,24459 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Saunders, Micheal,17513 | 4260.24 | 0.00 | 3578.27 | 681.97 | 0.00 |
| Liu, Candice,28720 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Yuan, Derek, L,27589 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
Generated 2025-11-04 11:48:15.759 UTC