[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1126 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Moreno, Jimmy, L,11029 | 6565.29 | 3399.99 | 0.00 | 0.00 | 3165.30 |
| Chande, Tonya,11992 | 8123.03 | 0.00 | 3399.99 | 0.00 | 4723.04 |
| Patel, Rachael, G,13640 | 71.25 | 0.00 | 0.00 | 0.00 | 71.25 |
| Garcia, Virginia, C,24599 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Yuan, Cassie, J,24453 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Madan, Evelyn, D,22582 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Shen, Alisha, J,26438 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Goel, Dawn,23535 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Walker, Anthony, T,25250 | 1883.56 | 699.10 | 0.00 | 0.00 | 1184.46 |
| Chandra, Harold, K,17236 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Zeng, Dennis, S,13050 | 5651.25 | 0.00 | 0.00 | 2071.42 | 3579.83 |
| Luo, Christine, J,24159 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Kumar, Misty, H,25010 | 1540.43 | 0.00 | 0.00 | 1000.44 | 539.99 |
| Xu, Martha, C,16351 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Suarez, Erika,15120 | 5217.70 | 0.00 | 0.00 | 2049.10 | 3168.60 |
| Alvarez, Linda,14047 | 5643.54 | 0.00 | 0.00 | 3321.26 | 2322.28 |
| Ms., Rusek, Pearlie, J.,21945 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Lal, Shawna,17924 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Vazquez, Ross,11148 | 126.24 | 0.00 | 0.00 | 0.00 | 126.24 |
| Ramos, Diane, L,18300 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Luo, Ashlee,23534 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Vazquez, Daisy, L,25560 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Romero, Gary,22181 | 4673.88 | 0.00 | 0.00 | 2181.56 | 2492.32 |
| Hernandez, Max,18192 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Andersen, Tonya, N,13527 | 4529.04 | 0.00 | 0.00 | 2049.10 | 2479.94 |
| Ward, Haley, J,16631 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Hernandez, Jill, L,13003 | 230.25 | 0.00 | 0.00 | 0.00 | 230.25 |
| Liang, Louis, M,12706 | 6851.41 | 0.00 | 0.00 | 2071.42 | 4779.99 |
| Zeng, Alisha, A,15727 | 134.46 | 0.00 | 0.00 | 0.00 | 134.46 |
| Huang, Eugene, L,11001 | 6383.88 | 3374.99 | 0.00 | 2419.93 | 588.96 |
| Huang, Micah,25130 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hu, Krystal, D,13012 | 7017.44 | 0.00 | 0.00 | 2071.42 | 4946.02 |
| Carlson, Tanya,16183 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Ramos, Victor, D,24246 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Zhang, Warren, L,25252 | 1893.05 | 699.10 | 0.00 | 0.00 | 1193.95 |
| Sanz, Nelson, M,14056 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Thompson, Cameron, M,16620 | 5895.24 | 3578.27 | 0.00 | 0.00 | 2316.97 |
| Ye, Steve,29087 | 810.32 | 0.00 | 0.00 | 0.00 | 810.32 |
| Johnson, Elizabeth,11004 | 8196.01 | 3399.99 | 0.00 | 2376.96 | 2419.06 |
| Patel, Virginia, R,11366 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Alvarez, Janet, G,11006 | 8119.03 | 3399.99 | 0.00 | 2334.97 | 2384.07 |
| Sara, Donald, M,25114 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Alexander, Olivia, L,14667 | 5295.41 | 0.00 | 0.00 | 2049.10 | 3246.31 |
| Kelly, Emma, A,15646 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Garcia, Ivan, L,17354 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Flores, Connor,15755 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Gonzalez, Ebony,11034 | 6491.32 | 3399.99 | 0.00 | 0.00 | 3091.33 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Sharma, Terrence, N,17351 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Zeng, Brittney, K,13670 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Sharma, Sharon, T,25294 | 1882.57 | 699.10 | 0.00 | 0.00 | 1183.47 |
| Gomez, Jill,29315 | 103.96 | 0.00 | 0.00 | 0.00 | 103.96 |
| Lal, Devon, L,15237 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Madan, Erick, W,14212 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Jai, Bonnie,11977 | 8212.50 | 0.00 | 3399.99 | 0.00 | 4812.51 |
| Arun, Barry,27700 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| West, Colleen, C,13128 | 6817.14 | 0.00 | 0.00 | 2049.10 | 4768.04 |
| Nara, Ricardo,28934 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Lu, Suzanne, K,16712 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Holt, Alisha,28350 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Romero, Renee, E,16639 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| Tang, Terrence, R,17303 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Raji, Donna,24906 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Malhotra, Pedro,21559 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Andersen, Maurice,15206 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Nara, Dale, L,21226 | 4659.80 | 0.00 | 0.00 | 2181.56 | 2478.24 |
| Rana, Evelyn, D,18262 | 142.45 | 0.00 | 0.00 | 0.00 | 142.45 |
| Zhu, Candice, S,21219 | 4696.49 | 0.00 | 0.00 | 2181.56 | 2514.93 |
| Hernandez, Diana, F,11038 | 6437.33 | 0.00 | 3374.99 | 0.00 | 3062.34 |
| Lal, Kate,21557 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Martin, Marc, J,11039 | 6636.58 | 0.00 | 3399.99 | 0.00 | 3236.59 |
| Fernandez, Kristina, A,12581 | 2646.40 | 0.00 | 0.00 | 2071.42 | 574.98 |
| Suarez, Kristi, D,23099 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Edwards, Evan, L,21888 | 4925.58 | 0.00 | 0.00 | 2443.35 | 2482.23 |
| Hall, Jesse,26133 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Shen, Kathryn, R,21957 | 4919.30 | 0.00 | 0.00 | 2443.35 | 2475.95 |
| Gutierrez, Meghan, E,26021 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Deng, Michele,21946 | 4659.80 | 0.00 | 0.00 | 2181.56 | 2478.24 |
| Ramos, Briana, J,14303 | 3636.91 | 0.00 | 0.00 | 2049.10 | 1587.81 |
| Rana, Bryant,21878 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Madan, Henry, E,17283 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Serrano, Stacy,24613 | 2148.21 | 0.00 | 0.00 | 2148.21 | 0.00 |
| Gill, Roy,29465 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Vazquez, Diane, D,11987 | 279.23 | 0.00 | 0.00 | 0.00 | 279.23 |
| Sanz, Kellie,16708 | 4406.74 | 0.00 | 3578.27 | 0.00 | 828.47 |
| Jai, Drew, M,21562 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Gonzalez, Jay, C,14238 | 5642.90 | 0.00 | 0.00 | 2049.10 | 3593.80 |
| Mehta, Cindy, A,21943 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Serrano, Derrick,16707 | 4377.75 | 0.00 | 3578.27 | 0.00 | 799.48 |
| Li, David, A,21894 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Wu, Clarence, L,13115 | 6779.42 | 0.00 | 0.00 | 2049.10 | 4730.32 |
| Dominguez, Micheal,26142 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Madan, Summer, D,12347 | 6839.12 | 0.00 | 2049.10 | 0.00 | 4790.02 |
| Xie, Brendan,13018 | 2642.38 | 0.00 | 0.00 | 2071.42 | 570.96 |
| Zeng, Barbara,23102 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Mehta, Mayra,12998 | 5694.90 | 0.00 | 0.00 | 2049.10 | 3645.80 |
| Gill, Monique, L,17727 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Ruiz, Natasha,21994 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Diaz, Ruben, A,25136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ms., Sanchez, Madalena, J.,13020 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Cox, Michelle, E,17328 | 4387.74 | 0.00 | 3578.27 | 0.00 | 809.47 |
| Suarez, Renee, L,12703 | 6891.12 | 0.00 | 0.00 | 2049.10 | 4842.02 |
| Vazquez, Kristi,28349 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Chande, Michele, C,13078 | 6850.46 | 0.00 | 0.00 | 2071.42 | 4779.04 |
| Wang, Alejandro,17310 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Bell, Jessica,22178 | 4233.32 | 0.00 | 0.00 | 2443.35 | 1789.97 |
| Suri, Roy, M,17253 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Hernandez, Frank, G,22198 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Allen, Hailey, C,26759 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Gill, Hector, M,26187 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Sullivan, Dominic, M,22840 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Gao, Christy, D,26204 | 1967.45 | 0.00 | 0.00 | 782.99 | 1184.46 |
| She, Willie,17055 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Zhao, Marshall, C,22033 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Zheng, Jeffery, W,15030 | 3786.39 | 0.00 | 0.00 | 2071.42 | 1714.97 |
| Wang, Erica, J,22168 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Anand, Kelli, A,20451 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Romero, Francis,22196 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Diaz, Samuel,14065 | 5608.55 | 0.00 | 0.00 | 2071.42 | 3537.13 |
| Diaz, Kendra,13021 | 2668.38 | 0.00 | 0.00 | 2071.42 | 596.96 |
| Rodriguez, Allen, L,17732 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Ortega, Anne,13011 | 6819.11 | 0.00 | 0.00 | 2049.10 | 4770.01 |
| Vazquez, Roy,26029 | 1930.76 | 0.00 | 0.00 | 782.99 | 1147.77 |
Generated 2025-12-23 06:06:53.612 UTC