[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 20 < SKIP 500 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Yang, Connor,17735 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Tang, Drew, W,15178 | 4445.06 | 0.00 | 0.00 | 2049.10 | 2395.96 |
| Holt, Krystal,16518 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Andersen, Warren,11919 | 8171.52 | 0.00 | 3374.99 | 0.00 | 4796.53 |
| Bradley, Victoria,29454 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Raje, Kelli, A,28136 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Carlson, Mathew, A,23012 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| She, Sharon, F,22017 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hill, Aaron,25818 | 35.96 | 0.00 | 0.00 | 0.00 | 35.96 |
| Sara, Ross,24367 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Wang, Shannon,11017 | 6434.31 | 3374.99 | 0.00 | 2316.97 | 742.35 |
| Sai, Martin, L,21221 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Perez, Kevin, M,25565 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Gao, Eugene,29464 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Stone, Denise,11032 | 6525.56 | 0.00 | 3374.99 | 0.00 | 3150.57 |
| Gonzalez, Carolyn, H,22407 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Kapoor, Rachael, D,11911 | 62.46 | 0.00 | 0.00 | 0.00 | 62.46 |
| Gutierrez, Victor, J,27357 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Liu, Krystal, D,13526 | 4549.76 | 0.00 | 0.00 | 2071.42 | 2478.34 |
| Shan, Drew,23659 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Wu, Clarence, L,13115 | 6779.42 | 0.00 | 0.00 | 2049.10 | 4730.32 |
| Suarez, Daisy, A,18288 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Vazquez, Shannon,26035 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Ashe, Jimmy, S,28959 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Taylor, Jennifer,18470 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Prasad, Arthur,14275 | 5158.37 | 0.00 | 0.00 | 2049.10 | 3109.27 |
| Mehta, Michele,26143 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Ortega, Julio, M,11892 | 8119.03 | 0.00 | 3399.99 | 0.00 | 4719.04 |
| Hu, Marshall, H,26797 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Evans, Jonathan, D,15185 | 4393.70 | 0.00 | 0.00 | 2071.42 | 2322.28 |
| Hernandez, Hailey, A,18727 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Martinez, Fernando,20454 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Chander, Alisha,12572 | 2611.41 | 0.00 | 2071.42 | 0.00 | 539.99 |
| Perez, Cesar, L,27982 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Jiménez, Bruce, L,23640 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Rodriguez, Pedro, L,17911 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Chander, Damien,11080 | 8204.02 | 0.00 | 3374.99 | 2359.98 | 2469.05 |
| She, Willie,17055 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Goel, Bradley,15803 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| He, Eugene, L,13645 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Suarez, Meghan, L,22177 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Navarro, Julio, M,25822 | 1819.59 | 0.00 | 699.10 | 0.00 | 1120.49 |
| Watson, Alexandra, H,25249 | 1868.56 | 699.10 | 0.00 | 0.00 | 1169.46 |
| Nath, Melvin, D,27697 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Carlson, Lance, E,22856 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martin, Ruben,22400 | 2737.82 | 0.00 | 0.00 | 2181.56 | 556.26 |
| Campbell, Seth,18716 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Perry, Madison, R,23308 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wu, Ernest, L,11147 | 8195.50 | 0.00 | 3374.99 | 0.00 | 4820.51 |
| Navarro, Jacquelyn,15465 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Powell, Kaitlyn,19598 | 5310.53 | 0.00 | 3578.27 | 0.00 | 1732.26 |
| Gutierrez, Dana,20254 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Hill, Alex, C,19787 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Martinez, Sarah, S,12670 | 6785.13 | 0.00 | 0.00 | 2049.10 | 4736.03 |
| Patel, Kaitlin, L,16615 | 95.84 | 0.00 | 0.00 | 0.00 | 95.84 |
| Ma, Franklin,24485 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Sanchez, Bryant, C,13113 | 6832.41 | 0.00 | 0.00 | 2071.42 | 4760.99 |
| Andersen, Ashlee, J,11059 | 116.93 | 0.00 | 0.00 | 0.00 | 116.93 |
| Guo, Ernest,25717 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Goldstein, Dustin,12337 | 8137.01 | 0.00 | 3399.99 | 0.00 | 4737.02 |
| Arun, Brenda,13630 | 6824.73 | 0.00 | 0.00 | 2071.42 | 4753.31 |
| Chandra, Monica, H,18898 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Shan, Yolanda,12702 | 6911.10 | 0.00 | 0.00 | 2049.10 | 4862.00 |
| Kapoor, Phillip,27581 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Mehta, Regina,17245 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Yang, Curtis,11110 | 8093.03 | 0.00 | 3399.99 | 0.00 | 4693.04 |
| Perez, Brett, M,28313 | 647.94 | 0.00 | 0.00 | 0.00 | 647.94 |
| Yuan, Keith, N,22926 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Deng, Jodi,16161 | 2700.05 | 0.00 | 0.00 | 2049.10 | 650.95 |
| Yuan, Warren, P,19091 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Kapoor, Patricia, R,21883 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Shen, Roger, G,14011 | 3831.89 | 0.00 | 0.00 | 2071.42 | 1760.47 |
| Raje, Arturo, C,14228 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Ruiz, Krista, C,13081 | 6772.15 | 0.00 | 0.00 | 2049.10 | 4723.05 |
| Johnston, Joanna, L,17296 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Lee, Dalton, J,16931 | 4767.73 | 0.00 | 3578.27 | 0.00 | 1189.46 |
| Patel, Ann,21371 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lal, Warren, B,25246 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Munoz, Felicia, D,20406 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Ruiz, Leslie, J,26032 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sai, Frederick,20991 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Zhou, Ernest, P,15792 | 2645.40 | 0.00 | 0.00 | 2071.42 | 573.98 |
| Vance, Kristi, T,28338 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Coleman, Paige, L,15263 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Anand, Leonard,14316 | 3797.37 | 0.00 | 0.00 | 2049.10 | 1748.27 |
| Griffin, Rachel,18255 | 6067.20 | 0.00 | 3578.27 | 0.00 | 2488.93 |
| Perez, Ross, E,14307 | 196.26 | 0.00 | 0.00 | 0.00 | 196.26 |
| Jimenez, Joy,28312 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Russell, Cassidy, N,26144 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| She, Brittney, M,22942 | 3971.53 | 0.00 | 0.00 | 2181.56 | 1789.97 |
| Romero, Clinton, F,28132 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Ferrier, Leslie, M,28535 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Hernandez, Melody, E,28212 | 619.46 | 0.00 | 0.00 | 0.00 | 619.46 |
| Srini, Beth, A,25913 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Hernandez, Alberto, D,25029 | 2272.20 | 0.00 | 0.00 | 1000.44 | 1271.76 |
| Ramos, Audrey,11976 | 8087.31 | 0.00 | 3374.99 | 0.00 | 4712.32 |
| Raji, Bradley, E,17925 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Saunders, Patricia, J,19565 | 5308.24 | 0.00 | 3578.27 | 0.00 | 1729.97 |
| Goel, Bethany,27511 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Liu, Dawn, C,21960 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Malhotra, Brett, E,18731 | 6054.06 | 0.00 | 3578.27 | 0.00 | 2475.79 |
| Rai, Clayton, K,20446 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Torres, Neil,17305 | 196.97 | 0.00 | 0.00 | 0.00 | 196.97 |
| Gonzalez, Eric, C,19092 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Diaz, Cheryl, A,11092 | 8110.02 | 0.00 | 3374.99 | 2341.97 | 2393.06 |
| Lu, Jamie, M,23646 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Becker, Kara,21167 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Garcia, Edgar, A,17729 | 110.46 | 0.00 | 0.00 | 0.00 | 110.46 |
| Martinez, Jermaine, L,15170 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Ramos, Gloria, A,21365 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lopez, Heidi,11052 | 8131.32 | 0.00 | 3374.99 | 2337.27 | 2419.06 |
| Sanz, Craig, M,21993 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Flores, Antonio, D,14259 | 3630.93 | 0.00 | 0.00 | 2049.10 | 1581.83 |
| Green, Devin, J,26440 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Mr., Shen, Alan,24257 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Xu, Margaret, T,22404 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Wang, Erica, J,22168 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Cai, Steve, M,22155 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sharma, Cedric, A,14060 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Diaz, Frank, F,29086 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Rana, Cindy,21367 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Griffin, Noah, E,29118 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Rubio, Randall, M,17286 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Gonzalez, Kristopher, C,19264 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
Generated 2026-01-04 08:54:42.576 UTC