[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 250 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hu, Cara,20608 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Munoz, Audrey, V,12003 | 8256.50 | 0.00 | 3374.99 | 0.00 | 4881.51 |
| Suri, Jarrod, E,12004 | 8114.04 | 0.00 | 3374.99 | 0.00 | 4739.05 |
| Carson, Kelvin, A,11995 | 8249.01 | 0.00 | 3399.99 | 0.00 | 4849.02 |
| Ashe, Maurice,20430 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Martinez, Ethan, C,20260 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Tang, April, A,25935 | 1256.03 | 0.00 | 699.10 | 0.00 | 556.93 |
| Goel, Alicia, H,20423 | 4177.74 | 0.00 | 3578.27 | 599.47 | 0.00 |
| Sharma, Donna,11998 | 6962.10 | 0.00 | 3374.99 | 1249.84 | 2337.27 |
| Chande, Tonya,11992 | 8123.03 | 0.00 | 3399.99 | 0.00 | 4723.04 |
| Deng, Barbara,20445 | 6078.71 | 0.00 | 3578.27 | 0.00 | 2500.44 |
| Torres, Sabrina, E,20425 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Blanco, Jésus, E,20448 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Raje, Mario, S,20427 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Gutierrez, Marvin,25938 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Alonso, Meredith, M,20621 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Rubio, Sabrina, A,20984 | 4153.25 | 0.00 | 3578.27 | 0.00 | 574.98 |
| Prasad, Preston, C,20812 | 4127.25 | 0.00 | 3578.27 | 548.98 | 0.00 |
| Wilson, Sam,25947 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Tang, Willie, A,25939 | 1264.57 | 0.00 | 699.10 | 0.00 | 565.47 |
| Sara, Cassandra, D,20989 | 4148.74 | 0.00 | 3578.27 | 0.00 | 570.47 |
| Andersen, Tracy,20815 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Rubio, Kristy,12243 | 3914.98 | 0.00 | 3374.99 | 0.00 | 539.99 |
| Martinez, Troy, L,20823 | 4216.75 | 0.00 | 3578.27 | 0.00 | 638.48 |
| Ortega, Monique, C,12355 | 6818.11 | 0.00 | 2049.10 | 0.00 | 4769.01 |
| Munoz, Casey, W,12570 | 2654.06 | 0.00 | 2049.10 | 0.00 | 604.96 |
| Ortega, Lance, C,12354 | 6797.13 | 0.00 | 2049.10 | 0.00 | 4748.03 |
| Kumar, Katie, P,12341 | 6840.62 | 0.00 | 2049.10 | 0.00 | 4791.52 |
| Ortega, Alfredo, W,25958 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
| Huang, Crystal, L,26023 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Gutierrez, Clinton,21001 | 3018.33 | 0.00 | 2443.35 | 0.00 | 574.98 |
| Shen, Jaclyn, A,12575 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
| Chapman, Clifford, C,21168 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Nath, Cassie,24606 | 2155.92 | 0.00 | 1000.44 | 1155.48 | 0.00 |
| Vance, Denise, L,21205 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| She, Eugene, L,20998 | 2806.51 | 0.00 | 2181.56 | 0.00 | 624.95 |
| Torres, Theresa,21202 | 4632.86 | 0.00 | 2181.56 | 0.00 | 2451.30 |
| Gomez, Sheila, J,21165 | 4673.88 | 0.00 | 2181.56 | 0.00 | 2492.32 |
| Subram, Evelyn, S,21257 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Serrano, Alfredo,21258 | 3936.54 | 0.00 | 2181.56 | 0.00 | 1754.98 |
| Chapman, Alicia, A,21418 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Luo, Johnny,21359 | 3032.31 | 0.00 | 2443.35 | 0.00 | 588.96 |
| Perry, Gavin, M,12578 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
| Lin, Ronnie, D,21384 | 2921.02 | 0.00 | 2181.56 | 0.00 | 739.46 |
| Mr., Solanki, Ajay,18295 | 144.27 | 0.00 | 0.00 | 0.00 | 144.27 |
| Vazquez, Marvin, K,21953 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Li, Luis, K,20251 | 59.47 | 0.00 | 0.00 | 0.00 | 59.47 |
| Sharma, Corey, M,17495 | 119.91 | 0.00 | 0.00 | 0.00 | 119.91 |
| Deng, Tracy, E,21978 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Nara, Dale, L,21226 | 4659.80 | 0.00 | 2181.56 | 0.00 | 2478.24 |
| Zhou, Laura, D,12683 | 6801.45 | 0.00 | 2071.42 | 0.00 | 4730.03 |
| Travers, Jimmy, V,12674 | 6829.47 | 0.00 | 2071.42 | 0.00 | 4758.05 |
| Zhu, Candice, S,21219 | 4696.49 | 0.00 | 2181.56 | 0.00 | 2514.93 |
| Sanz, Julio, H,21404 | 4684.39 | 0.00 | 2181.56 | 0.00 | 2502.83 |
| Coleman, Nicole, A,21558 | 4919.30 | 0.00 | 2443.35 | 0.00 | 2475.95 |
| Fernandez, Kristina, A,12581 | 2646.40 | 0.00 | 2071.42 | 0.00 | 574.98 |
| Zhou, Trisha, B,12686 | 6864.46 | 0.00 | 2071.42 | 0.00 | 4793.04 |
| Ortega, Tyrone, H,12583 | 2646.40 | 0.00 | 2071.42 | 0.00 | 574.98 |
| Martinez, Ian,12585 | 2629.07 | 0.00 | 2049.10 | 0.00 | 579.97 |
| Gonzalez, Kaylee, L,21895 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Hernandez, Orlando, C,21951 | 4923.29 | 0.00 | 2443.35 | 0.00 | 2479.94 |
| Navarro, Stacy, C,12688 | 6867.44 | 0.00 | 2071.42 | 0.00 | 4796.02 |
| Deng, Michele,21946 | 4659.80 | 0.00 | 2181.56 | 0.00 | 2478.24 |
| Collins, Rebecca, M,26153 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Srini, Roy,24888 | 2174.92 | 0.00 | 1000.44 | 1174.48 | 0.00 |
| Arthur, Jay, R,12694 | 6785.13 | 0.00 | 2049.10 | 0.00 | 4736.03 |
| Serrano, Stacy,24613 | 2148.21 | 0.00 | 1000.44 | 1147.77 | 0.00 |
| Dominguez, Kristi, M,13644 | 6864.46 | 0.00 | 0.00 | 2071.42 | 4793.04 |
| Rodriguez, Donald, L,28351 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Morgan, Mackenzie, E,16162 | 185.04 | 0.00 | 0.00 | 0.00 | 185.04 |
| Kumar, Robert,25226 | 2158.90 | 0.00 | 0.00 | 1000.44 | 1158.46 |
| Alonso, Casey, E,23422 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Pal, Drew,11902 | 63.04 | 0.00 | 0.00 | 6.28 | 56.76 |
| Suarez, Brandi,21874 | 4638.89 | 0.00 | 2181.56 | 0.00 | 2457.33 |
| Sun, Erica, P,26135 | 1967.45 | 0.00 | 782.99 | 0.00 | 1184.46 |
| Pal, Tamara,12689 | 6846.92 | 0.00 | 2071.42 | 0.00 | 4775.50 |
| Chavez, Clayton,21949 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Blanco, Mallory,21958 | 4696.49 | 0.00 | 2181.56 | 0.00 | 2514.93 |
| Ramos, Jay, D,21882 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Goel, Carly, C,12989 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Mehta, Mayra,12998 | 5694.90 | 0.00 | 0.00 | 2049.10 | 3645.80 |
| Ruiz, Natasha,21994 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Ms., Sanchez, Madalena, J.,13020 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Moreno, Beth,21980 | 4334.61 | 0.00 | 0.00 | 2443.35 | 1891.26 |
| Cai, Bianca, D,22173 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Subram, Virginia,13036 | 2677.07 | 0.00 | 0.00 | 2049.10 | 627.97 |
| Bell, Jessica,22178 | 4233.32 | 0.00 | 0.00 | 2443.35 | 1789.97 |
| Raji, Wayne, A,26161 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Jai, Kathryn,23546 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Serrano, Dana, S,12678 | 341.43 | 0.00 | 0.00 | 89.46 | 251.97 |
| Dominguez, Sabrina, M,28116 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Ramirez, Jessica, R,29192 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Sun, Aimee, R,18319 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Jenkins, Noah, A,24379 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Lu, Micah,22174 | 3007.83 | 0.00 | 0.00 | 2443.35 | 564.48 |
| Ye, Martha,22200 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Deng, Jaime, R,21968 | 4722.88 | 0.00 | 0.00 | 2181.56 | 2541.32 |
| Wang, Erica, J,22168 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Cai, Jorge,22031 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Gao, Amy,21996 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Sai, Ross, A,21966 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Gutierrez, Gary, C,12701 | 6868.44 | 0.00 | 0.00 | 2071.42 | 4797.02 |
| Serrano, Jésus, B,12991 | 5641.90 | 0.00 | 0.00 | 2049.10 | 3592.80 |
| Ortega, Anne,13011 | 6819.11 | 0.00 | 0.00 | 2049.10 | 4770.01 |
| Liu, Jaclyn,12996 | 6808.15 | 0.00 | 0.00 | 2049.10 | 4759.05 |
| Torres, Kristy, M,13035 | 2638.06 | 0.00 | 0.00 | 2049.10 | 588.96 |
| Barnes, Julia, R,21999 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Zhang, Clarence, M,13001 | 6799.43 | 0.00 | 0.00 | 2049.10 | 4750.33 |
| Rana, Whitney, A,13006 | 6762.15 | 0.00 | 0.00 | 2049.10 | 4713.05 |
| Gonzalez, Meredith,22171 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Sara, Geoffrey,26188 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Lal, Deborah, T,21982 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Deng, Latoya, H,21969 | 4759.47 | 0.00 | 0.00 | 2181.56 | 2577.91 |
| Martinez, Anna, J,12994 | 6855.44 | 0.00 | 0.00 | 2071.42 | 4784.02 |
| Suri, Whitney, J,21974 | 4925.17 | 0.00 | 0.00 | 2443.35 | 2481.82 |
| Sullivan, Dominic, M,22840 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Hu, Jenny, A,16634 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Arun, Troy, P,15221 | 4447.87 | 0.00 | 0.00 | 2071.42 | 2376.45 |
| Yuan, Grant, C,24909 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Yang, Kevin, F,20605 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Zhang, Tiffany, R,17318 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Vazquez, Jerome,23116 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Mehta, Carolyn,28205 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Long, Alexis,22580 | 3051.31 | 0.00 | 0.00 | 2443.35 | 607.96 |
| Huang, Barbara,26442 | 1919.75 | 0.00 | 0.00 | 782.99 | 1136.76 |
Generated 2025-11-01 20:18:36.459 UTC