[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1621 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wu, Amy,19790 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Rai, Christy,16683 | 69.87 | 0.00 | 0.00 | 0.00 | 69.87 |
| Yuan, Keith, N,22926 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Patel, Toni, E,25829 | 1894.07 | 0.00 | 699.10 | 0.00 | 1194.97 |
| McDonald, Brent,14068 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Mehta, Chelsea,22951 | 4242.31 | 0.00 | 0.00 | 2443.35 | 1798.96 |
| Munoz, Gloria, L,19789 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Ramos, Robyn, O,15828 | 172.25 | 0.00 | 0.00 | 0.00 | 172.25 |
| Lu, Sandra, N,13521 | 4514.77 | 0.00 | 0.00 | 4514.77 | 0.00 |
| Gutierrez, Ricky,19773 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Pal, Derek,24591 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Cox, Nicole, V,22950 | 3917.54 | 0.00 | 0.00 | 3917.54 | 0.00 |
| Barnes, Mariah, H,19621 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Nath, Kara, S,21177 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| West, Colleen, C,13128 | 6817.14 | 0.00 | 0.00 | 2049.10 | 4768.04 |
| Gonzalez, Tina,19653 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Chen, Randy,13004 | 190.27 | 0.00 | 0.00 | 0.00 | 190.27 |
| Arun, Brenda,13630 | 6824.73 | 0.00 | 0.00 | 2071.42 | 4753.31 |
| Vazquez, Hector, E,19772 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| Yuan, Maurice,24380 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzalez, Veronica, C,23311 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Rodriguez, Douglas, W,19652 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Diaz, Devin, D,15829 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Sai, Ronald, B,13643 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Guo, Jamie,20151 | 4152.73 | 0.00 | 3578.27 | 0.00 | 574.46 |
| Raje, Jenny,20233 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Andersen, Tonya, N,13527 | 4529.04 | 0.00 | 0.00 | 2049.10 | 2479.94 |
| Lopez, Kristina, L,20247 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Vance, George, R,12038 | 66.76 | 0.00 | 0.00 | 0.00 | 66.76 |
| Hughes, Lucas, E,26657 | 1357.97 | 0.00 | 0.00 | 1357.97 | 0.00 |
| Reed, Riley, A,20157 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Alvarez, Marc, B,18221 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Lopez, Carmen, S,13528 | 4531.04 | 0.00 | 0.00 | 2071.42 | 2459.62 |
| Mehta, Cesar, J,20241 | 5347.23 | 0.00 | 3578.27 | 0.00 | 1768.96 |
| Chapman, Pamela, L,27145 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Dominguez, Darren, M,13966 | 6842.12 | 0.00 | 0.00 | 2049.10 | 4793.02 |
| Zhu, Ernest,20159 | 4167.23 | 0.00 | 3578.27 | 0.00 | 588.96 |
| Gonzalez, Tabitha, A,26136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Munoz, Theresa, M,13953 | 6840.75 | 0.00 | 0.00 | 2071.42 | 4769.33 |
| Gill, Kristine,19977 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Romero, Meredith, J,29452 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Ramirez, Cole, E,13616 | 6872.06 | 0.00 | 0.00 | 2049.10 | 4822.96 |
| Ramos, Audrey,11976 | 8087.31 | 0.00 | 3374.99 | 0.00 | 4712.32 |
| Shan, Tony, M,16175 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Alvarez, Diana,13638 | 6832.12 | 0.00 | 0.00 | 2049.10 | 4783.02 |
| Lu, Jeffery, B,19971 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Blanco, Sheila, I,17724 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Liang, Darryl,26658 | 1390.95 | 0.00 | 0.00 | 1390.95 | 0.00 |
| Rai, Clayton, K,20446 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Davis, Nicole,22957 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Shan, Bethany, L,13973 | 5185.68 | 0.00 | 0.00 | 2071.42 | 3114.26 |
| Goel, Dale, M,20416 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Gutierrez, Pedro, S,15224 | 71.92 | 0.00 | 0.00 | 0.00 | 71.92 |
| Chandra, Tina, S,13974 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| Perez, Johnathan, D,20426 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| Gill, Sheila, B,17375 | 24.49 | 0.00 | 0.00 | 0.00 | 24.49 |
| Ortega, Max,23413 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Hu, Dennis, J,20600 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Gray, Morgan,28307 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Sai, Lydia, L,13968 | 5181.70 | 0.00 | 0.00 | 2071.42 | 3110.28 |
| Jai, Bonnie,11977 | 8212.50 | 0.00 | 3399.99 | 0.00 | 4812.51 |
| Blanco, Jimmy, V,14013 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Sai, Emmanuel,23417 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Kapoor, Kristina,11997 | 7029.78 | 0.00 | 3399.99 | 0.00 | 3629.79 |
| He, Jessie,29094 | 796.34 | 0.00 | 0.00 | 0.00 | 796.34 |
| Gomez, Kendra, J,23320 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Munoz, Audrey, V,12003 | 8256.50 | 0.00 | 3374.99 | 0.00 | 4881.51 |
| Rodriguez, Cynthia, E,22206 | 201.28 | 0.00 | 0.00 | 0.00 | 201.28 |
| Campbell, Jason, J,13625 | 6962.14 | 0.00 | 0.00 | 2049.10 | 4913.04 |
| Suri, Jarrod, E,12004 | 8114.04 | 0.00 | 3374.99 | 0.00 | 4739.05 |
| Vance, Kristopher, C,20407 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Li, Wesley,23322 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Ashe, Maurice,20430 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Zeng, Alisha, A,15727 | 134.46 | 0.00 | 0.00 | 0.00 | 134.46 |
| Zimmerman, Tiffany, E,23325 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Russell, Ashley,12000 | 8183.00 | 0.00 | 3399.99 | 0.00 | 4783.01 |
| Huang, Micah,25130 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Shan, Kristin,23416 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Deng, Barbara,20445 | 6078.71 | 0.00 | 3578.27 | 0.00 | 2500.44 |
| Perez, Edgar, B,29318 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Jimenez, Kathleen,26654 | 1346.76 | 0.00 | 0.00 | 1346.76 | 0.00 |
| Torres, Sabrina, E,20425 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Ramos, Meredith, A,23307 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Martinez, Monica, A,14129 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Vazquez, Joe, C,20418 | 4207.24 | 0.00 | 3578.27 | 0.00 | 628.97 |
| Arun, Barry,27700 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Fernandez, Cassandra, C,14134 | 3835.07 | 0.00 | 0.00 | 2049.10 | 1785.97 |
| Carlson, Jay,20264 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Diaz, Derrick, R,14853 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
| Patel, Jillian,26667 | 1390.95 | 0.00 | 0.00 | 782.99 | 607.96 |
| Hu, Leah,11994 | 8169.03 | 0.00 | 3374.99 | 0.00 | 4794.04 |
| Rubio, Juan,16170 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Powell, Adam,23423 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Serrano, Julio,20992 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| Carter, Sophia, D,25230 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Suarez, Dana, M,23541 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Xie, Mitchell, B,20993 | 4262.04 | 0.00 | 3578.27 | 0.00 | 683.77 |
| Vazquez, Arthur,28480 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Martinez, Brett,23532 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Ma, Autumn,20994 | 4191.72 | 0.00 | 3578.27 | 0.00 | 613.45 |
| Zheng, Omar, C,14522 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Zhou, Krystal,23593 | 3990.01 | 0.00 | 0.00 | 2181.56 | 1808.45 |
| Luo, Shawn,12246 | 3947.25 | 0.00 | 3374.99 | 0.00 | 572.26 |
| Walker, Austin, F,20229 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Anand, Johnny,14058 | 5652.52 | 0.00 | 0.00 | 2071.42 | 3581.10 |
| Rubio, Sabrina, A,20984 | 4153.25 | 0.00 | 3578.27 | 0.00 | 574.98 |
| Sharma, Andres, C,24230 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Diaz, Samuel,14065 | 5608.55 | 0.00 | 0.00 | 2071.42 | 3537.13 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 0.00 | 3623.79 |
| James, Brooke,18745 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Yang, Ronnie,23524 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Sara, Jarrod,20626 | 6038.56 | 0.00 | 3578.27 | 0.00 | 2460.29 |
| Sanchez, Michele,23543 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Hernandez, Alberto, D,25029 | 2272.20 | 0.00 | 0.00 | 1000.44 | 1271.76 |
| Morcos, Hany,20821 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Garcia, Darren,28716 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Hernandez, Raquel, W,13997 | 4586.35 | 0.00 | 0.00 | 2071.42 | 2514.93 |
| Liang, Gilbert,12242 | 3948.97 | 0.00 | 3374.99 | 0.00 | 573.98 |
| Beck, Bonnie, A,29097 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Ramos, Tanya, R,14045 | 6804.13 | 0.00 | 0.00 | 2049.10 | 4755.03 |
| Ruiz, Shannon,20822 | 4134.53 | 0.00 | 3578.27 | 0.00 | 556.26 |
| Ye, Brent,28922 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Romero, Latasha,14220 | 5696.19 | 0.00 | 0.00 | 2071.42 | 3624.77 |
| Hernandez, Philip,21193 | 3905.52 | 0.00 | 2181.56 | 0.00 | 1723.96 |
Generated 2025-12-24 06:05:10.807 UTC