[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE SKIP 0 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Jimenez, Melody, S,14066 | 3612.19 | 0.00 | 0.00 | 2853.57 | 758.62 |
| Xu, Cara,23526 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Gomez, Armando, S,21175 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Zheng, Barbara,27493 | 1353.46 | 0.00 | 0.00 | 782.99 | 570.47 |
| Alvarez, Desiree,13005 | 223.97 | 0.00 | 0.00 | 0.00 | 223.97 |
| Prasad, Ross,28963 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Xie, Dawn,21391 | 29.99 | 0.00 | 0.00 | 29.99 | 0.00 |
| Fernandez, Arthur, J,22399 | 2785.05 | 0.00 | 0.00 | 2181.56 | 603.49 |
| Chen, Jake,22845 | 4633.90 | 0.00 | 0.00 | 2181.56 | 2452.34 |
| Patel, Jay,22213 | 59.27 | 0.00 | 0.00 | 59.27 | 0.00 |
| Johnson, Elizabeth,11004 | 8196.01 | 3399.99 | 0.00 | 2376.96 | 2419.06 |
| Vazquez, Shannon,26035 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Fernandez, Brandy, B,22958 | 4208.31 | 0.00 | 0.00 | 2443.35 | 1764.96 |
| Pal, Lacey, K,26571 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Huang, Alan, A,12671 | 6802.13 | 0.00 | 2049.10 | 0.00 | 4753.03 |
| Diaz, Josue,15207 | 4446.40 | 0.00 | 0.00 | 2071.42 | 2374.98 |
| Yuan, Calvin,17905 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Cox, Isaac,15797 | 4415.68 | 0.00 | 0.00 | 2071.42 | 2344.26 |
| Harrison, Colleen, L,20219 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Brooks, Jared,24476 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Chapman, Pamela, L,27145 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Vazquez, Mallory, M,18283 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Ramos, Adrienne, L,28216 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Suarez, Joy, B,12665 | 74.54 | 0.00 | 0.00 | 0.00 | 74.54 |
| Lal, Jodi, J,22944 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Rana, Terrance, M,28134 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Wang, Jaclyn, M,17063 | 100.25 | 0.00 | 0.00 | 37.27 | 62.98 |
| Srini, Joe,22180 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Andersen, Ashlee, J,11059 | 116.93 | 0.00 | 0.00 | 116.93 | 0.00 |
| Gomez, Hector, A,29337 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Suarez, Briana, A,15266 | 2935.37 | 0.00 | 0.00 | 2071.42 | 863.95 |
| Guo, Jamie,20151 | 4152.73 | 0.00 | 3578.27 | 574.46 | 0.00 |
| She, Valerie, C,20226 | 6067.20 | 0.00 | 3578.27 | 0.00 | 2488.93 |
| Shen, Michele,27985 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Ye, Vincent,13013 | 256.24 | 0.00 | 0.00 | 0.00 | 256.24 |
| Sun, Mandy, L,16694 | 78.20 | 0.00 | 0.00 | 39.22 | 38.98 |
| Vazquez, Neil, K,28719 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Raje, Dale, H,27746 | 628.97 | 0.00 | 0.00 | 628.97 | 0.00 |
| Andersen, Lacey,19600 | 94.46 | 0.00 | 0.00 | 0.00 | 94.46 |
| Chen, Erica, P,18308 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Gill, Anne,27469 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Zhou, Jamie,17327 | 99.94 | 0.00 | 0.00 | 0.00 | 99.94 |
| Sanchez, Troy, H,25559 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Perez, Joel,16684 | 4158.24 | 3578.27 | 0.00 | 0.00 | 579.97 |
| Zheng, Randy, B,22574 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Luo, Roger, J,18728 | 56.71 | 0.00 | 0.00 | 0.00 | 56.71 |
| Chow, Amy, E,12699 | 6798.13 | 0.00 | 2049.10 | 0.00 | 4749.03 |
| Xu, Wesley, K,29182 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Yang, Kevin, F,20605 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Li, Kristen, R,15153 | 113.97 | 0.00 | 0.00 | 88.98 | 24.99 |
| Moreno, Robin,19563 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Becker, Kara,21167 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Evans, Adam, H,25820 | 48.97 | 0.00 | 0.00 | 48.97 | 0.00 |
| Raji, Kathryn, C,21995 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Chander, Julie, E,18763 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Gill, Diana,25710 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Vazquez, Kristine, M,17736 | 4742.74 | 0.00 | 3578.27 | 0.00 | 1164.47 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Rubio, Natasha, K,13627 | 214.25 | 0.00 | 0.00 | 66.97 | 147.28 |
| Andersen, Rafael, E,12691 | 247.46 | 0.00 | 0.00 | 0.00 | 247.46 |
| Raje, Johnny,13975 | 5138.72 | 0.00 | 0.00 | 2049.10 | 3089.62 |
| Gonzalez, Veronica, C,23311 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Zheng, Kristen, J,24463 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Chen, Crystal, M,26566 | 2016.95 | 0.00 | 0.00 | 782.99 | 1233.96 |
| Malhotra, Heidi, A,26426 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sai, Cesar,18243 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Ashe, Ebony, E,16612 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Romero, Max, C,29316 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Cai, Candice,26747 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Bradley, Victoria,29454 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Pal, Clayton,27721 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Navarro, Erik, E,25055 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Martin, Ruben,22400 | 2737.82 | 0.00 | 0.00 | 2181.56 | 556.26 |
| Vance, Phillip,29308 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Raji, Sheena, J,18213 | 6070.59 | 0.00 | 3578.27 | 2492.32 | 0.00 |
| Lal, Clarence, L,24470 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Torres, Danielle, G,22947 | 75.97 | 0.00 | 0.00 | 75.97 | 0.00 |
| Jones, Nathan,15024 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Ma, Darryl, R,15599 | 81.24 | 0.00 | 0.00 | 0.00 | 81.24 |
| Sullivan, Carla, A,20611 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zheng, Edwin, J,14216 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Kumar, Yolanda, J,18194 | 85.96 | 0.00 | 0.00 | 0.00 | 85.96 |
| Alvarez, Albert, R,16624 | 5938.25 | 3578.27 | 0.00 | 0.00 | 2359.98 |
| Ma, Roger, V,15130 | 5215.40 | 0.00 | 0.00 | 2049.10 | 3166.30 |
| Munoz, Briana,23437 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lal, Drew, A,28325 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Rana, Darren, M,17257 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Xu, Karl,23321 | 3060.82 | 0.00 | 0.00 | 2443.35 | 617.47 |
| Alonso, Brandi,17061 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Chander, Alison,18249 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Torres, Carolyn,15261 | 70.74 | 0.00 | 0.00 | 0.00 | 70.74 |
| Gao, Bianca, C,13112 | 5717.89 | 0.00 | 0.00 | 2049.10 | 3668.79 |
| Zhao, Jaclyn, D,26167 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Liu, Trisha, V,20214 | 5304.25 | 0.00 | 3578.27 | 0.00 | 1725.98 |
| Ma, Curtis,28119 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Sai, Ronald, B,13643 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Ward, Brooke,13007 | 5671.24 | 0.00 | 0.00 | 2071.42 | 3599.82 |
| Sun, Edwin, O,21170 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Gonzalez, Dominique, J,27976 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Chande, Willie, B,16163 | 2641.39 | 0.00 | 0.00 | 2071.42 | 569.97 |
| Martinez, Clifford,23087 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Fernandez, Brenda, L,16493 | 4197.25 | 3578.27 | 0.00 | 0.00 | 618.98 |
| Alan, Jamie, S,21224 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Deng, Johnny,21409 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Pais, Wilson, C,13038 | 5581.26 | 0.00 | 0.00 | 2071.42 | 3509.84 |
| Simmons, Gabrielle,29183 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Vance, Ruth, D,17302 | 147.44 | 0.00 | 0.00 | 58.98 | 88.46 |
| Zhu, Roger, J,28098 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Garcia, Sarah,11907 | 8135.33 | 0.00 | 3399.99 | 2297.28 | 2438.06 |
| Carlson, Robin,19786 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Ortega, Janet, L,11754 | 8163.53 | 0.00 | 3399.99 | 2319.99 | 2443.55 |
| Shan, Jaime,22020 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Diaz, Carolyn, C,24360 | 3626.82 | 0.00 | 0.00 | 2443.35 | 1183.47 |
| Sanz, Monique, R,24273 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| She, Jeffery, M,27149 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Li, Margaret,15753 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Chavez, Clayton,21949 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Wood, Jacqueline,16705 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Anderson, Blake,11076 | 8159.04 | 0.00 | 3399.99 | 2374.98 | 2384.07 |
| Guo, Cedric, R,27487 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Zeng, Ramon,27979 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Barnes, Isabella, J,25239 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Perez, Bryant, L,15042 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Srini, Darren, P,15591 | 4346.38 | 0.00 | 0.00 | 2049.10 | 2297.28 |
| Zhou, Brent,15434 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
Generated 2024-11-10 06:27:43.987 UTC