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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Hu, Kristen, C,197886056.610.003578.270.002478.34
Shan, Colin,259211253.070.00699.100.00553.97
Sanchez, Abby, J,199666021.620.003578.270.002443.35
Ramirez, Olivia, D,197856076.610.003578.270.002498.34
Garcia, George,201604237.220.003578.27658.950.00
Blanco, Rodney, A,201584153.250.003578.27574.980.00
Carlson, Philip, P,119158143.000.003374.992369.962398.05
Andersen, Warren,119198171.520.003374.990.004796.53
Chande, Katrina, L,199686021.620.003578.270.002443.35
Reed, Riley, A,201574118.260.003578.27539.990.00
She, Valerie, C,202266067.200.003578.270.002488.93
Mr., Rodgers, Scott, M.,202115333.250.003578.270.001754.98
Raji, Dawn, C,202446021.620.003578.270.002443.35
Vazquez, Mallory, M,18283119.950.000.000.00119.95
Yuan, Marshall, P,199786060.500.003578.270.002482.23
Harrison, Colleen, L,202196044.590.003578.270.002466.32
Sanders, Kaylee, C,202216035.600.003578.270.002457.33
Rana, Meagan, M,119148165.960.003374.992329.982460.99
Rodriguez, Rachael, M,119444776.270.003374.99609.96791.32
Xu, Randy, S,119698173.020.003399.992319.992453.04
Li, Gilbert,239992730.540.000.002181.56548.98
Rana, Meredith,250322184.900.000.001000.441184.46
Gill, Kristine,199776044.590.003578.270.002466.32
Carlson, Wendy,202206060.500.003578.270.002482.23
Sai, Rachael,119128095.320.003374.990.004720.33
Shan, Johnny,119997043.270.003399.991308.312334.97
Mehta, Evelyn, S,204204132.240.003578.27553.970.00
Perez, Johnathan, D,204264139.750.003578.27561.480.00
Johnston, Tamara, H,18492218.260.000.000.00218.26
Suri, Jarrod, E,120048114.040.003374.992319.992419.06
Srini, Douglas, M,1673335.260.000.000.0035.26
Wang, Rosa, I,119938131.320.003374.990.004756.33
Lin, Claudia, A,14312191.270.000.00166.2824.99
Yang, Shannon,120018113.010.003374.992318.962419.06
Huang, Mandy,1826672.260.000.000.0072.26
Vance, Denise, L,212054886.700.002443.350.002443.35
Chande, Tonya,119928123.030.003399.990.004723.04
Munoz, Robyn,142145759.870.000.002049.103710.77
Blanco, Jésus, E,204486044.590.003578.270.002466.32
Chandra, Arthur, L,140326859.430.000.002071.424788.01
Wu, Laura,206156060.500.003578.270.002482.23
Shen, Gilbert, C,120056984.810.003399.991214.852369.97
Alvarez, Max, M,119868245.230.003399.992392.202453.04
Xie, Kelli, J,204526156.700.003578.270.002578.43
Hu, Leah,119948169.030.003374.992374.982419.06
Serrano, Lori,17066105.750.000.000.00105.75
Garcia, Monica, D,2026749.970.000.000.0049.97
Serrano, Kristi,206166093.200.003578.270.002514.93
Ma, Autumn,209944191.720.003578.27613.450.00
Yuan, Deborah,120214043.460.003399.990.00643.47
Sai, Frederick,209914118.260.003578.27539.990.00
Rubio, Sabrina, A,209844153.250.003578.27574.980.00
Nath, Kara, S,2117739.990.000.000.0039.99
Sara, Cassandra, D,209894148.740.003578.27570.470.00
Chen, Clarence, R,1514797.450.000.0037.9759.48
Liang, Gilbert,122423948.970.003374.990.00573.98
Perez, Molly,259411255.360.00699.100.00556.26
Cook, Victoria, J,206206044.590.003578.270.002466.32
Sanz, Lawrence, M,140306905.470.000.002071.424834.05
Fernandez, Rachael, M,239933072.320.000.002443.35628.97
Nath, Ricardo, C,120398213.000.003374.992394.462443.55
Subram, Kristi, N,15025128.940.000.000.00128.94
Hu, Susan,252422120.930.000.001000.441120.49
Blanco, Alberto, R,278672443.550.000.000.002443.55
Alonso, Ricky, S,140705618.930.000.003298.942319.99
Munoz, Diane, R,15795132.440.000.00132.440.00
Wood, Richard, W,243773945.530.000.002181.561763.97
Raje, Casey, A,14686203.460.000.0059.98143.48
Kovár, Whitney,131055585.450.000.002049.103536.35
Henderson, Marcus, D,1521268.960.000.004.9963.97
Subram, Stefanie,12371214.040.000.000.00214.04
Zhu, Louis,14858196.970.000.00187.988.99
Suarez, Kristy,219844175.610.002443.350.001732.26
Chander, Alejandro, M,2445575.470.000.0075.470.00
Guo, Brent, J,259451248.080.00699.100.00548.98
Allen, Logan,1581281.250.000.000.0081.25
Raman, Frederick, F,289429.990.000.009.990.00
Wright, Haley,2603688.980.000.000.0088.98
Suarez, Orlando,1112158.160.000.000.0058.16
Serrano, Marvin, E,1731697.450.000.000.0097.45
Rodriguez, Frederick, S,244584144.340.000.002443.351700.99
Blanco, Marc,249082155.920.000.002155.920.00
Martin, Justin,235423337.040.000.003337.040.00
Raji, Tasha, T,1705732.280.000.0032.280.00
Srini, Kristopher, A,2399739.980.000.0039.980.00
Carlson, Krista,28209574.980.000.00574.980.00
Suri, Erick,1663538.880.000.0038.880.00
Xie, Kurt, A,14344126.950.000.0063.9762.98
Kumar, Rafael, L,1908824.270.000.002.2921.98
Raji, Maurice, C,2061974.980.000.000.0074.98
Jenkins, Angela,157224448.570.000.002049.102399.47
Powell, Rachel,208184230.730.003578.27652.460.00
Hernandez, Philip,211933905.520.002181.560.001723.96
Yuan, Lacey, W,123496772.140.002049.102329.982393.06
Lu, Willie,211914169.330.002443.350.001725.98
Prasad, Gerald, B,1203581.240.000.0078.952.29
Raman, Ruth, L,211994144.340.002443.350.001700.99
Hernandez, Logan,123506791.750.002071.422319.992400.34
Hernandez, Melody, E,28212619.460.000.00619.460.00
Lopez, Barry, R,260201932.460.00782.990.001149.47
Hu, Omar, S,289542393.060.000.002393.060.00
He, Louis, E,212114900.680.002443.350.002457.33
Ruiz, Gloria,123435567.930.002049.101223.842294.99
She, Corey, T,212144659.900.002181.560.002478.34
Becker, Kara,211674657.510.002181.560.002475.95
Cai, Willie, S,259601957.470.00782.990.001174.48
Nara, Tara,211943911.530.002181.560.001729.97
Gomez, Sheila, J,211654673.880.002181.560.002492.32
Subram, Evelyn, S,212574144.340.002443.350.001700.99
Vazquez, Marvin, K,2195335.000.000.0035.000.00
Wood, Maria,126676813.120.002049.102344.962419.06
Dominguez, Kellie, E,1724486.270.000.0053.9932.28
Goel, Bridget,261341926.450.00782.990.001143.46
Carlson, Armando,17484126.960.000.00126.960.00
Sun, Jamie,213892770.520.002181.56588.960.00
Jai, Michele, E,212254732.860.002181.560.002551.30
Sara, Marco, L,1564196.750.000.0096.750.00
Chen, Autumn, I,214084624.910.002181.560.002443.35
Sharma, Corey, M,17495119.910.000.0056.9762.94
Ma, Brittney,125842633.390.002071.420.00561.97
Sullivan, Henry, L,2060323.780.000.0023.780.00
Jai, Kathryn,235463337.040.000.003337.040.00
Travers, Jimmy, V,126746829.470.002071.422319.992438.06
Coleman, Nicole, A,215584919.300.002443.350.002475.95
Chow, Christy, M,126816784.130.002049.100.004735.03
Jai, Latoya, S,212294198.330.002443.350.001754.98
Fernandez, Kristina, A,125812646.400.002071.420.00574.98
She, Colin, M,1513959.980.000.0059.980.00
Sun, Aimee, R,1831960.470.000.0060.470.00
Gomez, Mallory, R,248987.280.000.007.280.00
Jenkins, Noah, A,2437913.980.000.0013.980.00
Navarro, Sheila, L,218894624.910.002181.560.002443.35
Yang, Darryl, K,215714624.910.002181.560.002443.35
Kapoor, Jay, F,219564632.860.002181.560.002451.30
Ward, Brooke,130075671.240.002071.420.003599.82
Malhotra, Toni,261621903.480.00782.990.001120.49
Lu, Micah,221743007.830.002443.35564.480.00
Serrano, Reginald, J,130252690.400.002071.420.00618.98
Yuan, Jaclyn,249042199.900.001000.441199.460.00
Moreno, Marc,130242665.060.002049.100.00615.96
Zeng, Dennis, S,130505651.250.002071.420.003579.83
Zhang, Clarence, M,130016799.430.002049.102332.282418.05
Sai, Bruce,221944633.900.002181.560.002452.34
Hill, Noah,261921903.480.00782.990.001120.49
Zhao, Jaclyn, D,261671903.480.00782.990.001120.49
Garcia, Toni,221934886.700.002443.350.002443.35
Wang, Jon, A,261911938.470.00782.990.001155.48
Huang, Barbara,264421919.750.00782.990.001136.76
Arthur, Cassandra, M,224102983.340.002443.350.00539.99
Mehta, Denise,130806844.410.002049.102362.272433.04
Chen, Jake,228454633.900.002181.560.002452.34
Xie, Clarence,224022721.550.002181.560.00539.99
Vazquez, Theresa, F,225812749.320.002181.560.00567.76
Mehta, Ebony, J,228544659.900.000.002181.562478.34
Lal, Kara,225792730.540.000.002181.56548.98
Foster, Aidan,264451938.470.000.00782.991155.48
Gonzalez, Carolyn, H,224072756.540.000.002181.56574.98
Madan, Candace,224092746.040.000.002181.56564.48
Gutierrez, Hector,264232001.970.000.00782.991218.98
Kumar, Cedric, B,228604663.790.000.002181.562482.23
Yuan, Grant, C,249092149.910.000.002149.910.00
Ruiz, Krista, C,130816772.150.000.002049.104723.05
Price, Megan,249072183.910.000.002183.910.00
Lu, Valerie,229134684.390.000.002181.562502.83
Ashe, Briana,229404207.320.000.004207.320.00
Zhang, Claudia,131146807.450.000.002071.424736.03
Zeng, Barbara,231022730.540.000.002181.56548.98
Rodriguez, Evelyn,131176831.420.000.002049.104782.32
Russell, Noah, M,264471938.470.000.00782.991155.48
Arthur, Rebekah,229393961.030.000.002181.561779.47
Li, Krystal, A,249122120.930.000.002120.930.00
Thompson, Justin,229544179.330.000.004179.330.00
Rai, Michele, M,265671957.470.000.00782.991174.48
Cai, Amy,249202155.920.000.002155.920.00
Schmidt, Joe, M,229054624.910.000.002181.562443.35
Diaz, Jill, F,229363946.520.000.002181.561764.96
Fernandez, Brandy, B,229584208.310.000.002443.351764.96
Lewis, Hannah,265611336.960.000.00782.99553.97
Moreno, Jessie, C,229064624.910.000.002181.562443.35
Shen, Tamara, G,229353951.520.000.002181.561769.96
Kovar, Nancy, F,265681957.470.000.00782.991174.48
Natsuhara, Tony,230972770.520.000.002181.56588.96
Madan, Patricia, L,229884194.330.000.002443.351750.98
Morgan, Sara,131345648.920.000.002049.103599.82
Kumar, Tonya, A,229344173.320.000.002443.351729.97
Pal, Kara,249162169.900.000.002169.900.00
Blanco, Hector, J,229384173.320.000.002443.351729.97
Xu, Willie, C,131606839.460.000.002071.424768.04
Martin, Deanna,130916864.950.000.002071.424793.53
Chapman, Jodi, L,229663917.540.000.003917.540.00
Zhou, Heather, M,249142149.910.000.002149.910.00
Raje, Christy,231003007.120.000.002443.35563.77
Kumar, Michele,231073896.530.000.003896.530.00
Suarez, Kristi, D,230992983.340.000.002443.35539.99
Butler, Hannah, R,131115707.200.000.002071.423635.78
Moreno, Kristi,234153588.830.000.003588.830.00
Xu, Sharon, A,233443882.550.000.002181.561700.99
Perez, Ivan, S,234084218.820.000.002443.351775.47
Browning, Javier,231204144.340.000.002443.351700.99
Raji, Andres, E,139556888.440.000.002071.424817.02
Lewis, Jasmine,139646806.450.000.002071.424735.03
Anderson, Richard, G,249242143.900.000.001000.441143.46
Blanco, Billy,233162835.020.000.002181.56653.46
Jimenez, Naomi,249222145.920.000.001000.441145.48
Dominguez, Darren, M,139666842.120.000.002049.104793.02
Ramirez, Cole, E,136166872.060.000.002049.104822.96
Kumar, Misty, H,250101540.430.000.001000.44539.99
Gomez, Kendra, J,233202730.540.000.002181.56548.98
Yuan, Karla, W,136296889.110.000.002049.104840.01
Chen, Tiffany, A,233484167.310.000.002443.351723.96
Yuan, Terry, R,136466843.600.000.002049.104794.50
Sharma, Kelvin, D,266551322.980.000.001322.980.00
Alvarez, Carrie, W,234104016.530.000.002181.561834.97
Zhu, Dawn,266611912.470.000.00782.991129.48
Ramos, Juan,136336803.140.000.002049.104754.04
Sara, Barry, R,139656872.390.000.002071.424800.97
Zhao, Bianca,139716772.130.000.002049.104723.03
Zhao, Gilbert,231193945.530.000.002181.561763.97
Xu, Karl,233213060.820.000.002443.35617.47
Rubio, Bruce, E,233433936.540.000.002181.561754.98
Liu, Lacey, L,235453882.550.000.002181.561700.99
Serrano, Rebekah,141303814.060.000.003814.060.00
Sun, Rafael,267491322.980.000.001322.980.00
Lin, Mandy, C,250352183.910.000.001000.441183.47
Anand, Johnny,140585652.520.000.003355.242297.28
Yang, Ronnie,235243598.830.000.003598.830.00
Hernandez, Alberto, D,250292272.200.000.001000.441271.76
Bradley, Emma,142115662.900.000.002049.103613.80
Zheng, Edwin, J,142165653.920.000.002049.103604.82
Ramos, Tanya, R,140456804.130.000.002049.104755.03
Romero, Latasha,142205696.190.000.002071.423624.77
Garcia, Rebekah, M,140073772.410.000.003772.410.00
Tang, Jenny, E,142105621.240.000.003286.272334.97
Li, Jack, J,140715617.920.000.003297.932319.99
Chande, Derek,267431371.950.000.001371.950.00
Ruiz, Naomi,236493945.530.000.002181.561763.97
Cai, Candice,267471938.470.000.00782.991155.48
Ye, Christy,142195744.220.000.002071.423672.80
Kumar, Jenny, C,234293936.540.000.002181.561754.98
Serrano, Francis, R,235473598.830.000.003598.830.00
Chen, Rosa,234353917.540.000.002181.561735.98
Romero, Jessie,250302180.410.000.001000.441179.97
Pal, Donna, S,235723617.830.000.003617.830.00
Evans, Carlos, J,235384198.330.000.002443.351754.98
Lopez, Donald, A,267401938.470.000.00782.991155.48
Vazquez, Eddie, T,140125249.920.000.002049.103200.82
Li, Stacey,140645694.210.000.003375.252318.96
Ye, Jenny,250362120.930.000.001000.441120.49
Anand, Leonard,143163797.370.000.002049.101748.27
Li, Alvin,267641938.470.000.00782.991155.48

Generated 2024-09-20 00:05:52.938 UTC