[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| 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 |
| Xie, Cristina, C,17050 | 4496.23 | 3578.27 | 0.00 | 0.00 | 917.96 |
| 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 |
| Black, Michele,13995 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Dominguez, Ebony, R,17350 | 127.47 | 0.00 | 0.00 | 34.99 | 92.48 |
| Martin, Lance,25236 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Xu, Colin,15790 | 2668.38 | 0.00 | 0.00 | 2668.38 | 0.00 |
| Nara, Karla, C,25827 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| 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 |
| Kumar, Mindy, R,12700 | 6860.44 | 0.00 | 2071.42 | 0.00 | 4789.02 |
| Young, Morgan, L,12342 | 6838.12 | 0.00 | 2049.10 | 2369.96 | 2419.06 |
| Li, Cedric,27364 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Shan, Damien, M,11362 | 77.27 | 0.00 | 0.00 | 27.28 | 49.99 |
| Zheng, Omar, C,14522 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Ye, Valerie, C,28948 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Zhou, Louis, C,17912 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Nath, Omar, F,14672 | 5237.72 | 0.00 | 0.00 | 2071.42 | 3166.30 |
| Ortega, Renee,18447 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Gonzalez, Ann,11894 | 8223.00 | 0.00 | 3374.99 | 2394.97 | 2453.04 |
| Gill, Mallory, P,16698 | 197.88 | 0.00 | 0.00 | 0.00 | 197.88 |
| Gutierrez, Armando,29310 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Chande, Michele, C,13078 | 6850.46 | 0.00 | 2071.42 | 0.00 | 4779.04 |
| Tang, Colin,14323 | 5222.02 | 0.00 | 0.00 | 2071.42 | 3150.60 |
| Madan, Summer, D,12347 | 6839.12 | 0.00 | 2049.10 | 2370.96 | 2419.06 |
| Xie, Chad, A,26155 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Navarro, Francis, J,27520 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Navarro, Casey,19795 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| 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 |
| Guo, Leah, R,19562 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Torres, Kari,18486 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Ortega, Anne,13011 | 6819.11 | 0.00 | 2049.10 | 0.00 | 4770.01 |
| Goel, Carl, S,17249 | 4426.74 | 3578.27 | 0.00 | 0.00 | 848.47 |
| White, Kayla,26424 | 79.47 | 0.00 | 0.00 | 79.47 | 0.00 |
| Gutierrez, Gary, C,12701 | 6868.44 | 0.00 | 2071.42 | 0.00 | 4797.02 |
| Diaz, Tyrone,13116 | 230.25 | 0.00 | 0.00 | 32.27 | 197.98 |
| Goel, Barbara,12988 | 6915.44 | 0.00 | 2049.10 | 0.00 | 4866.34 |
| Huang, Crystal, L,26023 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Raman, Johnathan,19103 | 63.91 | 0.00 | 0.00 | 41.93 | 21.98 |
| Prasad, Arthur,14275 | 5158.37 | 0.00 | 0.00 | 2800.44 | 2357.93 |
| Munoz, Craig, V,13076 | 6862.14 | 0.00 | 2049.10 | 0.00 | 4813.04 |
| Suarez, Joy, B,12665 | 74.54 | 0.00 | 0.00 | 0.00 | 74.54 |
| Yang, Alan, L,15605 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Martin, Naomi, A,15593 | 116.26 | 0.00 | 0.00 | 88.98 | 27.28 |
| Yang, Wesley, K,15127 | 5182.73 | 0.00 | 0.00 | 2071.42 | 3111.31 |
| Patterson, Jennifer, M,15129 | 5177.73 | 0.00 | 0.00 | 2071.42 | 3106.31 |
| Powell, Alexis, M,23531 | 3337.28 | 0.00 | 0.00 | 3337.28 | 0.00 |
| Gutierrez, Natasha,17048 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| She, Christine,16184 | 78.20 | 0.00 | 0.00 | 0.00 | 78.20 |
| Harris, Ian, W,14128 | 3836.38 | 0.00 | 0.00 | 3836.38 | 0.00 |
| Zhu, Colleen,17252 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| He, Omar,15831 | 2646.36 | 0.00 | 0.00 | 2646.36 | 0.00 |
| Xu, Tracy, L,17916 | 4787.74 | 3578.27 | 0.00 | 0.00 | 1209.47 |
| Sara, Ann, A,23576 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ortega, Danny, K,19794 | 6098.58 | 0.00 | 3578.27 | 0.00 | 2520.31 |
| Sai, Terrance,19106 | 64.95 | 0.00 | 0.00 | 21.98 | 42.97 |
| Huang, Colleen, S,21379 | 2992.33 | 0.00 | 2443.35 | 0.00 | 548.98 |
| Kumar, Yolanda, J,18194 | 85.96 | 0.00 | 0.00 | 0.00 | 85.96 |
| Ye, Tamara, A,20243 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Hernandez, Wendy, A,15124 | 122.44 | 0.00 | 0.00 | 0.00 | 122.44 |
| Tang, Grant, H,11466 | 90.19 | 0.00 | 0.00 | 0.00 | 90.19 |
| Pal, Alison,13042 | 84.47 | 0.00 | 0.00 | 0.00 | 84.47 |
| Andersen, Tracy,20815 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Zeng, Colleen, L,28304 | 91.97 | 0.00 | 0.00 | 91.97 | 0.00 |
| Zhao, Glenn, C,14221 | 82.26 | 0.00 | 0.00 | 49.99 | 32.27 |
| Vazquez, Ross,11148 | 126.24 | 0.00 | 0.00 | 53.99 | 72.25 |
| Ruiz, Sabrina, A,22214 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| She, Mindy, J,13009 | 168.67 | 0.00 | 0.00 | 0.00 | 168.67 |
| King, Hailey, A,28214 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Raje, Jodi, E,19630 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Lin, Ronnie, D,21384 | 2921.02 | 0.00 | 2181.56 | 0.00 | 739.46 |
| Jenkins, Anna, M,17234 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Martinez, Anna, J,12994 | 6855.44 | 0.00 | 2071.42 | 0.00 | 4784.02 |
| Wu, Amy,19790 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Li, Vincent, D,21207 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Vazquez, Jésus,26665 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Hernandez, Clinton,29462 | 854.82 | 0.00 | 0.00 | 0.00 | 854.82 |
| Green, Fernando,17258 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Barnes, Alexia, D,15231 | 59.48 | 0.00 | 0.00 | 0.00 | 59.48 |
| Shan, Colleen, D,15150 | 4379.08 | 0.00 | 0.00 | 2049.10 | 2329.98 |
| Serrano, Pedro,26189 | 1926.45 | 0.00 | 782.99 | 0.00 | 1143.46 |
| Wilson, Zachary,25558 | 1307.06 | 699.10 | 0.00 | 0.00 | 607.96 |
| Jones, Ethan,13051 | 6831.74 | 0.00 | 2071.42 | 0.00 | 4760.32 |
| Bhat, Edwin,13079 | 6752.13 | 0.00 | 2049.10 | 0.00 | 4703.03 |
| Sai, Ivan, E,17300 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Gomez, Adrienne,11920 | 8156.32 | 0.00 | 3374.99 | 0.00 | 4781.33 |
| Mehta, Nancy,18189 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Sanz, Craig, M,21993 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Chandra, Monica, H,18898 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Martinez, Abby,29333 | 54.98 | 0.00 | 0.00 | 54.98 | 0.00 |
| Black, Tracy, B,24903 | 2164.91 | 0.00 | 1000.44 | 1164.47 | 0.00 |
| Lopez, Terrance, T,14217 | 139.45 | 0.00 | 0.00 | 89.46 | 49.99 |
| Romero, Jimmy,27704 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Sun, Micah,24887 | 2218.90 | 0.00 | 1000.44 | 1218.46 | 0.00 |
| Zhao, Randy, J,27874 | 1288.31 | 0.00 | 0.00 | 1288.31 | 0.00 |
| Lopez, Francisco, L,18714 | 24.27 | 0.00 | 0.00 | 21.98 | 2.29 |
| Rogers, Seth, R,14318 | 138.45 | 0.00 | 0.00 | 63.97 | 74.48 |
| Chande, Latoya, M,23309 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Ruiz, Frank, M,14260 | 3716.23 | 0.00 | 0.00 | 2964.89 | 751.34 |
| Sun, Krystal,18908 | 6090.59 | 0.00 | 3578.27 | 2512.32 | 0.00 |
| Madan, Meagan,11767 | 8319.51 | 0.00 | 3399.99 | 2475.97 | 2443.55 |
| Ramos, Audrey,11976 | 8087.31 | 0.00 | 3374.99 | 2319.26 | 2393.06 |
| Gill, Eddie, J,12715 | 74.54 | 0.00 | 0.00 | 64.97 | 9.57 |
| Rana, Bryant,21878 | 4663.79 | 0.00 | 2181.56 | 0.00 | 2482.23 |
| She, Latoya, A,11750 | 8148.02 | 0.00 | 3399.99 | 2349.98 | 2398.05 |
| Pal, Terry, H,25824 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Chander, Melvin, L,24266 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Ashe, Katie, Z,26770 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Serrano, Dana, S,12678 | 341.43 | 0.00 | 0.00 | 248.46 | 92.97 |
| Gill, Meredith, E,24268 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Shen, Brendan, L,14305 | 3652.20 | 0.00 | 0.00 | 2049.10 | 1603.10 |
| Perez, Geoffrey, P,21000 | 2721.55 | 0.00 | 2181.56 | 0.00 | 539.99 |
| Madan, Joe,29300 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Raje, Shawn,17054 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Vazquez, Latasha,21952 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Prasad, Meagan,19611 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| She, Melvin,16516 | 4733.75 | 3578.27 | 0.00 | 1155.48 | 0.00 |
Generated 2024-09-20 00:11:15.251 UTC