[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 248 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Arun, Denise,28218 | 18.97 | 0.00 | 0.00 | 0.00 | 18.97 |
| Flores, Brianna,27706 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Zhou, Clayton,27348 | 1382.46 | 0.00 | 0.00 | 782.99 | 599.47 |
| Raji, Tammy, K,17071 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Li, Jenny, B,22169 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Powell, Aaron,25241 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yuan, Warren, P,19091 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Ortega, Jill, A,20239 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Yang, Clarence, D,25121 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Rubio, Kristy,12243 | 3914.98 | 0.00 | 3374.99 | 0.00 | 539.99 |
| Hill, Jennifer,18291 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Martin, Deanna,13091 | 6864.95 | 0.00 | 0.00 | 2071.42 | 4793.53 |
| Butler, Jose,29064 | 815.81 | 0.00 | 0.00 | 0.00 | 815.81 |
| Alexander, Alyssa, M,17282 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Diaz, Cheryl, A,11092 | 8110.02 | 0.00 | 3374.99 | 2341.97 | 2393.06 |
| Pal, Mindy,19097 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Alvarez, Larry, T,14235 | 5682.20 | 0.00 | 0.00 | 2071.42 | 3610.78 |
| Moreno, Roy, J,19951 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zhang, Louis, K,20227 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Martin, Tabitha,25269 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Pal, Drew,11902 | 63.04 | 0.00 | 0.00 | 0.00 | 63.04 |
| Liang, Rosa, L,19770 | 4127.25 | 0.00 | 3578.27 | 0.00 | 548.98 |
| Kapoor, Kristina,11997 | 7029.78 | 0.00 | 3399.99 | 0.00 | 3629.79 |
| Sharma, Christian,15809 | 62.59 | 0.00 | 0.00 | 0.00 | 62.59 |
| Chande, Warren,17307 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| Kapoor, Bryant,22946 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Anand, Andrés,11096 | 8063.04 | 0.00 | 3374.99 | 0.00 | 4688.05 |
| Chander, Tommy,19086 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Moreno, Pedro, A,18248 | 6037.89 | 0.00 | 3578.27 | 0.00 | 2459.62 |
| Xie, Marshall, M,19796 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Cox, Jared, E,28114 | 570.47 | 0.00 | 0.00 | 0.00 | 570.47 |
| Gao, Arturo,28714 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Gonzalez, Devin,18485 | 6063.21 | 0.00 | 3578.27 | 0.00 | 2484.94 |
| Deng, Carl,18284 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Moreno, Tabitha,19959 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| He, Amy,22411 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Kumar, Karl, J,14218 | 5651.88 | 0.00 | 0.00 | 2049.10 | 3602.78 |
| Hu, Alvin, E,11449 | 8130.32 | 0.00 | 3374.99 | 2362.27 | 2393.06 |
| Andersen, Mitchell, H,25026 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Dominguez, Ebony, R,17350 | 127.47 | 0.00 | 0.00 | 0.00 | 127.47 |
| Xu, Colin,15790 | 2668.38 | 0.00 | 0.00 | 2071.42 | 596.96 |
| Morgan, Nathaniel, E,16626 | 71.57 | 0.00 | 0.00 | 0.00 | 71.57 |
| Shan, Kristin,23416 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Washington, Marcus,28329 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Prasad, Francisco,16628 | 187.58 | 0.00 | 0.00 | 0.00 | 187.58 |
| Goel, Ricardo, T,25961 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Alvarez, Tyrone, K,27693 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Hernandez, Jaime,24170 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Gill, Jay,27975 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Zheng, Sandra, P,15141 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Wu, Aimee,16690 | 165.07 | 0.00 | 0.00 | 0.00 | 165.07 |
| Tang, Christy, R,23660 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Raman, Geoffrey, P,15435 | 3801.39 | 0.00 | 0.00 | 2071.42 | 1729.97 |
| Ross, Mya, E,27715 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| She, Kristin, L,19961 | 97.97 | 0.00 | 0.00 | 0.00 | 97.97 |
| Zhao, Lacey, M,27713 | 1158.96 | 0.00 | 0.00 | 0.00 | 1158.96 |
| Rana, Terrance, M,28134 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| James, Brooke,18745 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Nelson, Julia, L,11102 | 102.91 | 0.00 | 0.00 | 0.00 | 102.91 |
| Raman, Shane,16661 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| Sai, Molly,14683 | 98.95 | 0.00 | 0.00 | 0.00 | 98.95 |
| Gao, Rafael, R,18733 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Xu, Colleen, C,18325 | 108.85 | 0.00 | 0.00 | 0.00 | 108.85 |
| Navarro, Jacquelyn,15465 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Garcia, Chelsea,21961 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Henderson, Dalton,24895 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Shan, Bethany, L,13973 | 5185.68 | 0.00 | 0.00 | 2071.42 | 3114.26 |
| Cai, Jeffery, A,15582 | 2907.56 | 0.00 | 0.00 | 2049.10 | 858.46 |
| Dominguez, Robin,16685 | 4183.23 | 3578.27 | 0.00 | 0.00 | 604.96 |
| Dominguez, Kristine, A,14020 | 6831.76 | 0.00 | 0.00 | 2071.42 | 4760.34 |
| Sanz, Lawrence, M,14030 | 6905.47 | 0.00 | 0.00 | 2071.42 | 4834.05 |
| Suarez, Ruben,14031 | 6964.42 | 0.00 | 0.00 | 2049.10 | 4915.32 |
| Alvarez, Albert, R,16624 | 5938.25 | 3578.27 | 0.00 | 0.00 | 2359.98 |
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 2294.99 | 2438.06 |
| Raji, Katrina, M,16517 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Gutierrez, Jonathon, R,16529 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Gonzales, Logan,16607 | 5897.53 | 3578.27 | 0.00 | 0.00 | 2319.26 |
| Zheng, Rosa, G,16629 | 5933.26 | 3578.27 | 0.00 | 0.00 | 2354.99 |
| Beck, Alejandro,11025 | 6576.80 | 3374.99 | 0.00 | 2405.47 | 796.34 |
| Arun, Cory, O,16527 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Fernandez, Manuel, A,16514 | 4761.74 | 3578.27 | 0.00 | 0.00 | 1183.47 |
| Liang, Kelvin, L,16616 | 5915.54 | 3578.27 | 0.00 | 0.00 | 2337.27 |
| Arthur, Tabitha, E,16482 | 4783.74 | 3578.27 | 0.00 | 0.00 | 1205.47 |
| Gao, Tiffany, E,16352 | 5948.49 | 3578.27 | 0.00 | 0.00 | 2370.22 |
| Huang, Damien,16524 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Ramos, Monique,16495 | 6002.23 | 3578.27 | 0.00 | 0.00 | 2423.96 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Moreno, Jimmy, L,11029 | 6565.29 | 3399.99 | 0.00 | 0.00 | 3165.30 |
| Johnson, Elizabeth,11004 | 8196.01 | 3399.99 | 0.00 | 2376.96 | 2419.06 |
| Garcia, Dominique,16528 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Alvarez, Janet, G,11006 | 8119.03 | 3399.99 | 0.00 | 2334.97 | 2384.07 |
| Sai, Levi,16349 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Carlson, Shannon, C,11009 | 8091.33 | 3374.99 | 0.00 | 2297.28 | 2419.06 |
| Gao, Stacey,16662 | 4355.71 | 3578.27 | 0.00 | 777.44 | 0.00 |
| Li, Elijah,16740 | 6099.10 | 3578.27 | 0.00 | 0.00 | 2520.83 |
| Ramos, Theresa, G,11031 | 6478.60 | 3399.99 | 0.00 | 0.00 | 3078.61 |
| Arthur, Kristi, W,16675 | 4385.03 | 3578.27 | 0.00 | 0.00 | 806.76 |
| Lu, Suzanne, K,16712 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Lu, Jaclyn, D,11047 | 6582.33 | 3399.99 | 0.00 | 0.00 | 3182.34 |
| Yuan, Bethany, G,11030 | 6471.32 | 3399.99 | 0.00 | 0.00 | 3071.33 |
| Raje, Ashlee, E,16658 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Dominguez, Wendy,11035 | 6451.31 | 3374.99 | 0.00 | 0.00 | 3076.32 |
| Yuan, Christine,11046 | 6616.81 | 3374.99 | 0.00 | 0.00 | 3241.82 |
| Moreno, Krista, J,16745 | 6021.62 | 3578.27 | 0.00 | 0.00 | 2443.35 |
| Scott, Savannah, E,16929 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Nath, Jaime,11033 | 6495.29 | 0.00 | 3374.99 | 0.00 | 3120.30 |
| Lopez, Heidi,11052 | 8131.32 | 0.00 | 3374.99 | 2337.27 | 2419.06 |
| Stewart, Bryan, M,16928 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Lee, Dalton, J,16931 | 4767.73 | 0.00 | 3578.27 | 0.00 | 1189.46 |
| Sanz, Kellie,16708 | 4406.74 | 0.00 | 3578.27 | 0.00 | 828.47 |
| Coleman, Ethan, G,16693 | 6060.50 | 0.00 | 3578.27 | 2482.23 | 0.00 |
| Raman, Patricia, T,16702 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Garcia, Ivan, L,17354 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| West, Colleen, C,13128 | 6817.14 | 0.00 | 0.00 | 2049.10 | 4768.04 |
| Munoz, Cheryl, C,13632 | 6838.46 | 0.00 | 0.00 | 2071.42 | 4767.04 |
| Nara, Clayton,11768 | 8139.04 | 0.00 | 3399.99 | 0.00 | 4739.05 |
| Perez, Ross, E,14307 | 196.26 | 0.00 | 0.00 | 0.00 | 196.26 |
| Xie, Dustin,22204 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Hu, Glenn, R,24897 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Mehta, Erick, E,14123 | 61.58 | 0.00 | 0.00 | 0.00 | 61.58 |
| Diaz, Briana,13131 | 6737.15 | 0.00 | 0.00 | 2049.10 | 4688.05 |
| Perez, Evelyn,14346 | 3583.26 | 0.00 | 0.00 | 2071.42 | 1511.84 |
| Raje, Devon,29289 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Mehta, Deanna, P,17280 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
Generated 2025-12-21 20:35:55.930 UTC