[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanchez, Candace, L,21567 | 4973.28 | 0.00 | 0.00 | 2443.35 | 2529.93 |
| Srini, Roy,24888 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Arthur, Jay, R,12694 | 6785.13 | 0.00 | 0.00 | 2049.10 | 4736.03 |
| Hernandez, Armando,21950 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Zheng, Edwin, J,14216 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Anand, Johnny,14058 | 5652.52 | 0.00 | 0.00 | 2071.42 | 3581.10 |
| Jai, Kathryn,23546 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Chavez, Colin,16032 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Deng, Johnny,21409 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Jenkins, Noah, A,24379 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Xu, Rafael, A,21885 | 4641.85 | 0.00 | 0.00 | 2181.56 | 2460.29 |
| Dominguez, Jimmy,21959 | 4702.39 | 0.00 | 0.00 | 2181.56 | 2520.83 |
| Hernandez, Mallory,29091 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Yuan, Grant, C,24909 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Rubio, Philip, P,21876 | 4663.38 | 0.00 | 0.00 | 2181.56 | 2481.82 |
| Yang, Lacey,13150 | 89.24 | 0.00 | 0.00 | 0.00 | 89.24 |
| Mehta, Cindy, A,21943 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Romero, Diane, F,21947 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Nath, Alvin, R,29301 | 134.98 | 0.00 | 0.00 | 0.00 | 134.98 |
| Li, David, A,21894 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Zhao, Shannon,19807 | 35.47 | 0.00 | 0.00 | 0.00 | 35.47 |
| Pal, Derek,24591 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Kumar, Yolanda, J,18194 | 85.96 | 0.00 | 0.00 | 0.00 | 85.96 |
| Srini, Joe,22180 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Chander, Karla,23648 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Sanchez, Joel,18468 | 5333.25 | 0.00 | 3578.27 | 1754.98 | 0.00 |
| Mehta, Ann, M,14518 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Shan, Clarence,22408 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Mehta, Mayra,12998 | 5694.90 | 0.00 | 0.00 | 2049.10 | 3645.80 |
| Verhoff, Rob,11008 | 8106.31 | 3374.99 | 0.00 | 2312.26 | 2419.06 |
| Gonzalez, Rebekah, A,16927 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Watson, Adrian, K,13641 | 144.74 | 0.00 | 0.00 | 0.00 | 144.74 |
| Zhu, Omar,25033 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Moreno, Randall, F,21209 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Coleman, Dalton, M,23412 | 3586.81 | 0.00 | 0.00 | 2443.35 | 1143.46 |
| West, James, M,15148 | 90.75 | 0.00 | 0.00 | 0.00 | 90.75 |
| Liang, Glenn,21983 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Blanco, Lori, A,15735 | 116.25 | 0.00 | 0.00 | 0.00 | 116.25 |
| Lal, Donna,25812 | 113.97 | 0.00 | 0.00 | 0.00 | 113.97 |
| Morgan, Melissa, M,20222 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Ruiz, Natasha,21994 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Nara, Tara,21194 | 3911.53 | 0.00 | 2181.56 | 0.00 | 1729.97 |
| Moreno, Jessie, C,22906 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Sanchez, Abby, J,19966 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Vazquez, Randall, Z,21186 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Zeng, Suzanne,17918 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Hernandez, Frank, G,22198 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Bell, Stephanie, A,27370 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Simmons, Isabel, H,26432 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Johnson, Emma, M,15136 | 62.27 | 0.00 | 0.00 | 34.99 | 27.28 |
| Subram, Cassandra, M,16618 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Liang, Alan, L,29063 | 801.83 | 0.00 | 0.00 | 0.00 | 801.83 |
| Fernandez, Ivan,22032 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Kim, Kari, S,11445 | 8098.03 | 0.00 | 3399.99 | 2304.98 | 2393.06 |
| Rai, Michele, M,26567 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Jenkins, Wyatt,27987 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Chande, Michele, C,13078 | 6850.46 | 0.00 | 0.00 | 2071.42 | 4779.04 |
| Roberts, Jennifer,11447 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Chen, Aimee,26591 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Sanz, Renee, L,14319 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Subram, Virginia,13036 | 2677.07 | 0.00 | 0.00 | 2049.10 | 627.97 |
| Powell, Thomas, R,18218 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Morgan, Sara,13134 | 5648.92 | 0.00 | 0.00 | 2049.10 | 3599.82 |
| Dominguez, Jerome, F,22987 | 3942.03 | 0.00 | 0.00 | 2181.56 | 1760.47 |
| Raje, Grant, S,24162 | 3004.83 | 0.00 | 0.00 | 2443.35 | 561.48 |
| Sanz, Ross,11455 | 8142.03 | 0.00 | 3374.99 | 2319.99 | 2447.05 |
| Torres, Bailey,18259 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Vazquez, Anne,16027 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Fernandez, Rachael, M,23993 | 3072.32 | 0.00 | 0.00 | 2443.35 | 628.97 |
| Zeng, Louis,18903 | 4143.74 | 0.00 | 3578.27 | 565.47 | 0.00 |
| Johnson, Morgan, E,12011 | 4735.81 | 0.00 | 3374.99 | 0.00 | 1360.82 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 0.00 | 782.99 | 578.46 |
| Garcia, Harold, K,14087 | 341.97 | 0.00 | 0.00 | 0.00 | 341.97 |
| Kapoor, Ruben, D,11109 | 8245.01 | 0.00 | 3374.99 | 2476.96 | 2393.06 |
| Rana, Cindy,21367 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Xu, Alisha,14100 | 226.26 | 0.00 | 0.00 | 0.00 | 226.26 |
| Raji, Grant, R,16185 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Saunders, Micheal,17513 | 4260.24 | 0.00 | 3578.27 | 681.97 | 0.00 |
| She, Brittney, M,22942 | 3971.53 | 0.00 | 0.00 | 2181.56 | 1789.97 |
| Rubio, Max, L,19578 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Subram, Kristi, N,15025 | 128.94 | 0.00 | 0.00 | 0.00 | 128.94 |
| Long, Emily, L,26140 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Zhao, Kelvin,25135 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Alexander, Gail, C,14682 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Suarez, Joy, B,12665 | 74.54 | 0.00 | 0.00 | 0.00 | 74.54 |
| Yang, Todd, J,19094 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zeng, Brittney, K,13670 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Russell, Alexis, L,13634 | 234.93 | 0.00 | 0.00 | 0.00 | 234.93 |
| Raman, César, C,24004 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Raji, Misty,16520 | 4727.74 | 3578.27 | 0.00 | 0.00 | 1149.47 |
| Suri, Adriana,18463 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Patel, Abby,16029 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Griffin, Olivia,21208 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Vazquez, Daisy, L,25560 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Nara, Gregory,26651 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Pal, Lacey, K,26571 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Li, Justin,14124 | 57.59 | 0.00 | 0.00 | 0.00 | 57.59 |
| Watson, Maria,17229 | 4471.74 | 0.00 | 3578.27 | 0.00 | 893.47 |
| Nara, Jaclyn, M,11930 | 5035.81 | 0.00 | 3399.99 | 0.00 | 1635.82 |
| Vazquez, Eddie, T,14012 | 5249.92 | 0.00 | 0.00 | 2049.10 | 3200.82 |
| Serrano, Francis, R,23547 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Raji, Donna,24906 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Sai, Ronald, B,13643 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Jenkins, Anna, M,17234 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Gutierrez, Erika,17227 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Andersen, Willie, M,27970 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Hernandez, Danny,27146 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Zhang, Cara,12351 | 117.97 | 0.00 | 0.00 | 0.00 | 117.97 |
| Romero, Deanna, K,23570 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Raman, Roy,16348 | 5918.24 | 3578.27 | 0.00 | 0.00 | 2339.97 |
| Liang, Jenny, S,27351 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Tang, Cristina, D,19623 | 153.93 | 0.00 | 0.00 | 0.00 | 153.93 |
| Raje, Arturo, C,14228 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| She, Valerie, C,20226 | 6067.20 | 0.00 | 3578.27 | 0.00 | 2488.93 |
| White, Olivia, E,18457 | 4826.23 | 0.00 | 3578.27 | 0.00 | 1247.96 |
| Carlson, Francis,27340 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Sai, Troy,16515 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Wang, Alejandro,17310 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Martinez, Tina, J,18461 | 4748.24 | 0.00 | 3578.27 | 0.00 | 1169.97 |
| Zhang, Barbara,16338 | 169.43 | 0.00 | 0.00 | 58.47 | 110.96 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Dominguez, Gina, L,20213 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Rana, Ruben,27696 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
Generated 2025-12-22 00:17:12.208 UTC