[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Sanz, Orlando,14309 | 99.47 | 0.00 | 0.00 | 74.48 | 24.99 |
| Ortega, Jessie, J,17051 | 6060.50 | 3578.27 | 0.00 | 2482.23 | 0.00 |
| Gutierrez, Erika,17227 | 83.97 | 0.00 | 0.00 | 24.99 | 58.98 |
| Xu, Martha, C,16351 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Zeng, Ramon,27979 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hernandez, Logan,12350 | 6791.75 | 0.00 | 2071.42 | 2319.99 | 2400.34 |
| Vazquez, Andy,19620 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Sharma, Terrence, N,17351 | 6117.69 | 3578.27 | 0.00 | 0.00 | 2539.42 |
| Martin, Gerald, K,17284 | 90.25 | 0.00 | 0.00 | 31.27 | 58.98 |
| Chander, Karla,23648 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Alan, Bob, A,27366 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Yang, Todd, J,19094 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Srini, Roy,24888 | 2174.92 | 0.00 | 1000.44 | 1174.48 | 0.00 |
| Vazquez, Ross,11148 | 126.24 | 0.00 | 0.00 | 53.99 | 72.25 |
| Sanz, Lance,22573 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Raji, Misty,16520 | 4727.74 | 3578.27 | 0.00 | 1149.47 | 0.00 |
| Carlson, Theresa, L,19629 | 109.44 | 0.00 | 0.00 | 60.47 | 48.97 |
| Jiménez, Beth, H,11120 | 8242.49 | 0.00 | 3374.99 | 2394.46 | 2473.04 |
| Munoz, Anne,15798 | 98.96 | 0.00 | 0.00 | 34.99 | 63.97 |
| Mehta, Deanna, P,17280 | 6089.59 | 3578.27 | 0.00 | 2511.32 | 0.00 |
| Yang, Darryl, K,21571 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Flores, Katherine,21180 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Yuan, Marshall, P,19978 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Beck, Alejandro,11025 | 6576.80 | 3374.99 | 0.00 | 2405.47 | 796.34 |
| Hernandez, Armando,21950 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Sanchez, Ross,28310 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Pal, Drew,11902 | 63.04 | 0.00 | 0.00 | 6.28 | 56.76 |
| Pal, Casey,16522 | 4698.76 | 3578.27 | 0.00 | 1120.49 | 0.00 |
| Pal, Mohamed, D,12698 | 6786.75 | 0.00 | 2071.42 | 0.00 | 4715.33 |
| Torres, Kristy, M,13035 | 2638.06 | 0.00 | 2049.10 | 0.00 | 588.96 |
| Long, Nicole, C,13624 | 114.97 | 0.00 | 0.00 | 59.98 | 54.99 |
| Torres, Ruben,11002 | 8114.04 | 3399.99 | 0.00 | 4714.05 | 0.00 |
| Xu, Rafael, A,21885 | 4641.85 | 0.00 | 2181.56 | 0.00 | 2460.29 |
| Munoz, Craig, V,13076 | 6862.14 | 0.00 | 2049.10 | 0.00 | 4813.04 |
| Kapoor, Bryant,22946 | 3911.53 | 0.00 | 0.00 | 3911.53 | 0.00 |
| Fernandez, Manuel, A,16514 | 4761.74 | 3578.27 | 0.00 | 1183.47 | 0.00 |
| Rai, Tonya,25243 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Shen, Nichole,12999 | 6840.46 | 0.00 | 2071.42 | 0.00 | 4769.04 |
| Garcia, George,20160 | 4237.22 | 0.00 | 3578.27 | 658.95 | 0.00 |
| Arthur, Tabitha, E,16482 | 4783.74 | 3578.27 | 0.00 | 1205.47 | 0.00 |
| Rubio, Philip, P,21876 | 4663.38 | 0.00 | 2181.56 | 0.00 | 2481.82 |
| Gutierrez, Rodney, J,20628 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Chavez, Colin,16032 | 90.95 | 0.00 | 0.00 | 90.95 | 0.00 |
| Gao, Tiffany, E,16352 | 5948.49 | 3578.27 | 0.00 | 0.00 | 2370.22 |
| Yang, Kevin, F,20605 | 84.96 | 0.00 | 0.00 | 84.96 | 0.00 |
| Pal, Terrence, M,13037 | 59.98 | 0.00 | 0.00 | 34.99 | 24.99 |
| Baker, Luke, J,22952 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Liang, Martha,16525 | 4752.75 | 3578.27 | 0.00 | 1174.48 | 0.00 |
| Pal, Tamara,12689 | 6846.92 | 0.00 | 2071.42 | 2331.95 | 2443.55 |
| Goel, Alejandro, K,13077 | 6766.63 | 0.00 | 2049.10 | 0.00 | 4717.53 |
| Kovár, Donald, M,24277 | 9.99 | 0.00 | 0.00 | 9.99 | 0.00 |
| Wu, Kelvin,24595 | 61.96 | 0.00 | 0.00 | 61.96 | 0.00 |
| Mr., Sands, Patrick,14063 | 5676.25 | 0.00 | 0.00 | 3321.26 | 2354.99 |
| Bradley, Emma,14211 | 5662.90 | 0.00 | 0.00 | 2049.10 | 3613.80 |
| Zhang, Susan, S,18216 | 38.92 | 0.00 | 0.00 | 8.99 | 29.93 |
| Suarez, Kristi, D,23099 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Ortega, Dwayne, C,24615 | 2155.92 | 0.00 | 1000.44 | 1155.48 | 0.00 |
| Zhang, Clarence, M,13001 | 6799.43 | 0.00 | 2049.10 | 2332.28 | 2418.05 |
| Moreno, Pedro, A,18248 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Andersen, Willie, M,27970 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Rai, Christy,16683 | 69.87 | 0.00 | 0.00 | 0.00 | 69.87 |
| Rana, Whitney, A,13006 | 6762.15 | 0.00 | 2049.10 | 0.00 | 4713.05 |
| Li, Jaclyn,18281 | 6081.10 | 0.00 | 3578.27 | 0.00 | 2502.83 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Zheng, Edwin, J,14216 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Garcia, Dalton, M,18768 | 5314.25 | 0.00 | 3578.27 | 1735.98 | 0.00 |
| Cai, Trisha,18265 | 64.98 | 0.00 | 0.00 | 0.00 | 64.98 |
| Chen, Willie, C,28322 | 29.48 | 0.00 | 0.00 | 29.48 | 0.00 |
| Sara, Cesar, C,22172 | 2932.30 | 0.00 | 2181.56 | 0.00 | 750.74 |
| Nath, Kara, S,21177 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Malhotra, Pedro,21559 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Hu, Glenn, R,24897 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nara, Melvin, E,27147 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Perez, Ebony, M,24900 | 2155.92 | 0.00 | 1000.44 | 1155.48 | 0.00 |
| Diaz, Dana, C,12361 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Thompson, Cameron, M,16620 | 5895.24 | 3578.27 | 0.00 | 0.00 | 2316.97 |
| Ruiz, Natasha,21994 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Bhat, Edwin,13079 | 6752.13 | 0.00 | 2049.10 | 0.00 | 4703.03 |
| Zhang, Dawn, A,14222 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Torres, Eddie, L,21985 | 3936.54 | 0.00 | 2181.56 | 0.00 | 1754.98 |
| Serrano, Rebekah,14130 | 3814.06 | 0.00 | 0.00 | 3814.06 | 0.00 |
| Wang, Curtis, A,13108 | 5718.66 | 0.00 | 0.00 | 2071.42 | 3647.24 |
| Wang, Trisha, V,17259 | 4404.73 | 3578.27 | 0.00 | 0.00 | 826.46 |
| Goel, Tommy,22909 | 3980.52 | 0.00 | 0.00 | 2181.56 | 1798.96 |
| Sara, Geoffrey,26188 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Vazquez, Joe, C,20418 | 4207.24 | 0.00 | 3578.27 | 628.97 | 0.00 |
| Moreno, Jimmy, L,11029 | 6565.29 | 3399.99 | 0.00 | 2408.97 | 756.33 |
| Romero, Philip, F,22195 | 4909.67 | 0.00 | 2443.35 | 0.00 | 2466.32 |
| Lal, Deborah, T,21982 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Cox, Jared, E,28114 | 570.47 | 0.00 | 0.00 | 570.47 | 0.00 |
| Gomez, Danny, V,16636 | 5932.74 | 3578.27 | 0.00 | 0.00 | 2354.47 |
| Lin, Claudia, A,14312 | 191.27 | 0.00 | 0.00 | 166.28 | 24.99 |
| Sai, Bruce,22194 | 4633.90 | 0.00 | 2181.56 | 0.00 | 2452.34 |
| Sharma, Jodi, N,18260 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Yuan, Cassie, J,24453 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Dominguez, Larry,22197 | 4740.98 | 0.00 | 2181.56 | 0.00 | 2559.42 |
| Srini, Douglas, M,16733 | 35.26 | 0.00 | 0.00 | 0.00 | 35.26 |
| Deng, Carl,18284 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Roberts, Jordan,23432 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Vazquez, Jerome,23116 | 3936.54 | 0.00 | 0.00 | 3936.54 | 0.00 |
| Martinez, Anna, J,12994 | 6855.44 | 0.00 | 2071.42 | 0.00 | 4784.02 |
| Alvarez, Gloria, B,18297 | 6119.59 | 0.00 | 3578.27 | 2541.32 | 0.00 |
| Raje, Lindsay, L,20613 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Chandra, Veronica,14681 | 5178.40 | 0.00 | 0.00 | 2049.10 | 3129.30 |
| Goel, Michele,15041 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Martin, Roy,22065 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Simmons, Jordyn,16494 | 5961.20 | 3578.27 | 0.00 | 0.00 | 2382.93 |
| Chandra, Arthur, L,14032 | 6859.43 | 0.00 | 0.00 | 2071.42 | 4788.01 |
| Ye, Erica, E,13010 | 5716.52 | 0.00 | 2071.42 | 0.00 | 3645.10 |
| Martinez, Emma,16734 | 128.97 | 0.00 | 0.00 | 49.99 | 78.98 |
| Patel, Monica, J,25234 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Hernandez, Frank, G,22198 | 4661.50 | 0.00 | 2181.56 | 0.00 | 2479.94 |
| Li, Lacey,17515 | 4143.26 | 3578.27 | 0.00 | 564.99 | 0.00 |
| Li, Colin, J,18445 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Wu, Clarence, L,13115 | 6779.42 | 0.00 | 0.00 | 2049.10 | 4730.32 |
| Chande, Bonnie, L,23992 | 3167.82 | 0.00 | 0.00 | 2443.35 | 724.47 |
| Raje, Grant, S,24162 | 3004.83 | 0.00 | 0.00 | 2443.35 | 561.48 |
| Alonso, Jonathon, A,15238 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Zhu, Dawn,26661 | 1912.47 | 0.00 | 0.00 | 782.99 | 1129.48 |
| Shen, Alisha, J,26438 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Blanco, Orlando,22575 | 3018.33 | 0.00 | 2443.35 | 0.00 | 574.98 |
| Raje, Johnny,13975 | 5138.72 | 0.00 | 0.00 | 2049.10 | 3089.62 |
| Diaz, Briana,13131 | 6737.15 | 0.00 | 0.00 | 2049.10 | 4688.05 |
| Serrano, Lori,17066 | 105.75 | 0.00 | 0.00 | 0.00 | 105.75 |
Generated 2024-09-20 06:58:07.685 UTC