[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 125 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Madan, Denise, R,25248 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Mr., Schmidt, Steve,15789 | 4486.07 | 0.00 | 0.00 | 2049.10 | 2436.97 |
| Alonso, Jimmy, T,18280 | 126.56 | 0.00 | 0.00 | 0.00 | 126.56 |
| Ramos, Carolyn,17926 | 4715.70 | 0.00 | 3578.27 | 0.00 | 1137.43 |
| Lal, Alisha, C,21872 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Xie, Lindsey, M,25132 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Torres, Wendy, A,18269 | 6113.20 | 0.00 | 3578.27 | 0.00 | 2534.93 |
| Lewis, Nicole,21881 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Campbell, Haley, L,17304 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Gomez, Derrick,18694 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Beck, Alisha, E,11463 | 47.92 | 0.00 | 0.00 | 7.95 | 39.97 |
| Rana, Jermaine, S,28927 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Fernandez, Denise, A,18724 | 6056.51 | 0.00 | 3578.27 | 2478.24 | 0.00 |
| Munoz, Kendra, S,23529 | 3617.83 | 0.00 | 0.00 | 3617.83 | 0.00 |
| Martin, Adrienne,19952 | 39.46 | 0.00 | 0.00 | 25.48 | 13.98 |
| Sai, Rachael,11912 | 8095.32 | 0.00 | 3374.99 | 0.00 | 4720.33 |
| Lopez, Sergio, L,15123 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Martin, Briana, L,15213 | 2818.59 | 0.00 | 0.00 | 2049.10 | 769.49 |
| Carlson, Marie,29311 | 603.96 | 0.00 | 0.00 | 0.00 | 603.96 |
| Suarez, Hector, L,15034 | 103.45 | 0.00 | 0.00 | 0.00 | 103.45 |
| Goel, Chad,28219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ma, Roger, V,15130 | 5215.40 | 0.00 | 0.00 | 2049.10 | 3166.30 |
| Chandra, Jarrod,24171 | 3006.31 | 0.00 | 0.00 | 2443.35 | 562.96 |
| Chow, Christy, M,12681 | 6784.13 | 0.00 | 2049.10 | 0.00 | 4735.03 |
| Rubio, Tanya, I,15598 | 167.93 | 0.00 | 0.00 | 0.00 | 167.93 |
| Dominguez, Walter,12576 | 2653.07 | 0.00 | 2049.10 | 0.00 | 603.97 |
| Patterson, Melissa, E,12668 | 6839.46 | 0.00 | 2071.42 | 0.00 | 4768.04 |
| Alvarez, Erik, M,14311 | 138.45 | 0.00 | 0.00 | 74.48 | 63.97 |
| Ross, Adam,11099 | 8215.99 | 0.00 | 3399.99 | 2363.96 | 2452.04 |
| Patterson, Antonio, G,11963 | 8068.03 | 0.00 | 3374.99 | 2294.99 | 2398.05 |
| Kumar, Tommy,17297 | 100.25 | 0.00 | 0.00 | 37.27 | 62.98 |
| Srini, Cindy, E,26026 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Zeng, Claudia, M,16696 | 4506.76 | 3578.27 | 0.00 | 928.49 | 0.00 |
| Li, Cara,27587 | 1145.48 | 0.00 | 0.00 | 0.00 | 1145.48 |
| Guo, Jaclyn,13119 | 6829.45 | 0.00 | 0.00 | 2071.42 | 4758.03 |
| Chavez, Clayton,21949 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Subram, Stefanie,12371 | 214.04 | 0.00 | 0.00 | 0.00 | 214.04 |
| Nara, Calvin, J,11367 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Mr., Solanki, Ajay,18295 | 144.27 | 0.00 | 0.00 | 0.00 | 144.27 |
| Xu, Tara,19592 | 5377.23 | 0.00 | 3578.27 | 0.00 | 1798.96 |
| Jimenez, Joy,28312 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Liu, Christy,19784 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Yuan, Deborah,12021 | 4043.46 | 0.00 | 3399.99 | 0.00 | 643.47 |
| Lal, Darrell,19953 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Gill, Hector, M,26187 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Shen, Wayne, P,23647 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Liu, Jenny,16165 | 81.81 | 0.00 | 0.00 | 0.00 | 81.81 |
| 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 |
| Guo, Lacey,16744 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Black, Tracy, B,24903 | 2164.91 | 0.00 | 0.00 | 2164.91 | 0.00 |
| Perez, Whitney,16619 | 97.58 | 0.00 | 0.00 | 67.59 | 29.99 |
| Jiménez, Deanna,28115 | 562.96 | 0.00 | 0.00 | 562.96 | 0.00 |
| Young, Marcus, A,18494 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Coleman, Brittany,15579 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Anderson, Emily, M,25220 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Flores, Noah,17256 | 4362.74 | 0.00 | 3578.27 | 0.00 | 784.47 |
| Long, Julian,12034 | 72.25 | 0.00 | 0.00 | 0.00 | 72.25 |
| Raman, Summer, C,25949 | 1882.57 | 0.00 | 699.10 | 0.00 | 1183.47 |
| Perez, Joe, A,14326 | 5207.70 | 0.00 | 0.00 | 2071.42 | 3136.28 |
| Diaz, Stacy, L,12340 | 6752.13 | 0.00 | 2049.10 | 0.00 | 4703.03 |
| Xie, Cristina, C,17050 | 4496.23 | 3578.27 | 0.00 | 0.00 | 917.96 |
| Perez, Marie,13996 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Chande, Carl,18932 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Gomez, Hector, A,29337 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Sanz, Kari, V,27341 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Garcia, Andre, H,12705 | 6854.11 | 0.00 | 0.00 | 2049.10 | 4805.01 |
| Raje, Louis, M,25707 | 1262.06 | 0.00 | 699.10 | 0.00 | 562.96 |
| Arthur, Jay, R,12694 | 6785.13 | 0.00 | 2049.10 | 0.00 | 4736.03 |
| Zhu, Christy,11003 | 8139.29 | 3399.99 | 0.00 | 2318.96 | 2420.34 |
| Sanz, Victor,17295 | 4392.74 | 3578.27 | 0.00 | 0.00 | 814.47 |
| She, Sheena, R,23008 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Torres, Ruben,11002 | 8114.04 | 3399.99 | 0.00 | 4714.05 | 0.00 |
| Rana, Meredith,25032 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Nara, Cristina, R,19792 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Munoz, Theresa, M,13953 | 6840.75 | 0.00 | 0.00 | 2071.42 | 4769.33 |
| Rai, Tonya,25243 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Zhou, Stacey, L,21374 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Ward, Haley, J,16631 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Gill, Eddie, J,12715 | 74.54 | 0.00 | 0.00 | 64.97 | 9.57 |
| He, Kelli, A,28872 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Cooper, Victoria, S,13637 | 6777.13 | 0.00 | 0.00 | 2049.10 | 4728.03 |
| Zhou, Krystal,23593 | 3990.01 | 0.00 | 0.00 | 2181.56 | 1808.45 |
| Ruiz, Frank, M,14260 | 3716.23 | 0.00 | 0.00 | 2964.89 | 751.34 |
| Gao, Tiffany, E,16352 | 5948.49 | 3578.27 | 0.00 | 0.00 | 2370.22 |
| He, Dennis, J,27878 | 1283.82 | 0.00 | 0.00 | 0.00 | 1283.82 |
| Ramos, Audrey,11976 | 8087.31 | 0.00 | 3374.99 | 2319.26 | 2393.06 |
| Ashe, Ebony, E,16612 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Green, Jennifer,12571 | 2641.39 | 0.00 | 2071.42 | 0.00 | 569.97 |
| Andersen, Nicolas, A,27594 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Nara, Clayton,11768 | 8139.04 | 0.00 | 3399.99 | 2319.99 | 2419.06 |
| Munoz, Robyn,14214 | 5759.87 | 0.00 | 0.00 | 2049.10 | 3710.77 |
| Liu, Clayton, L,21373 | 15.23 | 0.00 | 0.00 | 15.23 | 0.00 |
| Huang, Eugene, L,11001 | 6383.88 | 3374.99 | 0.00 | 2419.93 | 588.96 |
| Raji, Michele,15183 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Mehta, Edgar,11761 | 8149.49 | 0.00 | 3399.99 | 2356.44 | 2393.06 |
| Perez, Ross, E,14307 | 196.26 | 0.00 | 0.00 | 159.00 | 37.26 |
| Raman, Abby, T,15122 | 5193.72 | 0.00 | 0.00 | 2071.42 | 3122.30 |
| Tang, Leonard, L,28109 | 778.62 | 0.00 | 0.00 | 778.62 | 0.00 |
| Andersen, Willie, M,27970 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Gonzalez, Joel, A,15043 | 3846.89 | 0.00 | 0.00 | 2071.42 | 1775.47 |
| Sai, Cassandra, R,28110 | 845.31 | 0.00 | 0.00 | 845.31 | 0.00 |
| Madan, Toni,26668 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Yang, Wesley, K,15127 | 5182.73 | 0.00 | 0.00 | 2071.42 | 3111.31 |
| Gill, Stacy,12679 | 187.98 | 0.00 | 0.00 | 24.99 | 162.99 |
| Xie, Dustin,22204 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Luo, Lacey,24175 | 2743.04 | 0.00 | 0.00 | 2181.56 | 561.48 |
| Sharma, Cedric, A,14060 | 99.47 | 0.00 | 0.00 | 49.99 | 49.48 |
| Zhang, Warren, L,25252 | 1893.05 | 699.10 | 0.00 | 0.00 | 1193.95 |
| Zeng, Amy,24242 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Romero, Paula, B,16691 | 4471.74 | 3578.27 | 0.00 | 893.47 | 0.00 |
| Chen, Willie, C,28322 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Browning, Jay, M,24251 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Rubio, Kathleen, A,20820 | 4143.74 | 0.00 | 3578.27 | 565.47 | 0.00 |
| Ramos, Monique,16495 | 6002.23 | 3578.27 | 0.00 | 0.00 | 2423.96 |
| Xu, Jaclyn,24252 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Ortega, Renee,18447 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Hu, Glenn, R,24897 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gomez, Teresa, D,24164 | 2760.02 | 0.00 | 0.00 | 2181.56 | 578.46 |
| Gutierrez, Armando,29310 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Brown, Cameron, D,13041 | 153.95 | 0.00 | 0.00 | 0.00 | 153.95 |
| Chander, Keith, A,24174 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Navarro, Francis, J,27520 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Tang, Drew, W,15178 | 4445.06 | 0.00 | 0.00 | 2049.10 | 2395.96 |
Generated 2024-11-10 08:51:15.294 UTC