[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 750 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lal, Kurt, R,14015 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Raje, April, R,18744 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Vazquez, Ross,11148 | 126.24 | 0.00 | 0.00 | 0.00 | 126.24 |
| Sanchez, Ross,28310 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Tang, Willie, A,25939 | 1264.57 | 0.00 | 699.10 | 0.00 | 565.47 |
| Navarro, Carolyn,11069 | 8104.05 | 0.00 | 3399.99 | 2319.99 | 2384.07 |
| Sanz, Jésus,29313 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Ye, Erica, E,13010 | 5716.52 | 0.00 | 0.00 | 2071.42 | 3645.10 |
| Dominguez, Theodore, F,21987 | 4638.89 | 0.00 | 0.00 | 2181.56 | 2457.33 |
| Romero, Gary,22181 | 4673.88 | 0.00 | 0.00 | 2181.56 | 2492.32 |
| Ramos, Kristine,17479 | 163.40 | 0.00 | 0.00 | 0.00 | 163.40 |
| Rodriguez, Ruben,12589 | 2665.06 | 0.00 | 0.00 | 2049.10 | 615.96 |
| Gutierrez, Hector,26423 | 2001.97 | 0.00 | 0.00 | 782.99 | 1218.98 |
| Martinez, Bruce, D,18452 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Lu, Glenn,12692 | 156.26 | 0.00 | 0.00 | 0.00 | 156.26 |
| Carlson, Wendy,20220 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Martin, Renee, L,17478 | 4758.24 | 0.00 | 3578.27 | 0.00 | 1179.97 |
| Raje, Gilbert,11055 | 8168.01 | 3374.99 | 0.00 | 2394.97 | 2398.05 |
| Sharma, Jerry, C,13651 | 6812.12 | 0.00 | 0.00 | 2049.10 | 4763.02 |
| Ramos, Jessie, R,11764 | 8129.02 | 0.00 | 3399.99 | 0.00 | 4729.03 |
| Blanco, Jésus, E,20448 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Sanz, Meghan, L,28352 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Liu, Jenny,16165 | 81.81 | 0.00 | 0.00 | 0.00 | 81.81 |
| Navarro, Erik, E,25055 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Martinez, Roy, J,13969 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Martin, Marc, J,11039 | 6636.58 | 3399.99 | 0.00 | 0.00 | 3236.59 |
| Raje, Derek,12574 | 2626.39 | 0.00 | 2071.42 | 0.00 | 554.97 |
| Gomez, Carrie,22965 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ma, Jeffery,18264 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 0.00 | 3623.79 |
| Zhou, Laura, D,12683 | 6801.45 | 0.00 | 0.00 | 2071.42 | 4730.03 |
| Raman, Ronald, M,17077 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Carlson, Marc, W,17501 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Alexander, David,15783 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Xie, Kelli, J,20452 | 6156.70 | 0.00 | 3578.27 | 0.00 | 2578.43 |
| Ramos, Larry,18446 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Sanz, Paula,26430 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Shan, Jenny, W,16706 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Nara, Dustin, M,17910 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Suri, Carmen, E,24250 | 2738.49 | 0.00 | 0.00 | 2181.56 | 556.93 |
| Gao, Louis,14666 | 5199.92 | 0.00 | 0.00 | 2049.10 | 3150.82 |
| Young, Morgan, L,12342 | 6838.12 | 0.00 | 2049.10 | 0.00 | 4789.02 |
| Long, Nicole, C,13624 | 114.97 | 0.00 | 0.00 | 0.00 | 114.97 |
| Garcia, George,20160 | 4237.22 | 0.00 | 3578.27 | 0.00 | 658.95 |
| Mehta, Gerald,20234 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Zhang, Susan, S,18216 | 38.92 | 0.00 | 0.00 | 0.00 | 38.92 |
| Smith, Adriana,18702 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Rodriguez, Rachael, M,11944 | 4776.27 | 0.00 | 3374.99 | 0.00 | 1401.28 |
| Alvarez, Gloria, B,18297 | 6119.59 | 0.00 | 3578.27 | 0.00 | 2541.32 |
| Madan, Marco,18895 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Zhang, Suzanne, R,20316 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martin, Roy,22065 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Zheng, Omar, C,14522 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Goel, Mario, J,12360 | 6750.48 | 0.00 | 2071.42 | 0.00 | 4679.06 |
| Li, Crystal, L,14325 | 5152.70 | 0.00 | 0.00 | 2049.10 | 3103.60 |
| Shan, Jaime,22020 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Schmidt, Kaitlin,13628 | 191.25 | 0.00 | 0.00 | 0.00 | 191.25 |
| Huang, Crystal, L,26023 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Xu, Alison,14227 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Torres, Naomi, J,14061 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Dominguez, Andy, L,14126 | 135.55 | 0.00 | 0.00 | 0.00 | 135.55 |
| Coleman, Luis, L,14230 | 5661.90 | 0.00 | 0.00 | 2049.10 | 3612.80 |
| Sanz, Tabitha,17496 | 110.96 | 0.00 | 0.00 | 0.00 | 110.96 |
| Xu, Brad,26157 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Barnes, Isabella, J,25239 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sun, Mandy, L,16694 | 78.20 | 0.00 | 0.00 | 0.00 | 78.20 |
| Patterson, Jennifer, M,15129 | 5177.73 | 0.00 | 0.00 | 2071.42 | 3106.31 |
| She, Christine,16184 | 78.20 | 0.00 | 0.00 | 0.00 | 78.20 |
| Li, Cedric,27364 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Lin, Laura, L,11462 | 8116.33 | 0.00 | 3374.99 | 0.00 | 4741.34 |
| Sharma, Carl,21375 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ortega, Janet, L,11754 | 8163.53 | 0.00 | 3399.99 | 0.00 | 4763.54 |
| Torres, Kari,18486 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Liu, Steve, V,23523 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Zhu, Louis,14858 | 196.97 | 0.00 | 0.00 | 0.00 | 196.97 |
| Zeng, Stacey, J,17317 | 128.95 | 0.00 | 0.00 | 0.00 | 128.95 |
| Blanco, Victor,15586 | 4469.37 | 0.00 | 0.00 | 2071.42 | 2397.95 |
| Sun, Erica, P,26135 | 1967.45 | 0.00 | 0.00 | 782.99 | 1184.46 |
| Li, Lisa, J,24600 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| She, Mindy, J,13009 | 168.67 | 0.00 | 0.00 | 0.00 | 168.67 |
| Vazquez, Danny, J,26033 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
| Gomez, Derrick,18694 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Xu, Clayton,18488 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Shen, Corey,26739 | 61.97 | 0.00 | 0.00 | 0.00 | 61.97 |
| Rubio, Marie, V,20618 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Torres, Marc,11765 | 8143.03 | 0.00 | 3374.99 | 0.00 | 4768.04 |
| Hernandez, Clinton,29462 | 854.82 | 0.00 | 0.00 | 0.00 | 854.82 |
| Gutierrez, Gary, C,12701 | 6868.44 | 0.00 | 0.00 | 2071.42 | 4797.02 |
| Carson, Mitchell,13623 | 99.20 | 0.00 | 0.00 | 0.00 | 99.20 |
| Barnes, Alexia, D,15231 | 59.48 | 0.00 | 0.00 | 0.00 | 59.48 |
| Xu, Alicia,11370 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Shan, Colleen, D,15150 | 4379.08 | 0.00 | 0.00 | 2049.10 | 2329.98 |
| Navarro, Dana, J,11125 | 79.69 | 0.00 | 0.00 | 7.95 | 71.74 |
| Alvarez, Erik, M,14311 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Flores, Antonio, D,14259 | 3630.93 | 0.00 | 0.00 | 2049.10 | 1581.83 |
| Andersen, Tracy,20815 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Patterson, Antonio, G,11963 | 8068.03 | 0.00 | 3374.99 | 0.00 | 4693.04 |
| Weber, Cory,16739 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Zhao, Glenn, C,14221 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Garcia, Sarah,11907 | 8135.33 | 0.00 | 3399.99 | 0.00 | 4735.34 |
| Romero, Walter, A,25020 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Rana, Bryant,21878 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Ramos, Byron,14306 | 3653.23 | 0.00 | 0.00 | 2071.42 | 1581.81 |
| Pal, Terry, H,25824 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jones, Destiny,15171 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Jenkins, Wyatt,27987 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Sanz, Renee, L,14319 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Dominguez, Jerome, F,22987 | 3942.03 | 0.00 | 0.00 | 2181.56 | 1760.47 |
| Vazquez, Anne,16027 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 0.00 | 782.99 | 578.46 |
| Xu, Alisha,14100 | 226.26 | 0.00 | 0.00 | 0.00 | 226.26 |
| Rubio, Max, L,19578 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Alexander, Gail, C,14682 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Russell, Alexis, L,13634 | 234.93 | 0.00 | 0.00 | 0.00 | 234.93 |
| Coleman, Brittany,15579 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Yang, Ronnie,23524 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Diaz, Megan, A,24303 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Raman, Meagan, J,15134 | 5151.71 | 0.00 | 0.00 | 2071.42 | 3080.29 |
| Li, Karen, K,17921 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Blanco, Brandi, L,20986 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Zhou, Brent,15434 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Patel, Abby,16029 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Pal, Lacey, K,26571 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Vazquez, Eddie, T,14012 | 5249.92 | 0.00 | 0.00 | 2049.10 | 3200.82 |
Generated 2025-12-21 20:45:13.323 UTC