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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Martin, Joe,146685216.690.000.002071.423145.27
He, Colin, B,143005322.730.000.002071.423251.31
Bryant, Madison, J,16481194.910.000.000.00194.91
Gutierrez, Gary, C,127016868.440.000.002071.424797.02
Green, Fernando,172584347.763578.270.000.00769.49
Deng, Casey, C,1967442.280.000.000.0042.28
Barnes, Alexia, D,1523159.480.000.000.0059.48
Shan, Colleen, D,151504379.080.000.002049.102329.98
Serrano, Pedro,261891926.450.000.00782.991143.46
Wilson, Zachary,255581307.06699.100.000.00607.96
Hu, Leah,119948169.030.003374.990.004794.04
Yuan, Grant, C,249092149.910.000.001000.441149.47
Yang, Kevin, F,2060584.960.000.000.0084.96
Martin, Byron, E,2521739.980.000.000.0039.98
Sanz, Kellie,167084406.743578.270.000.00828.47
Yuan, Ricardo,1667476.150.000.000.0076.15
Zhang, Tiffany, R,1731843.970.000.000.0043.97
Simmons, Isabel, H,26432123.980.000.000.00123.98
Vazquez, Jerome,231163936.540.000.002181.561754.98
Serrano, Reginald, J,130252690.400.000.002071.42618.98
Dominguez, Joy,221753018.330.000.002443.35574.98
Lee, David, J,221994693.880.000.002181.562512.32
Sai, Ross, A,219664659.900.000.002181.562478.34
Shen, Barbara,220304144.340.000.002443.351700.99
Ortega, Anne,130116819.110.000.002049.104770.01
Hu, Krystal, D,130127017.440.000.002071.424946.02
Zeng, Dennis, S,130505651.250.000.002071.423579.83
Liu, Jaclyn,129966808.150.000.002049.104759.05
Torres, Kristy, M,130352638.060.000.002049.10588.96
Zhang, Clarence, M,130016799.430.000.002049.104750.33
Gonzalez, Meredith,221712721.550.000.002181.56539.99
Martinez, Anna, J,129946855.440.000.002071.424784.02
Ye, Erica, E,130105716.520.000.002071.423645.10
Wang, Jon, A,261911938.470.000.00782.991155.48
Martin, Ruben,224002737.820.000.002181.56556.26
She, Latoya, A,117508148.020.003399.990.004748.03
Raje, Kurt,152102926.390.000.002071.42854.97
Wang, Martha, D,242722735.530.000.002181.56553.97
Gill, Lawrence, J,2022444.460.000.000.0044.46
Diaz, Megan, A,243034207.320.000.002443.351763.97
Jenkins, Amanda,152144490.880.000.002071.422419.46
Chen, Crystal, M,265662016.950.000.00782.991233.96
Huang, Valerie, J,267451932.460.000.00782.991149.47
Vazquez, Francis, E,1728183.970.000.000.0083.97
Serrano, Natasha,255631239.090.00699.100.00539.99
Xu, Tasha, E,1194882.260.000.000.0082.26
Carlson, Jonathon, N,1707378.970.000.000.0078.97
Morris, Isaac, G,264391938.470.000.00782.991155.48
Huang, Barbara,264421919.750.000.00782.991136.76
Arthur, Cassandra, M,224102983.340.000.002443.35539.99
Carlson, Briana,264361957.470.000.00782.991174.48
Vazquez, Armando,225712835.020.000.002181.56653.46
Peterson, Juan, H,130826906.390.000.002071.424834.97
Vazquez, Juan, P,225782735.530.000.002181.56553.97
Blanco, Marc,249082155.920.000.001000.441155.48
Price, Ian, J,224012983.340.000.002443.35539.99
Suri, Pedro,264221980.960.000.00782.991197.97
Foster, Aidan,264451938.470.000.00782.991155.48
Alexander, Elizabeth,130896800.450.000.002071.424729.03
Luo, Devon, D,228504657.510.000.002181.562475.95
Kumar, Cedric, B,228604663.790.000.002181.562482.23
Price, Megan,249072183.910.000.001000.441183.47
Ashe, Briana,229404207.320.000.004207.320.00
Jai, Maurice,229324169.330.000.004169.330.00
Perez, Martin,195776037.890.003578.270.002459.62
Gill, Carolyn,2309467.930.000.000.0067.93
Shen, Devon, G,2735878.980.000.000.0078.98
Suri, Jarrod, E,120048114.040.003374.990.004739.05
Griffin, Olivia,2120839.980.000.000.0039.98
Pal, Terrence, M,1303759.980.000.000.0059.98
Ye, Claudia, J,191026029.570.003578.270.002451.30
Martinez, Jermaine, L,151704391.410.000.002071.422319.99
Lopez, Donald, A,267401938.470.000.00782.991155.48
Martinez, Virginia,1313662.270.000.000.0062.27
Shan, Tasha,151924384.080.000.002049.102334.98
White, Taylor, D,250111589.400.000.001000.44588.96
Sun, Edwin, O,2117074.980.000.000.0074.98
Rodriguez, Evelyn,131176831.420.000.002049.104782.32
Dominguez, Jerome, F,229873942.030.000.002181.561760.47
Goel, Tommy,229093980.520.000.002181.561798.96
She, Brittney, M,229423971.530.000.002181.561789.97
Van, Cassandra,135254607.230.000.002071.422535.81
Lal, Kelsey, T,249132155.920.000.001000.441155.48
Diaz, Jill, F,229363946.520.000.002181.561764.96
Lewis, Hannah,265611336.960.000.00782.99553.97
Sanchez, Bryant, C,131136832.410.000.002071.424760.99
Goldstein, Brendan,135182638.360.000.002049.10589.26
Liang, Eugene,1397277.270.000.000.0077.27
Kapoor, Regina,1581067.170.000.000.0067.17
Jiménez, Alberto, C,152154468.560.000.002049.102419.46
Lopez, Kristi,281377.280.000.000.007.28
Ma, Louis,2187935.000.000.000.0035.00
Prasad, Brandy, P,1400963.970.000.000.0063.97
Munoz, Diane, R,15795132.440.000.000.00132.44
Wu, Ernest, L,111478195.500.003374.990.004820.51
Munoz, Gloria, L,197896058.210.003578.270.002479.94
Garcia, Roy, H,155854367.020.000.002049.102317.92
Wang, Shannon,110176434.313374.990.002316.97742.35
Hernandez, Walter,13141240.240.000.000.00240.24
Nara, Tommy,1672938.920.000.000.0038.92
Ortega, Felicia, J,1175347.920.000.000.0047.92
Sai, Harold,110266575.793399.990.002399.47776.33
Tang, Wayne, S,130906812.420.000.002049.104763.32
Cox, Nicole, V,229503917.540.000.003917.540.00
Suarez, Casey,265481322.980.000.00782.99539.99
Miller, Dalton, D,131306797.150.000.002049.104748.05
Sanz, Jamie,265491361.450.000.00782.99578.46
Wu, Clarence, L,131156779.420.000.002049.104730.32
Raji, Brendan,131036842.600.000.002049.104793.50
Baker, Jose, A,229374179.330.000.002443.351735.98
Prasad, Cesar,234113577.820.000.003577.820.00
Ramos, Danny,231214144.340.000.002443.351700.99
Moreno, Monique, R,231183913.820.000.002181.561732.26
Raji, Brad, C,234093917.540.000.002181.561735.98
Sharma, Jerry, C,136516812.120.000.002049.104763.02
Raji, Andres, E,139556888.440.000.002071.424817.02
Luo, Roger, J,1872856.710.000.000.0056.71
Carlson, Clinton, E,11116148.700.000.0027.28121.42
Navarro, Kristine, B,255661253.070.00699.100.00553.97
Xie, Karla,182014157.730.003578.270.00579.46
Subram, Ross, L,230857.280.000.000.007.28
Edwards, Carlos,16680104.860.000.000.00104.86
Ramos, Francis,163454173.243578.270.000.00594.97
Raji, Michele,151834368.700.000.002071.422297.28
Zheng, Aimee, H,242833946.520.000.002181.561764.96
Ramos, Craig,14209193.970.000.004.99188.98
Rodriguez, Arthur,154383788.680.000.002071.421717.26
Andersen, Tonya, N,135274529.040.000.002049.102479.94
Rodriguez, Jarrod,136366831.760.000.002071.424760.34
Dominguez, Kristi, M,136446864.460.000.002071.424793.04
Munoz, Meredith,139575645.240.000.002071.423573.82
Chen, Aimee,265911957.470.000.00782.991174.48
Suarez, Rebekah,136496812.130.000.002049.104763.03
Chen, Tiffany, A,233484167.310.000.002443.351723.96
Munoz, Cheryl, C,136326838.460.000.002071.424767.04
Sharma, Kelvin, D,266551322.980.000.001322.980.00
Alonso, Alfredo, T,233232745.330.000.002181.56563.77
Moyer, Mario,234204144.340.000.002443.351700.99
Cooper, Victoria, S,136376777.130.000.002049.104728.03
Rodriguez, Ebony,1451782.970.000.000.0082.97
Lal, Devon, L,1523766.260.000.000.0066.26
Guo, Randy, L,2295664.470.000.000.0064.47
Andersen, Maurice,1520698.960.000.000.0098.96
Rubio, Jay,151794444.890.000.002071.422373.47
Cai, Jessie, A,12249114.960.000.0049.9964.97
Alexander, Gabriel, C,14073156.840.000.0038.88117.96
Johnson, Elizabeth,110048196.013399.990.002376.962419.06
McDonald, Brent,1406877.270.000.000.0077.27
Wu, Lisa,2615894.480.000.000.0094.48
Torres, Diane, M,2521179.470.000.000.0079.47
Gao, Cara, B,156423772.410.000.002071.421700.99
Sanz, Monique, R,242732721.550.000.002181.56539.99
Alexander, David,1578398.960.000.000.0098.96
Pal, Clayton,27721166.280.000.000.00166.28
Shen, Leonard, J,242712745.330.000.002181.56563.77
Alvarez, Linda,140475643.540.000.003321.262322.28
Guo, Margaret,234314158.320.000.002443.351714.97
Fernandez, Cassandra, C,141343835.070.000.002049.101785.97
Alvarez, Lori, C,266621938.470.000.00782.991155.48
Blanco, Monique, W,141033612.220.000.002855.89756.33
Sun, Rafael,267491322.980.000.001322.980.00
Chandra, Arthur, L,140326859.430.000.002071.424788.01
Yang, Ronnie,235243598.830.000.003598.830.00
Hernandez, Raquel, W,139974586.350.000.002071.422514.93
Sanz, Cheryl, G,140465645.240.000.003340.262304.98
Kumar, Alejandro,140555177.400.000.002049.103128.30
Kumar, Ricardo, K,141333764.070.000.002049.101714.97
She, Stacey,267481357.970.000.001357.970.00
Chande, Derek,267431371.950.000.001371.950.00
Shan, Shawna, K,278692462.550.000.000.002462.55
Kapoor, Cesar, J,243023882.550.000.002181.561700.99
Navarro, Tyrone, K,255571262.87699.100.000.00563.77
Goel, Gilbert,155964460.040.000.002049.102410.94
Xu, Cedric,181984143.250.003578.270.00564.98
Sara, Tina,243074158.320.000.002443.351714.97
Raman, Brandy,1224777.270.000.0049.9927.28
Foster, Luke,15137161.940.000.0097.9763.97
Shen, Cedric,2220974.980.000.000.0074.98
Beck, Alejandro,110256576.803374.990.002405.47796.34
Anand, Leonard,143163797.370.000.002049.101748.27
Gill, Theodore,1114941.260.000.000.0041.26
Kovar, Tabitha,158332611.410.000.002071.42539.99
Ashe, Barbara,1873424.270.000.000.0024.27
Chander, Gregory, J,2200174.980.000.000.0074.98
Dominguez, Leslie,273461390.950.000.00782.99607.96
Huang, Lisa, L,141023667.230.000.002910.90756.33
Ross, Brandon,141323804.080.000.002049.101754.98
Alonso, Ricky, S,140705618.930.000.002049.103569.83
Munoz, Darren,235394144.340.000.002443.351700.99
Lopez, Bruce,235403626.820.000.002443.351183.47
Chen, Rosa,234353917.540.000.002181.561735.98
Alonso, Casey, E,234223911.530.000.002181.561729.97
Chander, Karla,236484144.340.000.002443.351700.99
Beck, Ashlee, L,266661336.960.000.001336.960.00
Li, Stacey,140645694.210.000.002071.423622.79
Chandra, Veronica,146815178.400.000.002049.103129.30
Rodriguez, Kristi,143453639.920.000.002049.101590.82
Raji, Corey,250587.280.000.000.007.28
Shan, Darrell, J,2734569.990.000.000.0069.99
Srini, Deanna,151824391.410.000.002071.422319.99
Foster, Hunter, A,202694.990.000.000.004.99
Bradley, Diane, A,1514062.270.000.0027.2834.99
Wu, Marshall, J,155904440.050.000.002049.102390.95
Lu, Susan, C,1235793.450.000.000.0093.45
Cox, Isaac,157974415.680.000.002071.422344.26
Carson, Shaun,111264972.370.003399.990.001572.38
Sharma, Mario, J,259281316.050.00699.100.00616.95
Flores, Adam, L,110446515.303374.990.000.003140.31
Lu, Jaclyn, D,110476582.333399.990.000.003182.34
Romero, Diane, F,219474632.860.002181.560.002451.30
Zimmerman, Krystal,1722877.270.000.000.0077.27
Raji, Maurice, C,2061974.980.000.000.0074.98
Srini, Joe,221804632.860.000.002181.562451.30
Gonzalez, Deanna, S,152044444.070.000.002049.102394.97
Suarez, Erika,151205217.700.000.002049.103168.60
Suri, Jillian, L,151804466.390.000.002071.422394.97
Hernandez, Jaime,241703018.330.000.002443.35574.98
Raji, Warren, J,267961957.470.000.00782.991174.48
Raman, Abby, T,151225193.720.000.002071.423122.30
Raje, Grant, S,241623004.830.000.002443.35561.48
Zeng, Erica,269241350.750.000.00782.99567.76
Mehta, Jay, S,150353772.410.000.002071.421700.99
Hernandez, Jessie, A,241722735.530.000.002181.56553.97
Luo, Lacey,241752743.040.000.002181.56561.48
Zeng, Amy,242422756.540.000.002181.56574.98
Serrano, Anne,242443617.830.000.002443.351174.48
Suri, Carmen, E,242502738.490.000.002181.56556.93
Perez, Bryant, L,150423807.400.000.002071.421735.98
Romero, Frank, M,152092916.560.000.002049.10867.46
Andersen, Brendan,151215202.730.000.002071.423131.31
Martinez, Ian,125852629.070.002049.100.00579.97
Chander, Julie, E,18763123.960.000.000.00123.96
Gill, Jaime, M,261521938.470.00782.990.001155.48
Xie, Nina,12997118.180.000.000.00118.18
Liang, Steve,1431781.260.000.0049.9931.27
Dominguez, Theodore, F,219874638.890.000.002181.562457.33
Hernandez, Ebony, S,235743337.040.000.002181.561155.48
Diaz, Carolyn, C,243603626.820.000.002443.351183.47
Becker, Leonard, C,22405123.980.000.000.00123.98
Vance, Phillip,293082438.060.000.000.002438.06
Hill, Kaylee, L,119188204.990.003399.990.004805.00
Mehta, Denise,130806844.410.000.002049.104795.31
Patel, Stanley, L,249152145.920.000.001000.441145.48
Ramos, Victor, D,242469.990.000.000.009.99
Kelly, Emma, A,156463804.080.000.002049.101754.98
Rodriguez, Ruben,125892665.060.002049.100.00615.96
Dominguez, Jimmy,219594702.390.002181.560.002520.83
Yuan, Calvin,1790525.480.000.000.0025.48
Hernandez, Krista, J,269181399.940.000.00782.99616.95
Moreno, Dana, D,150333797.400.000.002071.421725.98

Generated 2025-11-01 01:34:03.490 UTC