[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Gonzalez, Rebekah, A,16927 | 30.97 | 0.00 | 0.00 | 30.97 | 0.00 |
| Nara, Katrina, Z,24608 | 2120.93 | 0.00 | 1000.44 | 1120.49 | 0.00 |
| Coleman, Dalton, M,23412 | 3586.81 | 0.00 | 0.00 | 3586.81 | 0.00 |
| Weber, Deanna, L,14855 | 3759.08 | 0.00 | 0.00 | 2049.10 | 1709.98 |
| Ye, Amy,11073 | 191.90 | 0.00 | 0.00 | 103.96 | 87.94 |
| Lee, Dalton, J,16931 | 4767.73 | 3578.27 | 0.00 | 0.00 | 1189.46 |
| Ms., Salavaria, Sharon,11964 | 8173.53 | 0.00 | 3399.99 | 2329.99 | 2443.55 |
| Diaz, Samuel,14065 | 5608.55 | 0.00 | 0.00 | 3286.27 | 2322.28 |
| Davis, Nicole,22957 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Huang, Lisa, L,14102 | 3667.23 | 0.00 | 0.00 | 2910.90 | 756.33 |
| Li, Dawn, B,13962 | 40.22 | 0.00 | 0.00 | 40.22 | 0.00 |
| Lal, Julie, A,28309 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Vazquez, Lawrence,19632 | 56.98 | 0.00 | 0.00 | 56.98 | 0.00 |
| Rana, Cindy,21367 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Ramos, Craig,14209 | 193.97 | 0.00 | 0.00 | 4.99 | 188.98 |
| Raman, Allen, R,25129 | 60.47 | 0.00 | 0.00 | 60.47 | 0.00 |
| Chande, Melvin, R,11460 | 8137.52 | 0.00 | 3399.99 | 2294.99 | 2442.54 |
| Martinez, Emma,16734 | 128.97 | 0.00 | 0.00 | 49.99 | 78.98 |
| Zhou, Carol, L,24454 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Shan, Franklin, C,27718 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Alonso, Jonathon, A,15238 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Rodriguez, Kristi,14345 | 3639.92 | 0.00 | 0.00 | 2049.10 | 1590.82 |
| Diaz, Dana, C,12361 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Vazquez, Diane, D,11987 | 279.23 | 0.00 | 0.00 | 0.00 | 279.23 |
| Thompson, Michael, M,26148 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Zhu, Roger, J,28098 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Andersen, Kate,14237 | 90.25 | 0.00 | 0.00 | 31.27 | 58.98 |
| Jimenez, Julio,24005 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| He, Jessie,29094 | 796.34 | 0.00 | 0.00 | 0.00 | 796.34 |
| Suarez, Neil,15242 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Malhotra, Mayra, E,15577 | 143.45 | 0.00 | 0.00 | 83.97 | 59.48 |
| Fernandez, Kristi,19585 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Rivera, Nathaniel, M,14051 | 5606.91 | 0.00 | 0.00 | 3286.92 | 2319.99 |
| Liu, Warren,15014 | 3860.87 | 0.00 | 0.00 | 2071.42 | 1789.45 |
| Suarez, Alfredo,19601 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Rana, Johnathan, R,27497 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Fernandez, Geoffrey,19963 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Martinez, Daniel, P,17725 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Navarro, Janet, J,28320 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gonzalez, Francisco, L,12245 | 3967.26 | 0.00 | 3399.99 | 0.00 | 567.27 |
| Torres, Joanna, E,24464 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lin, Jeffery, J,27347 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Gao, Todd, M,11061 | 8129.02 | 3374.99 | 0.00 | 2369.96 | 2384.07 |
| Vazquez, Byron,11122 | 42.93 | 0.00 | 0.00 | 7.95 | 34.98 |
| Chande, Warren,17307 | 132.95 | 0.00 | 0.00 | 132.95 | 0.00 |
| Kapoor, Bryant,22946 | 3911.53 | 0.00 | 0.00 | 3911.53 | 0.00 |
| Chavez, Colin,16032 | 90.95 | 0.00 | 0.00 | 90.95 | 0.00 |
| Li, Kristen, R,15153 | 113.97 | 0.00 | 0.00 | 88.98 | 24.99 |
| Cai, Vincent, L,11757 | 58.05 | 0.00 | 0.00 | 24.49 | 33.56 |
| Zhang, Susan, S,18216 | 38.92 | 0.00 | 0.00 | 8.99 | 29.93 |
| Cai, Roger, A,13002 | 294.94 | 0.00 | 0.00 | 167.99 | 126.95 |
| Henderson, Wyatt,16697 | 87.08 | 0.00 | 0.00 | 57.09 | 29.99 |
| Cox, Jared, E,28114 | 570.47 | 0.00 | 0.00 | 570.47 | 0.00 |
| Madan, Jay, L,20156 | 4139.75 | 0.00 | 3578.27 | 561.48 | 0.00 |
| Nelson, Carol,13520 | 4551.36 | 0.00 | 0.00 | 4551.36 | 0.00 |
| Zeng, Heather, E,18287 | 72.16 | 0.00 | 0.00 | 72.16 | 0.00 |
| Madan, Marco,18895 | 27.77 | 0.00 | 0.00 | 27.77 | 0.00 |
| Zhang, Suzanne, R,20316 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Huang, Lacey, J,11951 | 63.52 | 0.00 | 0.00 | 0.00 | 63.52 |
| 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 |
| Munoz, Ebony,13106 | 5697.52 | 0.00 | 0.00 | 2071.42 | 3626.10 |
| Anderson, Victoria,15799 | 4423.38 | 0.00 | 0.00 | 2071.42 | 2351.96 |
| Shan, Connor, C,18901 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Sara, Edgar, A,11104 | 8173.03 | 3399.99 | 0.00 | 2334.98 | 2438.06 |
| Liu, Jessie,11106 | 8079.05 | 0.00 | 3399.99 | 2294.99 | 2384.07 |
| Rai, Sharon,20225 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Rana, Raymond,25115 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Kapoor, Abby, J,29054 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Sai, Evelyn,20415 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Luo, Christine, J,24159 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Morgan, Carlos,25819 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Alvarez, Linda,14047 | 5643.54 | 0.00 | 0.00 | 3321.26 | 2322.28 |
| Hernandez, Max,18192 | 63.97 | 0.00 | 0.00 | 34.99 | 28.98 |
| Stone, Christine, D,25948 | 1819.59 | 0.00 | 699.10 | 0.00 | 1120.49 |
| Harris, Thomas,24002 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Gomez, Teresa, D,24164 | 2760.02 | 0.00 | 0.00 | 2181.56 | 578.46 |
| Rana, Ross,25240 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Moreno, Hector,21183 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Xu, Alison,14227 | 114.96 | 0.00 | 0.00 | 49.99 | 64.97 |
| Smith, Kristi, M,21962 | 35.00 | 0.00 | 0.00 | 35.00 | 0.00 |
| Yuan, Franklin,24594 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Bryant, Lauren,11752 | 137.87 | 0.00 | 0.00 | 77.96 | 59.91 |
| Dominguez, Ebony, R,17350 | 127.47 | 0.00 | 0.00 | 34.99 | 92.48 |
| Xu, Colin,15790 | 2668.38 | 0.00 | 0.00 | 2668.38 | 0.00 |
| Tang, Rafael, A,11908 | 8079.05 | 0.00 | 3374.99 | 2319.99 | 2384.07 |
| Serrano, Linda,11071 | 110.23 | 0.00 | 0.00 | 42.26 | 67.97 |
| Vazquez, Juan, P,22578 | 2735.53 | 0.00 | 2181.56 | 0.00 | 553.97 |
| Suri, Shane, L,25126 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Ruiz, Marie, J,27498 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Gill, Kellie,17292 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Chander, Cassie, M,18258 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Patel, Gerald,23095 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bailey, Melissa, C,19572 | 82.25 | 0.00 | 0.00 | 23.78 | 58.47 |
| Deng, Gilbert, C,15765 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Chande, Michele, C,13078 | 6850.46 | 0.00 | 2071.42 | 0.00 | 4779.04 |
| Rivera, Jada,21970 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Guo, Tiffany,25927 | 1272.52 | 0.00 | 699.10 | 0.00 | 573.42 |
| Suarez, Briana, A,15266 | 2935.37 | 0.00 | 0.00 | 2071.42 | 863.95 |
| Kumar, Alejandro,14055 | 5177.40 | 0.00 | 0.00 | 2049.10 | 3128.30 |
| Russell, Ashley,12000 | 8183.00 | 0.00 | 3399.99 | 2309.97 | 2473.04 |
| Gonzales, Alexis,23521 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Blanco, Philip, M,15603 | 39.97 | 0.00 | 0.00 | 24.99 | 14.98 |
| Li, Cedric,27364 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Ye, Valerie, C,28948 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Gonzalez, Ann,11894 | 8223.00 | 0.00 | 3374.99 | 2394.97 | 2453.04 |
| Campbell, Seth,18716 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Sanz, Roy, R,11917 | 8121.33 | 0.00 | 3399.99 | 2337.27 | 2384.07 |
| Torres, Kari,18486 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| White, Kayla,26424 | 79.47 | 0.00 | 0.00 | 79.47 | 0.00 |
| Raji, Tammy, K,17071 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Simmons, Jacqueline, W,13137 | 177.94 | 0.00 | 0.00 | 112.97 | 64.97 |
| Brown, Cameron, D,13041 | 153.95 | 0.00 | 0.00 | 88.98 | 64.97 |
| Li, Jenny, B,22169 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Nara, Rafael, J,17052 | 96.92 | 0.00 | 0.00 | 42.93 | 53.99 |
| Yang, Clarence, D,25121 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Prasad, Clifford,15604 | 66.75 | 0.00 | 0.00 | 0.00 | 66.75 |
| Martin, Anne, V,25034 | 2164.91 | 0.00 | 0.00 | 1000.44 | 1164.47 |
| Sandberg, Kristine,12241 | 3989.46 | 0.00 | 3399.99 | 0.00 | 589.47 |
| Nath, Omar, F,14672 | 5237.72 | 0.00 | 0.00 | 2071.42 | 3166.30 |
| Gill, Ricky, A,15607 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| She, Jenny,27586 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Gao, Bianca, C,13112 | 5717.89 | 0.00 | 0.00 | 2049.10 | 3668.79 |
| Williams, Alexis, D,14674 | 142.47 | 0.00 | 0.00 | 0.00 | 142.47 |
| Black, Michele,13995 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
Generated 2024-09-19 21:45:58.340 UTC