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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Vance, Meredith, B,209834178.730.003578.270.00600.46
Lu, Margaret, D,208144186.230.003578.27607.960.00
Ross, Connor, J,208164228.720.003578.27650.450.00
Andersen, Tracy,208154118.260.003578.27539.990.00
Ruiz, Shannon,208224134.530.003578.27556.260.00
Stone, Christine, D,259481819.590.00699.100.001120.49
Suarez, Jerome, L,206226139.590.003578.270.002561.32
Powell, Rachel,208184230.730.003578.27652.460.00
Munoz, Casey, W,125702654.060.002049.100.00604.96
Kumar, Katie, P,123416840.620.002049.102294.992496.53
Gao, Wesley,123466864.460.002071.420.004793.04
Dominguez, Walter,125762653.070.002049.100.00603.97
Raman, Ruth, L,211994144.340.002443.350.001700.99
Hernandez, Logan,123506791.750.002071.420.004720.33
Rogers, Anna,212014921.690.002443.350.002478.34
Nara, Katrina, Z,246082120.930.001000.441120.490.00
Goel, Mario, J,123606750.480.002071.420.004679.06
Chapman, Clifford, C,211684624.910.002181.560.002443.35
Ruiz, Gloria,123435567.930.002049.100.003518.83
Flores, Katherine,211803882.550.002181.560.001700.99
She, Corey, T,212144659.900.002181.560.002478.34
Nath, Cassie,246062155.920.001000.441155.480.00
Zhou, Jaclyn, C,211794935.670.002443.350.002492.32
She, Eugene, L,209982806.510.002181.560.00624.95
Torres, Theresa,212024632.860.002181.560.002451.30
Arun, Nancy, C,211694647.880.002181.560.002466.32
Xu, Jaclyn, L,126856904.110.002049.100.004855.01
Navarro, Albert, L,215614947.780.002443.350.002504.43
Wood, Maria,126676813.120.002049.100.004764.02
Serrano, Alfredo,212583936.540.002181.560.001754.98
Serrano, Gloria, G,215564930.680.002443.350.002487.33
Sun, Jamie,213892770.520.002181.560.00588.96
Fernandez, Holly, M,126756812.770.002071.420.004741.35
Rodriguez, Wyatt, D,212184661.500.002181.560.002479.94
Vazquez, Ruben, B,143015142.750.000.002071.423071.33
Saunders, Bobby, D,22205120.480.000.000.00120.48
Becker, Kathryn,2458813.980.000.000.0013.98
Kumar, Robert,252262158.900.000.001000.441158.46
Guo, Jaclyn,131196829.450.000.002071.424758.03
Xie, Casey,212174659.900.002181.560.002478.34
Nara, Dale, L,212264659.800.002181.560.002478.24
Zhu, Candice, S,212194696.490.002181.560.002514.93
Coleman, Nicole, A,215584919.300.002443.350.002475.95
Martinez, Sarah, S,126706785.130.002049.100.004736.03
Chow, Christy, M,126816784.130.002049.100.004735.03
Fernandez, Kristina, A,125812646.400.002071.420.00574.98
Zhou, Trisha, B,126866864.460.002071.420.004793.04
Sun, Micah,248872218.900.001000.441218.460.00
Gonzalez, Ruth,126936820.470.002071.420.004749.05
Edwards, Evan, L,218884925.580.002443.350.002482.23
Shen, Kathryn, R,219574919.300.002443.350.002475.95
Sanchez, Candace, L,215674973.280.002443.350.002529.93
Navarro, Sheila, L,218894624.910.002181.560.002443.35
Thompson, Michael, M,261481917.460.00782.990.001134.47
Rana, Bryant,218784663.790.002181.560.002482.23
Raje, Rafael, M,130006799.450.000.002071.424728.03
Liu, Micah, J,152204384.080.000.002049.102334.98
Bhat, Yolanda,152254401.410.000.002071.422329.99
Yuan, Mitchell,267441938.470.000.00782.991155.48
Guo, Sandra,236643941.530.000.002181.561759.97
Sanchez, Carla,1827430.970.000.000.0030.97
Stone, Brenda, J,12697296.190.000.000.00296.19
Gill, Diane,155784509.900.000.002071.422438.48
Alvarez, Kristy,155884486.070.000.002049.102436.97
Sun, Erica, P,261351967.450.00782.990.001184.46
Jai, Drew, M,215624632.860.002181.560.002451.30
Navarro, Kellie, I,218734661.500.002181.560.002479.94
Chavez, Clayton,219494659.900.002181.560.002478.34
Ms., Sanchez, Madalena, J.,130202589.090.000.002049.10539.99
Martinez, Cynthia,221702745.330.000.002181.56563.77
Ortega, Shannon,263751971.450.000.00782.991188.46
Subram, Virginia,130362677.070.000.002049.10627.97
Hernandez, Frank, G,221984661.500.000.002181.562479.94
Jones, Ethan,130516831.740.000.002071.424760.32
Wang, Erica, J,221682997.320.000.002443.35553.97
Suarez, Kristy,219844175.610.000.002443.351732.26
Cai, Jorge,220313896.530.000.002181.561714.97
Moreno, Marc,130242665.060.000.002049.10615.96
She, Clarence, L,249012174.920.000.002174.920.00
Munoz, Craig, V,130766862.140.000.002049.104813.04
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
Zhao, Jaclyn, D,261671903.480.000.00782.991120.49
Garcia, Toni,221934886.700.000.002443.352443.35
Suri, Whitney, J,219744925.170.000.002443.352481.82
Patel, Cynthia, M,15222123.450.000.000.00123.45
Henderson, Paige, C,1732554.940.000.008.9945.95
Weber, Cory,1673981.260.000.0031.2749.99
Serrano, Joanna, J,266631976.940.000.00782.991193.95
Liang, Colin,13639188.960.000.003.99184.97
Madan, Terrance,249102183.910.000.001000.441183.47
Green, Sydney,23522120.470.000.000.00120.47
Madan, Brenda,13043175.930.000.000.00175.93
Lu, Tiffany,2284348.980.000.000.0048.98
Munoz, Anne,1579898.960.000.000.0098.96
Ramos, Mathew, E,289612478.040.000.000.002478.04
Xu, Tony, L,225762721.550.000.002181.56539.99
Madan, Evelyn, D,225822756.540.000.002181.56574.98
Xie, Clarence,224022721.550.000.002181.56539.99
Shan, Clarence,224082770.520.000.002181.56588.96
Vazquez, Theresa, F,225812749.320.000.002181.56567.76
Edwards, Kaylee, M,228514632.860.000.002181.562451.30
Mehta, Ebony, J,228544659.900.000.002181.562478.34
She, Kathryn, I,264431938.470.000.00782.991155.48
Luo, Lindsey, R,222015012.270.000.002443.352568.92
Madan, Candace,224092746.040.000.002181.56564.48
Lopez, Pamela, E,264441938.710.000.00782.991155.72
Zheng, Alisha,222034624.910.000.002181.562443.35
Gutierrez, Hector,264232001.970.000.00782.991218.98
He, Amy,224112770.520.000.002181.56588.96
Cai, Karen,225722997.320.000.002443.35553.97
Goel, Yolanda, M,264351957.470.000.00782.991174.48
Zhu, Tiffany,264371953.470.000.00782.991170.48
Shen, Kelvin,224063018.330.000.002443.35574.98
Ruiz, Krista, C,130816772.150.000.002049.104723.05
Xu, Margaret, T,224042983.340.000.002443.35539.99
Sai, Bryant, S,225772743.040.000.002181.56561.48
Lu, Valerie,229134684.390.000.002181.562502.83
Guo, Jon,229273913.820.000.002181.561732.26
Rubio, Pedro, E,230982745.330.000.002181.56563.77
Anand, Bradley,1962639.460.000.000.0039.46
Pal, Willie, J,1175546.250.000.000.0046.25
Wang, Alan,136226841.430.000.002071.424770.01
Subram, Joe,136316817.120.000.002049.104768.02
Navarro, Daisy,27514539.990.000.000.00539.99
Ruiz, Danny,2445621.490.000.000.0021.49
Lin, Margaret, C,1830687.770.000.000.0087.77
Zhu, Jamie, J,1314069.990.000.000.0069.99
Ms., Sandidge, Mary, R.,14016121.060.000.000.00121.06
Liang, Dennis,14034104.240.000.000.00104.24
Smith, Allen,1407274.980.000.000.0074.98
Yang, Rosa,18713237.260.000.000.00237.26
Xu, Tonya,1732480.940.000.000.0080.94
Black, Shawna, C,152054433.690.000.002071.422362.27
Diaz, Josue,152074446.400.000.002071.422374.98
Carlson, Marc, W,17501141.980.000.000.00141.98
Malhotra, Harold,152274469.560.000.002049.102420.46
Liang, Barbara, T,229533899.490.000.003899.490.00
Russell, Noah, M,264471938.470.000.00782.991155.48
Suri, Lydia,131266815.080.000.002049.104765.98
Rai, Michele, M,265671957.470.000.00782.991174.48
Cai, Amy,249202155.920.000.001000.441155.48
Ortega, Eddie,229084661.500.000.002181.562479.94
Cox, Catherine, K,131226871.430.000.002071.424800.01
Moreno, Jessie, C,229064624.910.000.002181.562443.35
Shen, Tamara, G,229353951.520.000.002181.561769.96
Sanchez, Michelle, R,265691938.470.000.00782.991155.48
Natsuhara, Tony,230972770.520.000.002181.56588.96
Nelson, Carol,135204551.360.000.004551.360.00
Ramos, Joy,131296823.150.000.002049.104774.05
Beck, Barbara,265471407.960.000.00782.99624.97
Gonzales, Hunter,265701957.470.000.00782.991174.48
Yuan, Keith, N,229263936.540.000.002181.561754.98
Lu, Sandra, N,135214514.770.000.004514.770.00
Martin, Deanna,130916864.950.000.002071.424793.53
Raje, Christy,231003007.120.000.002443.35563.77
Foster, Lucas,135194492.450.000.004492.450.00
Long, Isabelle, W,231043490.030.000.003490.030.00
Tang, Latoya, F,229103882.550.000.002181.561700.99
Raman, Brett, L,229304900.680.000.002443.352457.33
Sara, Ebony,249232159.400.000.001000.441158.96
Moreno, Kristi,234153588.830.000.003588.830.00
Perez, Ivan, S,234084218.820.000.002443.351775.47
Lin, Damien, L,234143391.030.000.003391.030.00
Ye, Damien, M,136206848.070.000.002049.104798.97
Sai, Ronald, B,136436799.450.000.002071.424728.03
Moreno, Bruce, F,266521938.470.000.00782.991155.48
Lewis, Jasmine,139646806.450.000.002071.424735.03
Xu, Shawna,2341939.980.000.000.0039.98
Zheng, Kristen, J,244633917.540.000.002181.561735.98
Perez, Virginia, A,274941952.450.000.00782.991169.46
Malhotra, Kristopher, L,152652897.570.000.002049.10848.47
Blanco, Billy,233162835.020.000.002181.56653.46
Hughes, Lucas, E,266571357.970.000.001357.970.00
Lopez, Carmen, S,135284531.040.000.002071.422459.62
He, Curtis, D,249212180.410.000.001000.441179.97
Raman, Jay, M,136186763.150.000.002049.104714.05
She, Jessie, A,136506768.140.000.002049.104719.04
Lal, Corey, H,233132906.030.000.002181.56724.47
Dominguez, Darren, M,139666842.120.000.002049.104793.02
Madan, Johnathan, D,136266909.090.000.002049.104859.99
Ramirez, Cole, E,136166872.060.000.002049.104822.96
Liu, Krystal, D,135264549.760.000.002071.422478.34
Martinez, Pamela, A,135294614.860.000.002071.422543.44
He, Eugene, L,136456817.120.000.002049.104768.02
Wood, Sydney,233103333.320.000.003333.320.00
Li, Wesley,233223042.820.000.002443.35599.47
Alvarez, Carrie, W,234104016.530.000.002181.561834.97
Sutton, Kern, A,266601957.470.000.00782.991174.48
Martin, Craig, M,2501274.460.000.000.0074.46
Martin, Alyssa,1958721.490.000.000.0021.49
Wu, Nuan,292932384.070.000.000.002384.07
Diaz, Mallory, V,17289106.950.000.000.00106.95
Jai, Jodi, M,2797158.980.000.000.0058.98
Navarro, Leslie, E,243714193.820.000.002443.351750.47
Sharma, Arturo,136486765.440.000.002049.104716.34
Hernandez, Gina,140495290.680.000.002071.423219.26
Martinez, Monica, A,141293750.090.000.002049.101700.99
Xu, Cara,235263563.840.000.003563.840.00
Liu, Lacey, L,235453882.550.000.002181.561700.99
Patel, Jillian,266671390.950.000.001390.950.00
Powell, Adam,234233936.540.000.002181.561754.98
Suarez, Dana, M,235413337.040.000.002181.561155.48
Martinez, Brett,235323337.040.000.003337.040.00
Zhou, Krystal,235933990.010.000.002181.561808.45
Shen, Roger, G,140113831.890.000.003831.890.00
Hernandez, Alberto, D,250292272.200.000.001000.441271.76
Jiménez, Bruce, L,236403936.540.000.002181.561754.98
Zheng, Edwin, J,142165653.920.000.002049.103604.82
Garcia, Rebekah, M,140073772.410.000.003772.410.00
Moore, Thomas,140103861.390.000.003861.390.00
Zhang, Lacey, L,141273809.570.000.003809.570.00
Tang, Jenny, E,142105621.240.000.002071.423549.82
Harris, Ian, W,141283836.380.000.003836.380.00
Wang, Nathan,140396808.130.000.002049.104759.03
Yang, Stacey,142155665.890.000.002049.103616.79
Cai, Candice,267471938.470.000.00782.991155.48
Liu, Steve, V,235233337.040.000.003337.040.00
Mitchell, Wyatt, A,140485123.740.000.002071.423052.32
Serrano, Francis, R,235473598.830.000.002443.351155.48
Martin, Justin,235423337.040.000.002181.561155.48
Clark, Madison, A,140625647.920.000.003272.942374.98
Munoz, Kendra, S,235293617.830.000.003617.830.00
Romero, Jessie,250302180.410.000.001000.441179.97
Lopez, Rachael,234253951.520.000.002181.561769.96
Raje, Johnny,139755138.720.000.002049.103089.62
Vazquez, Eddie, T,140125249.920.000.002049.103200.82
Dominguez, Kristine, A,140206831.760.000.002071.424760.34
Romero, Gina,142345687.720.000.002071.423616.30
Mehta, Heidi,142265656.240.000.002071.423584.82
Murphy, Grace, J,236554144.340.000.002443.351700.99
He, Jon, L,142625652.540.000.002071.423581.12
Alvarez, Jessie,143245121.430.000.002049.103072.33
Carson, Bradley,239952983.340.000.002443.35539.99
Shen, Grant, B,267631957.470.000.00782.991174.48
Rai, Willie,146735117.750.000.002071.423046.33
Subram, Meredith, S,142615653.920.000.002049.103604.82
Sanchez, Cynthia, S,236623917.540.000.002181.561735.98
Zimmerman, Candice, J,267541938.470.000.00782.991155.48
Alonso, Diane, M,2063074.980.000.000.0074.98
Gill, Javier,156453785.080.000.002049.101735.98
Serrano, Leslie, T,1401462.270.000.000.0062.27
Raji, Devon, D,2189874.980.000.000.0074.98
Subram, Stefanie,12371214.040.000.000.00214.04
Liu, Bianca, K,1145831.920.000.0023.977.95
Deng, Colin, B,1829932.220.000.000.0032.22
She, Ricardo, A,1423378.970.000.000.0078.97
Rivera, Evan, Y,267571344.470.000.001344.470.00
Harris, Thomas,240022744.520.000.002181.56562.96

Generated 2025-11-01 01:33:13.709 UTC