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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Zhang, James,1468438.550.000.000.0038.55
Suri, Arthur,261901932.460.000.00782.991149.47
Xu, Kathryn,2521023.780.000.000.0023.78
Gray, Morgan,28307561.480.000.000.00561.48
Rodriguez, Ruth, R,2617938.980.000.0038.980.00
Goel, Carl, S,172494426.743578.270.000.00848.47
Gonzalez, Dominique, J,2797658.980.000.000.0058.98
Zhang, Ramon, D,12352274.240.000.000.00274.24
Carlson, Philip, P,119158143.000.003374.992369.962398.05
Lal, Sheena,2331213.980.000.000.0013.98
Ye, Brent,2892229.480.000.000.0029.48
Chandra, Jermaine, A,142995108.760.000.002071.423037.34
Dominguez, Micheal,261421952.450.00782.990.001169.46
Xu, Dennis,2199739.990.000.000.0039.99
Vazquez, Eddie, T,140125249.920.000.002049.103200.82
Shen, Tony,29099548.980.000.000.00548.98
Carlson, Billy, C,19667150.950.000.000.00150.95
Rivera, Jada,2197032.280.000.000.0032.28
Raji, Dawn, C,202446021.620.003578.270.002443.35
She, Sheena, R,2300859.980.000.000.0059.98
Ma, Cedric, W,11094157.930.000.000.00157.93
Martinez, Emma,16734128.970.000.000.00128.97
Stone, Colin, K,126736768.140.002049.100.004719.04
Kumar, Louis, A,182034172.250.003578.270.00593.98
Ramos, Kendra,2489615.230.000.000.0015.23
West, Nathan,2437067.930.000.000.0067.93
Madan, Cassandra, D,29068751.340.000.000.00751.34
Suarez, Alberto, G,1871953.990.000.000.0053.99
Moreno, Melody, R,11760274.920.000.000.00274.92
Powell, Elizabeth, K,283064.990.000.000.004.99
Deng, Jaime, R,219684722.880.000.002181.562541.32
Prasad, Marco, C,15606115.930.000.0077.9637.97
Rai, Brendan, A,215694960.160.002443.350.002516.81
Zhou, Colleen,2312213.980.000.000.0013.98
Perez, Janelle,16172186.040.000.000.00186.04
Cai, Karen,225722997.320.000.002443.35553.97
Serrano, Kristi,206166093.200.003578.270.002514.93
Lu, Candice, I,2120474.980.000.000.0074.98
Martin, Alyssa,1958721.490.000.000.0021.49
Torres, Michele, A,161764404.080.000.002049.102354.98
Diaz, Carolyn, C,243603626.820.000.002443.351183.47
Lin, Kelvin, A,130756843.940.000.002071.424772.52
Simmons, Jordyn,164945961.203578.270.000.002382.93
Gonzalez, Ebony,110346491.323399.990.000.003091.33
Chander, Keith, A,241742983.340.000.002443.35539.99
Jimenez, Teresa, L,243723356.040.000.002181.561174.48
Martin, Diane,139586838.640.000.002049.104789.54
Chow, Christy, M,126816784.130.002049.100.004735.03
Gill, Kristy,13669102.430.000.000.00102.43
Sun, Shannon,120077023.780.003399.990.003623.79
Rodriguez, Tammy,1523359.980.000.000.0059.98
Nara, Cedric, M,218754921.690.002443.350.002478.34
Romero, Ricky,213612997.320.002443.350.00553.97
Jai, Ethan,1521741.260.000.0031.279.99
Zhu, Colin,1997383.440.000.0022.9760.47
Kennedy, Devon, J,131336813.120.000.002049.104764.02
Lopez, Barry, R,260201932.460.00782.990.001149.47
Coleman, Melanie, H,1563934.570.000.000.0034.57
Nelson, Carol,135204551.360.000.004551.360.00
Xie, Jaime,258231887.560.00699.100.001188.46
King, Mackenzie, M,269161322.980.000.00782.99539.99
Lopez, Francisco, L,1871424.270.000.0021.982.29
Vazquez, Carolyn,2365039.980.000.000.0039.98
Gill, Leslie,146702919.890.000.002071.42848.47
Gutierrez, Hector,264232001.970.000.00782.991218.98
_SUM9051988.22588293.382369718.482452674.723641301.64
Sai, Clifford,2512860.470.000.000.0060.47
Liu, Clayton, L,2137315.230.000.0015.230.00
Fernandez, Brandy, B,229584208.310.000.002443.351764.96
Prasad, Clifford,1560466.750.000.000.0066.75
Johnsen, Eddie,289352419.060.000.002419.060.00
Raji, Jaclyn,182898.990.000.000.008.99
Black, Wayne, E,250567.280.000.000.007.28
Pal, Omar,277141155.480.000.000.001155.48
Bradley, Victoria,29454742.350.000.000.00742.35
Madan, Jay, L,201564139.750.003578.27561.480.00
Martin, Jésus,28324548.980.000.000.00548.98
Kumar, Jaime, O,290613.990.000.000.003.99
Yuan, Kathryn, L,231063956.010.000.002181.561774.45
Suarez, Hector, L,15034103.450.000.008.9994.46
Goldstein, Brendan,135182638.360.000.002049.10589.26
Yang, Hunter, E,2023721.490.000.0021.490.00
Shan, Dylan,1967758.980.000.000.0058.98
Moreno, Janet, L,1559259.980.000.0024.9934.99
Garcia, Holly,265586.280.000.000.006.28
Sanz, Bruce,231173931.520.000.002181.561749.96
Gonzalez, Joel, A,150433846.890.000.002071.421775.47
Cai, Roger, A,13002294.940.000.00167.99126.95
Carson, Mitchell,1362399.200.000.000.0099.20
Morgan, Melissa, M,2022274.450.000.000.0074.45
Goel, Mario, J,123606750.480.002071.420.004679.06
Srini, Roy,248882174.920.001000.441174.480.00
Malhotra, Terrance, E,20223187.380.000.000.00187.38
Gao, Amy,219963946.520.000.002181.561764.96
Zeng, Warren, R,244773302.050.000.002181.561120.49
Griffin, Grace,114438235.000.003374.990.004860.01
Navarro, Dana, J,1112579.690.000.0047.4232.27
Dominguez, Theodore, F,219874638.890.000.002181.562457.33
Huang, Jake,1958995.260.000.000.0095.26
Blanco, Micheal, A,11113109.880.000.00101.937.95
Rana, Johnathan, R,2749737.290.000.000.0037.29
Green, Fernando,172584347.763578.270.000.00769.49
Shan, Kristin,234163598.830.000.003598.830.00
Wang, Alejandro,173106029.573578.270.000.002451.30
Gonzalez, Kaylee, L,218954657.510.002181.560.002475.95
Perez, Rachael, D,26762133.490.000.000.00133.49
Gao, Tiffany, E,163525948.493578.270.000.002370.22
Munoz, Casey, W,125702654.060.002049.100.00604.96
Black, Rafael,1196655.760.000.000.0055.76
Kovar, Nancy, F,265681957.470.000.00782.991174.48
Torres, Theresa,212024632.860.002181.560.002451.30
Serrano, Randall,27973539.990.000.000.00539.99
Shan, Jaime,2202056.970.000.000.0056.97
Rana, Henry,273421348.460.000.00782.99565.47
Perez, Joe, A,143265207.700.000.002071.423136.28
Xie, Marshall, M,1979613.980.000.0013.980.00
Xu, Roger,2796839.980.000.0039.980.00
Rana, Molly,2155474.980.000.000.0074.98
Raji, Willie, T,110708165.550.003399.992345.222420.34
Pal, Alison,1304284.470.000.000.0084.47
Li, Barbara,157884443.380.000.002071.422371.96
Vance, Monica, G,123388265.000.003374.990.004890.01
Hernandez, Philip,211933905.520.002181.560.001723.96
Anand, Johnny,140585652.520.000.003355.242297.28
Ms., Roy, Lisa, K.,214034895.690.002443.350.002452.34
Wood, Sydney,233103333.320.000.003333.320.00
Kovár, Donald, M,242779.990.000.009.990.00
Gill, Diane,155784509.900.000.002071.422438.48
Carlson, Byron,119008257.010.003399.992374.982482.04
Mehta, Levi, M,131105583.940.000.002049.103534.84
Sai, Monica, L,29055765.320.000.000.00765.32
Dominguez, Robin,166854183.233578.270.000.00604.96
Green, Jonathan, A,173324480.733578.270.000.00902.46
Wu, Aimee,16690165.070.000.000.00165.07
Chande, Jerry,183314752.750.003578.270.001174.48
Lopez, Kari,15235190.890.000.000.00190.89
Zhang, Clarence, M,130016799.430.000.002049.104750.33
Navarro, Casey,197956044.590.003578.270.002466.32
Stone, Brenda, J,12697296.190.000.000.00296.19
Navarro, Latasha, L,111008172.510.003374.992399.472398.05
Jai, Gregory,1634246.470.000.000.0046.47
Rodriguez, Geoffrey,208174118.260.003578.27539.990.00
Gao, Cara, B,156423772.410.000.002071.421700.99
Gomez, Armando, S,2117535.000.000.000.0035.00
Zhou, Heather, M,249142149.910.000.001000.441149.47
Arthur, Rebekah,229393961.030.000.002181.561779.47
He, Louis, E,212114900.680.002443.350.002457.33
Chapman, Kristi, l,219863882.550.000.002181.561700.99
Gao, Eugene,29464756.330.000.000.00756.33
Madan, Marco,1889527.770.000.0027.770.00
Kelly, Emma, A,156463804.080.000.002049.101754.98
Deng, Devon, H,199676029.570.003578.270.002451.30
Xu, Barbara,291952419.060.000.000.002419.06
Shan, Peter,2428027.770.000.000.0027.77
Gutierrez, Victor, J,2735769.990.000.000.0069.99
Ramos, Diane, L,1830064.880.000.000.0064.88
Blanco, Rodney, A,201584153.250.003578.27574.980.00
Li, Jaclyn,182816081.100.003578.270.002502.83
Garcia, Carolyn,209992735.530.002181.560.00553.97
Mr., Solanki, Ajay,18295144.270.000.000.00144.27
Nara, Tonya, C,17251123.960.000.0069.9753.99
Ortega, Lawrence,14685146.740.000.000.00146.74
Reed, Riley, A,201574118.260.003578.27539.990.00
Romero, Francis,221964632.860.000.002181.562451.30
Gao, Laura,2202930.970.000.000.0030.97
Arun, Brenda,136306824.730.000.002071.424753.31
Huang, Valerie, J,267451932.460.000.00782.991149.47
Sara, Candace,213802735.530.002181.560.00553.97
Mehta, Jay, S,150353772.410.000.002071.421700.99
Ferrier, Jaclyn, D,172994382.753578.270.000.00804.48
Sanchez, Lydia, S,125792589.090.002049.100.00539.99
Zhou, Alan,1648075.970.000.000.0075.97
Madan, Francisco, S,257061239.090.00699.100.00539.99
Wu, Marshall, J,155904440.050.000.002049.102390.95
Chande, Warren,17307132.950.000.00132.950.00
Wang, Autumn,130495647.220.000.002071.423575.80
Guo, Lisa, S,1731478.960.000.000.0078.96
Xie, Alvin, M,16617160.550.000.0069.9790.58
Sharma, Mario, J,259281316.050.00699.100.00616.95
Martin, Adrienne,1995239.460.000.0025.4813.98
Ramos, Jaime,1572070.220.000.0035.2334.99
Green, Devin, J,264401957.470.000.00782.991174.48
Alvarez, Beth, M,2930514.980.000.000.0014.98
Chande, Katrina, L,199686021.620.003578.270.002443.35
Ruiz, Kari, L,12695192.970.000.000.00192.97
Sun, Erica, P,261351967.450.00782.990.001184.46
Sanchez, Michele,2354312.940.000.000.0012.94
Nara, Dustin, M,179104698.760.003578.270.001120.49
Murphy, Jill, J,249022120.930.000.002120.930.00
Sanchez, Bryant, C,131136832.410.000.002071.424760.99
Madan, Terrance,249102183.910.000.001000.441183.47
Rubio, Beth,2024056.960.000.000.0056.96
Jones, Ethan,130516831.740.000.002071.424760.32
Shan, Warren,2197132.280.000.000.0032.28
Tang, Julie,265891966.460.000.00782.991183.47
Suarez, Alfredo,196015314.250.003578.270.001735.98
Garcia, Stefanie, E,277431155.480.000.000.001155.48
Andersen, Jenny,202596029.570.003578.270.002451.30
Gill, Jaime, M,261521938.470.00782.990.001155.48
Subram, Tabitha, C,175114150.530.003578.27572.260.00
Mehta, Pamela,22005135.460.000.000.00135.46
Vazquez, Francis, E,1728183.970.000.000.0083.97
Yuan, Jon,259371299.560.00699.100.00600.46
Raje, Gregory, C,2291139.980.000.000.0039.98
Dominguez, Theresa, L,187695304.250.003578.270.001725.98
Ross, Connor, J,208164228.720.003578.27650.450.00
Tang, Sharon, M,1582367.960.000.000.0067.96
Malhotra, Mayra, E,15577143.450.000.000.00143.45
Martin, Ebony, F,152234366.410.000.002071.422294.99
Gutierrez, Gary, C,127016868.440.000.002071.424797.02
Shen, Carly,2291513.980.000.000.0013.98
Gill, Theodore,1114941.260.000.000.0041.26
Lee, Richard, I,239962744.520.000.002181.56562.96
Kapoor, Dominic, J,1669967.580.000.000.0067.58
Henderson, Xavier, K,1299396.250.000.000.0096.25
Sai, Bruce,221944633.900.000.002181.562452.34
Mehta, Gerald,2023432.280.000.0032.280.00
Sullivan, Carla, A,206116021.620.003578.270.002443.35
Munoz, Darren,235394144.340.000.002443.351700.99
Liang, Dennis,14034104.240.000.000.00104.24
Madan, Candace,224092746.040.000.002181.56564.48
Xie, Clarence,224022721.550.000.002181.56539.99
Cooper, Katherine, R,14314122.950.000.000.00122.95
Bailey, Melissa, C,1957282.250.000.000.0082.25
Zeng, Alisha, A,15727134.460.000.000.00134.46
Gonzalez, Natalie,252152155.920.000.001000.441155.48
Li, Karen, K,179214698.760.003578.270.001120.49
Garcia, Donald,189296029.570.003578.270.002451.30
Simpson, Sharon, L,2512339.980.000.000.0039.98
Subram, Meredith, S,142615653.920.000.002049.103604.82
Becker, Leonard, C,22405123.980.000.000.00123.98
Li, Warren, R,29185563.770.000.000.00563.77
Liang, Rosa, L,197704127.250.003578.27548.980.00
Raman, Veronica, R,1235995.740.000.000.0095.74
Dominguez, Raquel, A,274701371.950.000.00782.99588.96
Romero, Paula, B,166914471.743578.270.00893.470.00
Romero, Lawrence, C,166876070.593578.270.002492.320.00
Carlson, Wendy,202206060.500.003578.270.002482.23
Ma, Jorge, O,1405286.260.000.0027.2858.98
Rodriguez, Arthur,154383788.680.000.002071.421717.26
Prasad, Denise,1829478.260.000.000.0078.26
King, Maria, E,282022419.060.000.002419.060.00
She, Melvin,165164733.753578.270.001155.480.00
Serrano, Anne,242443617.830.000.002443.351174.48
Dominguez, Roy, C,2918923.970.000.000.0023.97
Lu, Rosa, A,166634471.743578.270.00893.470.00
Perez, Whitney,1661997.580.000.0067.5929.99
Subram, Martin, S,1959032.280.000.0032.280.00
Sanz, Nelson, M,1405649.480.000.000.0049.48
Moreno, Hector,211834657.510.002181.560.002475.95

Generated 2025-11-03 12:06:11.676 UTC