[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 30 SKIP 0 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wang, Randy, G,25125 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Zhang, Suzanne, R,20316 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Dominguez, Leslie,27346 | 1390.95 | 0.00 | 0.00 | 782.99 | 607.96 |
| Prasad, Edgar, E,17306 | 117.96 | 0.00 | 0.00 | 0.00 | 117.96 |
| Vazquez, Ross,11148 | 126.24 | 0.00 | 0.00 | 0.00 | 126.24 |
| Wang, Laura, L,26146 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Suri, Allen,21553 | 4666.50 | 0.00 | 0.00 | 2181.56 | 2484.94 |
| Raje, Darrell,20252 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Martin, Marc, J,11039 | 6636.58 | 0.00 | 3399.99 | 0.00 | 3236.59 |
| Shen, Shaun,12684 | 6893.08 | 0.00 | 0.00 | 2049.10 | 4843.98 |
| Serrano, Mathew, A,29186 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Rodriguez, Jonathan, J,13046 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Liang, Darryl,26658 | 1390.95 | 0.00 | 0.00 | 1390.95 | 0.00 |
| Ross, Adam,11099 | 8215.99 | 0.00 | 3399.99 | 0.00 | 4816.00 |
| Hu, Jenny, A,16634 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Nara, Johnny, R,18489 | 6081.10 | 0.00 | 3578.27 | 0.00 | 2502.83 |
| Suarez, Danny,20995 | 4127.25 | 0.00 | 3578.27 | 0.00 | 548.98 |
| Raje, Wayne, A,21372 | 74.96 | 0.00 | 0.00 | 0.00 | 74.96 |
| Wu, Nuan,29293 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Hernandez, Hailey, A,18727 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Mehta, Edgar,11761 | 8149.49 | 0.00 | 3399.99 | 0.00 | 4749.50 |
| Deng, Colleen, S,27728 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Pal, Alison,13042 | 84.47 | 0.00 | 0.00 | 0.00 | 84.47 |
| Malhotra, Janelle,26425 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Moreno, Roberto, R,21206 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Nara, Cedric, M,21875 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Oliver, Lee,29119 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Hernandez, Jessie, A,24172 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| He, Kelli, A,28872 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Andersen, Ashlee, J,11059 | 116.93 | 0.00 | 0.00 | 0.00 | 116.93 |
| Shan, Gregory,20614 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Gonzalez, Kristopher, C,19264 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Raje, Mario, S,20427 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Zeng, Ernest, M,12992 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
| Ye, Valerie, C,28948 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Luo, Warren,23562 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gao, Christy, D,26204 | 1967.45 | 0.00 | 0.00 | 782.99 | 1184.46 |
| Wright, Haley,26036 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Serrano, Tabitha,28327 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Ramos, Jerome, L,29187 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Jai, Jodi, M,27971 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Kumar, Mindy, R,12700 | 6860.44 | 0.00 | 0.00 | 2071.42 | 4789.02 |
| He, Jon, L,14262 | 5652.54 | 0.00 | 0.00 | 2071.42 | 3581.12 |
| Lopez, Virginia, J,27338 | 1339.92 | 0.00 | 0.00 | 782.99 | 556.93 |
| Kumar, Misty, H,25010 | 1540.43 | 0.00 | 0.00 | 1000.44 | 539.99 |
| Zheng, Randy, B,22574 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Yuan, Maurice,24380 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ramos, Monique,16495 | 6002.23 | 3578.27 | 0.00 | 0.00 | 2423.96 |
| Gutierrez, Jill, N,26024 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Prasad, Dominic, D,19962 | 46.75 | 0.00 | 0.00 | 0.00 | 46.75 |
| Luo, Michele,26027 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Beck, Alejandro,11025 | 6576.80 | 3374.99 | 0.00 | 2405.47 | 796.34 |
| Nath, Jaime,11033 | 6495.29 | 0.00 | 3374.99 | 0.00 | 3120.30 |
| Romero, Deanna, K,23570 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Lu, Crystal, A,15145 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Hernandez, Audrey,18290 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Patel, Toni, E,25829 | 1894.07 | 0.00 | 699.10 | 0.00 | 1194.97 |
| Kapoor, Dominic, J,16699 | 67.58 | 0.00 | 0.00 | 0.00 | 67.58 |
| Ramos, Lance, S,28949 | 2473.05 | 0.00 | 0.00 | 0.00 | 2473.05 |
| Nara, Katrina, Z,24608 | 2120.93 | 0.00 | 1000.44 | 0.00 | 1120.49 |
| Liu, Brittney, M,15804 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Mehta, Cassandra,23014 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Hernandez, Joe,15154 | 84.98 | 0.00 | 0.00 | 0.00 | 84.98 |
| Navarro, Jonathon,18722 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Shan, Tasha,15192 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| _SUM | 9051988.22 | 188094.03 | 2486908.01 | 2218695.11 | 4158291.07 |
| Ramos, Briana, J,14303 | 3636.91 | 0.00 | 0.00 | 2049.10 | 1587.81 |
| Wood, Fernando, K,24253 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Chander, Marshall,19090 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Beck, Alicia, L,17248 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Xie, Michele, M,15039 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Dominguez, Theodore, F,21987 | 4638.89 | 0.00 | 0.00 | 2181.56 | 2457.33 |
| Rana, Darren, M,17257 | 4480.73 | 0.00 | 3578.27 | 0.00 | 902.46 |
| Kelly, Zoe,23123 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Navarro, Meredith,27703 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Carlson, Lance, E,22856 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ruiz, Gloria,12343 | 5567.93 | 0.00 | 2049.10 | 0.00 | 3518.83 |
| Torres, Michele, A,16176 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Sanchez, Abby, J,19966 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Black, Tracy, B,24903 | 2164.91 | 0.00 | 0.00 | 1000.44 | 1164.47 |
| Powell, Thomas, R,18218 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Ma, Jeffery,18264 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Subram, Evelyn, S,21257 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Tang, Shawn,25832 | 1850.86 | 0.00 | 699.10 | 0.00 | 1151.76 |
| Lal, Nicolas, D,21212 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Anand, Cassie, M,29342 | 801.83 | 0.00 | 0.00 | 0.00 | 801.83 |
| Zeng, Cara,20444 | 6085.59 | 0.00 | 3578.27 | 0.00 | 2507.32 |
| Lopez, Pamela, E,26444 | 1938.71 | 0.00 | 0.00 | 782.99 | 1155.72 |
| Dominguez, Gina, L,20213 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Madan, Joe,29300 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Reed, Steven,24373 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Ramirez, Jessica, R,29192 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Nath, Dale, B,27343 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Yuan, Bradley,17920 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Muñoz, Ruben, L,11451 | 8249.49 | 0.00 | 3399.99 | 0.00 | 4849.50 |
| Pal, Tasha,22853 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Zheng, Alisha,22203 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Alvarez, Rodney, D,29286 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Prasad, Preston, C,20812 | 4127.25 | 0.00 | 3578.27 | 0.00 | 548.98 |
| Allen, Logan,15812 | 81.25 | 0.00 | 0.00 | 0.00 | 81.25 |
| Wang, Micah, C,14676 | 5188.41 | 0.00 | 0.00 | 2049.10 | 3139.31 |
| Randall, Toni,16605 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Gutierrez, Clinton,21001 | 3018.33 | 0.00 | 2443.35 | 0.00 | 574.98 |
| Lal, Mitchell, C,20403 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Chavez, Kurt, C,23563 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Yuan, Alicia,25225 | 2129.92 | 0.00 | 0.00 | 1000.44 | 1129.48 |
| Ashe, Briana,22940 | 4207.32 | 0.00 | 0.00 | 4207.32 | 0.00 |
| Prasad, George, C,15767 | 4379.09 | 0.00 | 0.00 | 2049.10 | 2329.99 |
| Zhou, Carol, L,24454 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Zhang, Louis, K,20227 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Pal, Drew,11902 | 63.04 | 0.00 | 0.00 | 0.00 | 63.04 |
| Hu, Barbara,19567 | 104.96 | 0.00 | 0.00 | 0.00 | 104.96 |
| Goel, Bradley,15803 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Chen, Aimee,26591 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| She, Colin, M,15139 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Deng, Colin, B,18299 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Suri, Carmen, E,24250 | 2738.49 | 0.00 | 0.00 | 2181.56 | 556.93 |
| Moreno, Diana, J,29298 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Vance, Kristopher, C,20407 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Muñoz, Jaime, C,24506 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Pal, Tamara,12689 | 6846.92 | 0.00 | 0.00 | 2071.42 | 4775.50 |
| Sullivan, Toni, M,29083 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Alonso, Armando, M,13647 | 6793.15 | 0.00 | 0.00 | 2049.10 | 4744.05 |
| Xie, Cristina, C,17050 | 4496.23 | 0.00 | 3578.27 | 0.00 | 917.96 |
| Chande, Ricardo, L,24471 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2026-01-04 14:20:27.525 UTC