[ROOT]  dt  FactInternetSale  WHERE DimCurrency.AlternateKey EQ 'AUD'  >   PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount   <  ORDER BY 2020   <  SKIP 3000  >   <  TAKE 250  >   

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Guo, Jake, P,1996998.450.000.0067.9730.48
Gao, Erica, R,1908747.200.000.0047.200.00
Yang, Hunter, E,2023721.490.000.0021.490.00
Moreno, Danny, M,29458811.320.000.000.00811.32
Zhao, Jamie,1617972.160.000.000.0072.16
Harris, Thomas,240022744.520.000.002181.56562.96
Subram, Candace,27585562.960.000.000.00562.96
Alvarez, Francis,215524624.910.002181.560.002443.35
Huang, Micah,251307.280.000.000.007.28
Carlson, Tanya,1618331.270.000.000.0031.27
Xu, Kelvin, K,212223936.540.002181.560.001754.98
Ramos, Victor, D,242469.990.000.000.009.99
Ross, Brandon,141323804.080.000.002049.101754.98
Perez, Edgar, B,293182384.070.000.000.002384.07
Alvarez, Desiree,13005223.970.000.000.00223.97
Zeng, Brittney, K,13670178.450.000.0024.49153.96
Sanz, Julio, H,214044684.390.002181.560.002502.83
Coleman, Nicole, A,215584919.300.002443.350.002475.95
Gomez, Jill,29315103.960.000.000.00103.96
Fernandez, Kristina, A,125812646.400.002071.420.00574.98
Gonzales, Alexis,2352121.980.000.000.0021.98
Ramos, Meredith, A,2330767.930.000.000.0067.93
Shen, Kathryn, R,219574919.300.002443.350.002475.95
Deng, Michele,219464659.800.002181.560.002478.24
Navarro, Sheila, L,218894624.910.002181.560.002443.35
Liu, Lacey, L,235453882.550.000.002181.561700.99
Srini, Roy,248882174.920.001000.441174.480.00
Pal, Mohamed, D,126986786.750.002071.420.004715.33
Clark, Madison, A,140625647.920.000.003272.942374.98
Ferrier, Jenny,219554900.680.002443.350.002457.33
Dominguez, Darren, M,139666842.120.000.002049.104793.02
Xu, Rafael, A,218854641.850.002181.560.002460.29
Muñoz, Alberto, J,13008125.510.000.000.00125.51
Raji, Kathryn, C,2199537.290.000.000.0037.29
Romero, Diane, F,219474632.860.002181.560.002451.30
Chavez, Clayton,219494659.900.002181.560.002478.34
She, Jaime, D,28482777.340.000.000.00777.34
Gomez, Arthur,249172179.910.000.001000.441179.47
She, Kelli, J,248892269.910.000.002269.910.00
Yang, Randy, E,240002983.340.000.002443.35539.99
Sanz, Rodney,1692644.950.000.000.0044.95
Ma, Rafael, T,130222644.020.000.002049.10594.92
Torres, Jacqueline,219764198.330.000.002443.351754.98
Murphy, Jill, J,249022120.930.000.002120.930.00
Ortega, Shannon,263751971.450.000.00782.991188.46
Romero, Gary,221814673.880.000.002181.562492.32
Zhang, Dawn, A,1422282.260.000.000.0082.26
Vazquez, Arthur,28480742.350.000.000.00742.35
Zhao, Marshall, C,220333917.540.000.002181.561735.98
Deng, Jaime, R,219684722.880.000.002181.562541.32
Munoz, Monique,240082730.540.000.002181.56548.98
Cai, Jorge,220313896.530.000.002181.561714.97
Romero, Francis,221964632.860.000.002181.562451.30
Tang, Sharon, M,1582367.960.000.000.0067.96
Gao, Amy,219963946.520.000.002181.561764.96
Moreno, Marc,130242665.060.000.002049.10615.96
Chander, Julie, E,18763123.960.000.000.00123.96
Sai, Ross, A,219664659.900.000.002181.562478.34
Gutierrez, Gary, C,127016868.440.000.002071.424797.02
Black, Shaun, M,1735546.470.000.000.0046.47
Torres, Kristy, M,130352638.060.000.002049.10588.96
Wang, Autumn,130495647.220.000.002071.423575.80
Black, Tracy, B,249032164.910.000.002164.910.00
Bhat, Edwin,130796752.130.000.002049.104703.03
Hu, Crystal,2798029.480.000.000.0029.48
Deng, Latoya, H,219694759.470.000.002181.562577.91
Dominguez, Theodore, F,219874638.890.000.002181.562457.33
Anand, Rafael,293062384.070.000.000.002384.07
Huang, Amy, C,12244114.960.000.0049.9964.97
Gutierrez, Dana,2025460.470.000.000.0060.47
Zhu, Louis,14858196.970.000.00187.988.99
Li, Warren, R,29185563.770.000.000.00563.77
Moreno, Dwayne, T,2310385.480.000.000.0085.48
Luo, Warren,235624.990.000.000.004.99
Raje, Raul, L,2678574.980.000.000.0074.98
Shen, Jodi, A,2202869.990.000.0069.990.00
Gill, Mallory, P,16698197.880.000.000.00197.88
Liu, Candice,287202419.060.000.002419.060.00
Xie, Clarence,224022721.550.000.002181.56539.99
Kapoor, Candace,1828230.970.000.0021.988.99
Vazquez, Theresa, F,225812749.320.000.002181.56567.76
White, Ashley, D,2188739.990.000.0039.990.00
Huang, Randy,240073042.820.000.002443.35599.47
Mehta, Brandy,2283939.250.000.0039.250.00
Li, Barbara,157884443.380.000.002071.422371.96
Ruiz, Leslie, J,260327.280.000.007.280.00
She, Kathryn, I,264431938.470.000.00782.991155.48
Ferrier, Leslie, M,285352433.040.000.002433.040.00
Navarro, Francis, J,2752078.980.000.000.0078.98
Zimmerman, Jenny,1819730.970.000.008.9921.98
Gonzalez, Carolyn, H,224072756.540.000.002181.56574.98
Zhu, Jorge,2614178.980.000.0078.980.00
Xu, Dennis,2199739.990.000.000.0039.99
Martin, Beth, K,2331739.980.000.000.0039.98
Browning, Javier,231204144.340.000.002443.351700.99
Andersen, Jaime,2526860.470.000.000.0060.47
Goel, Yolanda, M,264351957.470.000.00782.991174.48
Gomez, Carrie,229657.280.000.000.007.28
Suarez, Lance, C,1723083.980.000.0053.9929.99
Jai, Nichole, R,2834868.490.000.000.0068.49
Raje, Wayne, A,2137274.960.000.000.0074.96
Sanz, Paula,2643069.990.000.000.0069.99
Lu, Valerie,229134684.390.000.002181.562502.83
Shan, Jenny, W,1670692.970.000.000.0092.97
Cox, Isaac,157974415.680.000.002071.422344.26
Shen, Tony,29099548.980.000.000.00548.98
Ashe, Briana,229404207.320.000.004207.320.00
Suarez, Melinda,29181553.970.000.000.00553.97
Jai, Maurice,229324169.330.000.004169.330.00
Chander, Brad, K,2138269.990.000.0069.990.00
Raman, Cindy,161574391.410.000.002071.422319.99
Sanchez, Marie,2292490.950.000.0090.950.00
Luo, Roger, J,1872856.710.000.000.0056.71
Guo, Krystal, S,17381188.930.000.00188.930.00
Liang, Barbara, T,229533899.490.000.003899.490.00
Madan, Cassandra, D,29068751.340.000.000.00751.34
Ye, Amy,11073191.900.000.00103.9687.94
She, Sharon, F,2201769.990.000.000.0069.99
Sai, Barry,229074169.330.000.002443.351725.98
Morgan, Melanie,2122726.970.000.000.0026.97
Nelson, Mary, L,131075650.900.000.002049.103601.80
Shan, Jaime,2202056.970.000.000.0056.97
Mehta, Levi, M,131105583.940.000.002049.103534.84
Weber, Jarrod, M,1485931.270.000.0031.270.00
Malhotra, Tina, C,27584599.470.000.000.00599.47
Zhou, Arturo, F,27910574.980.000.00574.980.00
Suarez, Orlando,1112158.160.000.000.0058.16
Moore, Nathan, N,283232384.070.000.002384.070.00
Van, Cassandra,135254607.230.000.002071.422535.81
Guo, Susan, A,2654314.230.000.0014.230.00
Shen, Grant, B,267631957.470.000.00782.991174.48
Serrano, Tabitha,283272407.040.000.002407.040.00
Thompson, Justin,229544179.330.000.004179.330.00
Sanz, Tabitha,17496110.960.000.000.00110.96
Xu, Colleen, C,18325108.850.000.0038.8869.97
Navarro, Jacquelyn,1546540.230.000.0029.9910.24
Vazquez, Casey, S,131326880.620.000.002049.104831.52
Gill, Ricky, A,1560728.980.000.000.0028.98
Rai, Johnny, A,131356773.140.000.002049.104724.04
Shen, Dustin,27974553.970.000.000.00553.97
Lu, Ramon, B,1673844.950.000.0013.9830.97
Raheem, Bethany, L,2196599.470.000.000.0099.47
Vazquez, Byron,1112242.930.000.007.9534.98
Jai, Jaime, M,248944.990.000.004.990.00
Ortega, Eddie,229084661.500.000.002181.562479.94
Ruiz, Sabrina, A,2221442.280.000.000.0042.28
Gutierrez, Diana,1967667.970.000.000.0067.97
Vance, Ruth, D,17302147.440.000.0058.9888.46
Gao, Bianca, C,131125717.890.000.002049.103668.79
Fernandez, Michele, M,2488423.780.000.000.0023.78
Schmidt, Joe, M,229054624.910.000.002181.562443.35
Zheng, Shannon, M,1467849.990.000.0049.990.00
Diaz, Jill, F,229363946.520.000.002181.561764.96
Vazquez, Lawrence,1963256.980.000.0056.980.00
Raji, Maurice, C,2061974.980.000.000.0074.98
Rana, Cindy,213677.280.000.007.280.00
Moreno, Kristine, K,28481778.620.000.000.00778.62
Shen, Michele,27985539.990.000.000.00539.99
Malhotra, Terrance, E,20223187.380.000.000.00187.38
Ramos, Kendra,2489615.230.000.000.0015.23
Sanz, Hector,2734469.990.000.000.0069.99
Tang, Barbara,27711617.470.000.000.00617.47
Luo, Nichole, A,2929649.970.000.000.0049.97
Williams, Madison, J,2119869.970.000.000.0069.97
Ramos, Joy,131296823.150.000.002049.104774.05
Xie, Alicia,26427123.980.000.000.00123.98
Navarro, Cheryl,131095682.900.000.002049.103633.80
Gill, Joanna,2618638.980.000.000.0038.98
Beck, Barbara,265471407.960.000.00782.99624.97
Mehta, Gerald,2023432.280.000.0032.280.00
Yuan, Keith, N,229263936.540.000.002181.561754.98
Guo, Martha, A,2853613.980.000.0013.980.00
Cook, Sydney, D,131185669.900.000.002049.103620.80
Sun, Karen, C,282082398.050.000.002398.050.00
Suarez, Casey,265481322.980.000.00782.99539.99
Pal, Terry, H,2582439.980.000.000.0039.98
Chandra, Veronica,146815178.400.000.002049.103129.30
Gill, Lawrence, J,2022444.460.000.000.0044.46
Kapoor, Brett, L,2214769.990.000.000.0069.99
Pal, Dale,1845175.470.000.000.0075.47
Chande, Kelli, C,229333917.540.000.002181.561735.98
Deng, Russell, J,2031467.930.000.000.0067.93
Raji, Brendan,131036842.600.000.002049.104793.50
Cox, Jared, E,28114570.470.000.00570.470.00
Tang, Latoya, F,229103882.550.000.002181.561700.99
Gao, Arturo,287142433.040.000.002433.040.00
Prasad, Cesar,234113577.820.000.003577.820.00
Coleman, Paige, L,1526369.970.000.000.0069.97
Moreno, Kristi,234153588.830.000.003588.830.00
Chande, Casey,2614978.980.000.000.0078.98
Ramos, Paula, W,213764.990.000.000.004.99
Chandra, Virginia, M,2758815.230.000.000.0015.23
Gao, Jake, A,19955173.450.000.000.00173.45
Cox, Angel, M,1879330.480.000.000.0030.48
Lin, Damien, L,234143391.030.000.003391.030.00
Gutierrez, Tabitha, A,2188474.980.000.000.0074.98
Zheng, Curtis, S,236454198.330.000.002443.351754.98
She, Jeffery, M,2714942.280.000.000.0042.28
Blanco, Krista, L,2758039.980.000.000.0039.98
Jai, Gregory,1634246.470.000.000.0046.47
Li, Cedric,2736478.980.000.0078.980.00
Ye, Valerie, C,289482419.060.000.002419.060.00
Wang, Arturo, A,2772039.980.000.0039.980.00
Ramos, Adrienne, L,282167.280.000.007.280.00
Henderson, Dalton,248954.990.000.004.990.00
Alan, Jamie, S,2122442.280.000.000.0042.28
Lopez, Patricia,2830529.480.000.000.0029.48
Martinez, Douglas, C,2284135.000.000.0035.000.00
Ruiz, Marvin, R,1879623.780.000.000.0023.78
Gonzales, Lucas,29463751.340.000.000.00751.34
Alonso, Stacy,28315556.930.000.000.00556.93
Gonzalez, Brandy,27368132.970.000.00132.970.00
Srini, Cindy, E,260264.990.000.004.990.00
Ramos, Danny,231214144.340.000.002443.351700.99
Wu, Brittney,234183400.020.000.003400.020.00
Lopez, George,150403807.400.000.002071.421735.98
Moreno, Monique, R,231183913.820.000.002181.561732.26
Raji, Brad, C,234093917.540.000.002181.561735.98
Kumar, Lacey,139606871.740.000.002071.424800.32
Anderson, Richard, G,249242143.900.000.001000.441143.46
Alonso, Kathleen,2119634.980.000.000.0034.98
Pal, Dustin,265881938.470.000.00782.991155.48
Zhu, Wesley, L,1962423.780.000.000.0023.78
Raman, Cassandra,2871867.970.000.000.0067.97
Xu, Cristina,2501714.980.000.000.0014.98
Allen, Kaylee,266531938.470.000.00782.991155.48
Madan, Johnathan, D,136266909.090.000.002049.104859.99
Shen, Alison, A,1661471.160.000.000.0071.16
Liang, Darryl,266581390.950.000.001390.950.00
Munoz, Meredith,139575645.240.000.002071.423573.82
Ortega, Max,234133617.830.000.003617.830.00
Sai, Lydia, L,139685181.700.000.002862.742318.96
Suarez, Rebekah,136496812.130.000.002049.104763.03
Lopez, Kari,15235190.890.000.000.00190.89
Gray, Jeremiah,233314144.340.000.002443.351700.99
Zhao, Gilbert,231193945.530.000.002181.561763.97
Hernandez, Gina,140495290.680.000.002071.423219.26
Ye, Lacey,29090778.620.000.000.00778.62
Patel, Jillian,266671390.950.000.001390.950.00
Blanco, Monique, W,141033612.220.000.002855.89756.33
Powell, Adam,234233936.540.000.002181.561754.98
Martin, Anne, V,250342164.910.000.001000.441164.47
Sun, Rafael,267491322.980.000.001322.980.00
Sharma, Edwin, K,250211554.410.000.001000.44553.97
Yang, Ronnie,235243598.830.000.003598.830.00
Adams, Amber,267462001.450.000.00782.991218.46
Munoz, Tanya,234363950.520.000.002181.561768.96
Garcia, Rebekah, M,140073772.410.000.003772.410.00
Moore, Thomas,140103861.390.000.003861.390.00
Cai, Candice,267471938.470.000.00782.991155.48

Generated 2025-11-03 10:43:52.604 UTC