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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Cook, Victoria, J,206206044.590.003578.270.002466.32
Johnson, Chloe, L,206176058.210.003578.270.002479.94
Alvarez, Philip, A,1112345.880.000.000.0045.88
Yuan, Kathryn, L,231063956.010.000.002181.561774.45
Butler, Gavin, D,2294971.970.000.000.0071.97
Powell, Amanda,28113901.350.000.000.00901.35
Xie, Kurt, A,14344126.950.000.000.00126.95
Chen, Clarence, R,1514797.450.000.000.0097.45
Stone, Christine, D,259481819.590.00699.100.001120.49
Rubio, Kristy,122433914.980.003374.990.00539.99
Prasad, Gerald, B,1203581.240.000.0064.9716.27
Ms., Simon, Britta,259461873.580.00699.100.001174.48
Ma, Darryl, R,1559981.240.000.000.0081.24
Hernandez, Philip,211933905.520.002181.560.001723.96
Carlson, Alfredo,16178108.850.000.000.00108.85
Ortega, Monique, C,123556818.110.002049.100.004769.01
Green, Jennifer,125712641.390.002071.420.00569.97
Yuan, Chad, C,211734659.900.002181.560.002478.34
Munoz, Casey, W,125702654.060.002049.100.00604.96
Lu, Willie,211914169.330.002443.350.001725.98
Moreno, Hector,211834657.510.002181.560.002475.95
Hernandez, Logan,123506791.750.002071.420.004720.33
Rai, Grant, R,125732668.080.002049.100.00618.98
Raman, Edgar, A,2759664.470.000.000.0064.47
Pal, Sheena, D,211973917.540.002181.560.001735.98
Flores, Katherine,211803882.550.002181.560.001700.99
She, Corey, T,212144659.900.002181.560.002478.34
Vance, Denise, L,212054886.700.002443.350.002443.35
Chande, Tracy, J,125882639.080.002049.100.00589.98
Goel, Bridget,261341926.450.00782.990.001143.46
Diaz, Nelson, C,213872745.330.002181.560.00563.77
Arun, Candace, J,213934925.170.002443.350.002481.82
Suarez, Pedro, A,246112219.420.001000.441218.980.00
Rodriguez, Carla, V,212304171.620.002443.350.001728.27
Shen, Shaun,126846893.080.002049.100.004843.98
Suarez, Lawrence, C,261311952.450.00782.990.001169.46
Cai, Curtis,212593907.540.002181.560.001725.98
Gutierrez, Jill, N,260241952.450.00782.990.001169.46
Hall, Jesse,261331938.470.00782.990.001155.48
Patterson, Melissa, E,126686839.460.002071.420.004768.04
Sara, Candace,213802735.530.002181.560.00553.97
Huang, Colleen, S,213792992.330.002443.350.00548.98
Perry, Gavin, M,125782668.080.002049.100.00618.98
She, Cedric, R,125802589.090.002049.100.00539.99
Xu, Kelvin, K,212223936.540.002181.560.001754.98
Torres, Meghan, I,212563917.540.002181.560.001735.98
Mr., Solanki, Ajay,18295144.270.000.000.00144.27
Dominguez, Kellie, E,1724486.270.000.000.0086.27
Sanz, Walter, J,1819594.470.000.000.0094.47
Sara, Marco, L,1564196.750.000.000.0096.75
Madan, Kristi, I,291842420.340.000.000.002420.34
Jai, Katrina,1304459.980.000.000.0059.98
James, Mariah, M,1910430.970.000.000.0030.97
Lal, Mario, T,233454.990.000.000.004.99
Liu, Bianca, K,1145831.920.000.000.0031.92
Sai, Ronald, B,136436799.450.000.002071.424728.03
Suarez, Tabitha,2511039.980.000.000.0039.98
She, Ricardo, A,1423378.970.000.000.0078.97
Sanz, Julio, H,214044684.390.002181.560.002502.83
Luo, Michele,260271938.470.00782.990.001155.48
Suri, Allen,215534666.500.002181.560.002484.94
Zhou, Trisha, B,126866864.460.002071.420.004793.04
Ms., Rusek, Pearlie, J.,219454886.700.002443.350.002443.35
Ramos, Randall,215724659.900.002181.560.002478.34
Sanchez, Candace, L,215674973.280.002443.350.002529.93
Thompson, Michael, M,261481917.460.00782.990.001134.47
Jai, Kathryn,235463337.040.000.002181.561155.48
Hill, Aaron,2581835.960.000.000.0035.96
Ashe, Jimmy, S,2895914.980.000.000.0014.98
Serrano, Dana, S,12678341.430.000.000.00341.43
Deng, Johnny,2140935.000.000.000.0035.00
Xie, Drew, A,20218104.690.000.000.00104.69
Gomez, Mallory, R,248987.280.000.000.007.28
Raji, Derek, D,1959163.420.000.000.0063.42
She, Candice,291782452.040.000.000.002452.04
Sharma, Lindsay, E,244783337.040.000.002181.561155.48
Xu, Willie, C,131606839.460.000.002071.424768.04
Chandra, Harold, K,1723686.270.000.000.0086.27
Martinez, Heidi, L,2292268.970.000.000.0068.97
Yuan, Willie,234214208.310.000.002443.351764.96
Xu, Rafael, A,218854641.850.002181.560.002460.29
Suarez, Brandi,218744638.890.000.002181.562457.33
Rai, Brendan, A,215694960.160.000.002443.352516.81
Rana, Nancy, H,261501992.460.000.00782.991209.47
Xie, Brendan,130182642.380.000.002071.42570.96
Goel, Carly, C,129896817.120.000.002049.104768.02
Ward, Brooke,130075671.240.000.002071.423599.82
Malhotra, Toni,261621903.480.000.00782.991120.49
Chapman, Kristi, l,219863882.550.000.002181.561700.99
Bell, Jessica,221784233.320.000.002443.351789.97
Hernandez, Frank, G,221984661.500.000.002181.562479.94
Gao, Christy, D,262041967.450.000.00782.991184.46
Ye, Martha,222004659.900.000.002181.562478.34
Deng, Jaime, R,219684722.880.000.002181.562541.32
Serrano, Reginald, J,130252690.400.000.002071.42618.98
Jones, Ethan,130516831.740.000.002071.424760.32
Lal, Leonard,261601938.470.000.00782.991155.48
Yuan, Grant, C,249092149.910.000.001000.441149.47
Wang, Erica, J,221682997.320.000.002443.35553.97
Lee, David, J,221994693.880.000.002181.562512.32
Hernandez, Leslie, D,129906829.470.000.002071.424758.05
Zeng, Dennis, S,130505651.250.000.002071.423579.83
Lin, Kelvin, A,130756843.940.000.002071.424772.52
Munoz, Craig, V,130766862.140.000.002049.104813.04
Goel, Alejandro, K,130776766.630.000.002049.104717.53
Zhang, Clarence, M,130016799.430.000.002049.104750.33
Rana, Whitney, A,130066762.150.000.002049.104713.05
Becker, Julie,13614114.210.000.000.00114.21
Blanco, Kari,1962741.750.000.0027.7713.98
Zhao, Jaclyn, D,261671903.480.000.00782.991120.49
Wang, Jon, A,261911938.470.000.00782.991155.48
Blanco, Orlando,225753018.330.000.002443.35574.98
Xu, Tony, L,225762721.550.000.002181.56539.99
Mehta, Denise,130806844.410.000.002049.104795.31
Xie, Clarence,224022721.550.000.002181.56539.99
Sara, Troy, R,225832821.510.000.002181.56639.95
Fernandez, Arthur, J,223992785.050.000.002181.56603.49
Green, Devin, J,264401957.470.000.00782.991174.48
Foster, Aidan,264451938.470.000.00782.991155.48
Luo, Lindsey, R,222015012.270.000.002443.352568.92
Luo, Devon, D,228504657.510.000.002181.562475.95
Zheng, Alisha,222034624.910.000.002181.562443.35
Gutierrez, Hector,264232001.970.000.00782.991218.98
Ruiz, Krista, C,130816772.150.000.002049.104723.05
Jai, Maurice,229324169.330.000.004169.330.00
Xu, Alejandro, R,265851903.480.000.00782.991120.49
Gill, Carolyn,2309467.930.000.000.0067.93
Garcia, Harold, K,14087341.970.000.00159.00182.97
Pal, Terrence, M,1303759.980.000.000.0059.98
Li, Justin,1412457.590.000.000.0057.59
Suarez, Meredith,150323800.080.000.002049.101750.98
Moreno, Kathleen, C,1523459.980.000.000.0059.98
Sai, Martin, L,2122129.990.000.000.0029.99
Cai, Vincent, L,1175758.050.000.0024.4933.56
Lal, Corey, H,233132906.030.000.002181.56724.47
Reed, Steven,2437327.770.000.000.0027.77
Sanz, Diane, M,2015313.980.000.000.0013.98
Liang, Barbara, T,229533899.490.000.002181.561717.93
Dominguez, Jerome, F,229873942.030.000.002181.561760.47
Mehta, Levi, M,131105583.940.000.002049.103534.84
She, Nina,229613891.540.000.002181.561709.98
Goel, Tommy,229093980.520.000.002181.561798.96
Gomez, Arthur,249172179.910.000.001000.441179.47
Johnsen, Mario, W,265871920.420.000.00782.991137.43
Rai, Michele, M,265671957.470.000.00782.991174.48
Chen, Crystal, M,265662016.950.000.00782.991233.96
Yuan, Julie,229593917.540.000.002181.561735.98
Ortega, Eddie,229084661.500.000.002181.562479.94
Becker, Gregory, M,131046894.440.000.002071.424823.02
Gao, Bianca, C,131125717.890.000.002049.103668.79
Parker, Timothy, C,229434144.340.000.002443.351700.99
Diaz, Jill, F,229363946.520.000.002181.561764.96
Lewis, Hannah,265611336.960.000.00782.99553.97
Shan, Carl, D,249192212.890.000.001000.441212.45
Kovar, Nancy, F,265681957.470.000.00782.991174.48
Kapoor, Bryant,229463911.530.000.003911.530.00
Lal, Bradley,131562663.690.000.002071.42592.27
Romero, Deanna, K,2357021.980.000.000.0021.98
Suri, Stanley, J,2749642.280.000.000.0042.28
Raje, Arturo, C,1422849.990.000.000.0049.99
Carlson, Francis,273401350.750.000.00782.99567.76
Gutierrez, Micheal, S,272991322.980.000.00782.99539.99
Zhang, Barbara,16338169.430.000.0058.47110.96
Zhou, Brent,1543432.280.000.000.0032.28
Navarro, Cheryl,131095682.900.000.002049.103633.80
Cook, Sydney, D,131185669.900.000.002049.103620.80
Lu, Sandra, N,135214514.770.000.004514.770.00
Tang, Wayne, S,130906812.420.000.002049.104763.32
Zhou, Heather, M,249142149.910.000.001000.441149.47
Raje, Christy,231003007.120.000.002443.35563.77
Baker, Jose, A,229374179.330.000.002443.351735.98
Patel, Stanley, L,249152145.920.000.001000.441145.48
Prasad, Cesar,234113577.820.000.003577.820.00
Perez, Ivan, S,234084218.820.000.002443.351775.47
Ramos, Danny,231214144.340.000.002443.351700.99
Gonzalez, Veronica, C,233113337.040.000.003337.040.00
Moreno, Bruce, F,266521938.470.000.00782.991155.48
Ma, Laura, L,245033617.830.000.002443.351174.48
Ashe, Brad,252282120.930.000.001000.441120.49
Hernandez, Alberto, D,250292272.200.000.001000.441271.76
Prasad, Harold,1960868.450.000.000.0068.45
Jimenez, Naomi,249222145.920.000.001000.441145.48
He, Curtis, D,249212180.410.000.001000.441179.97
She, Jessie, A,136506768.140.000.002049.104719.04
Kumar, Lacey,139606871.740.000.002071.424800.32
Allen, Kaylee,266531938.470.000.00782.991155.48
Madan, Johnathan, D,136266909.090.000.002049.104859.99
Kumar, Misty, H,250101540.430.000.001000.44539.99
Campbell, Jason, J,136256962.140.000.002049.104913.04
Hall, Amanda,266561345.950.000.001345.950.00
Ramos, Kristine,17479163.400.000.000.00163.40
Wu, Lisa,2615894.480.000.000.0094.48
Pal, Alvin, C,293192447.050.000.000.002447.05
Tang, Jenny, E,142105621.240.000.002071.423549.82
Jimenez, Kathleen,266541346.760.000.001346.760.00
Zhao, Gilbert,231193945.530.000.002181.561763.97
Xu, Cara,235263563.840.000.002443.351120.49
Zhu, Omar,250332120.930.000.001000.441120.49
Alonso, Renee,241662789.520.000.002181.56607.96
Chandra, Jermaine, A,142995108.760.000.002071.423037.34
Stone, Colin, K,126736768.140.002049.100.004719.04
Blanco, Kristi,1546437.270.000.000.0037.27
Zhu, Colin,1997383.440.000.000.0083.44
Xu, Tasha, E,1194882.260.000.000.0082.26
Vazquez, Byron,1112242.930.000.007.9534.98
Long, Nicole, C,13624114.970.000.0059.9854.99
Carlson, Armando,17484126.960.000.0021.98104.98
Sharma, Christian,1580962.590.000.0032.6029.99
Anand, Andrés,110968063.040.003374.992294.992393.06
Baker, Luke, J,2295239.980.000.0039.980.00
Ma, Bianca,19798128.440.000.0060.4767.97
Chander, Tommy,190862.290.000.002.290.00
Johnsen, Jerry,2667069.990.000.000.0069.99
Ma, Jorge, O,1405286.260.000.0027.2858.98
Vance, Kristi, T,2833847.970.000.000.0047.97
Gonzalez, Tina,196535314.250.003578.270.001735.98
She, Valerie, C,202266067.200.003578.270.002488.93
Fernandez, Candace,111058095.990.003399.992294.992401.01
Madan, Kristopher, A,252387.280.000.000.007.28
Jackson, Joshua,1723583.980.000.000.0083.98
Anand, Leonard,143163797.370.000.002049.101748.27
Cai, Roger, A,13002294.940.000.00167.99126.95
Gao, Arturo,287142433.040.000.002433.040.00
Nelson, Carol,135204551.360.000.004551.360.00
Gonzalez, Devin,184856063.210.003578.272484.940.00
Zhang, Suzanne, R,2031639.980.000.0039.980.00
Carlson, Mathew, A,230124.990.000.000.004.99
Cai, Steve, M,2215569.990.000.000.0069.99
Stone, Brenda, J,12697296.190.000.000.00296.19
Zeng, Suzanne,179184733.750.003578.270.001155.48
Allen, Luis, C,260191957.470.00782.990.001174.48
Lal, Terry,182776070.590.003578.270.002492.32
Carlson, Audrey, A,2526360.470.000.000.0060.47
Flores, Brianna,27706553.970.000.000.00553.97
Shan, Clarence,224082770.520.000.002181.56588.96
Morris, Megan,2364164.470.000.000.0064.47
Stone, Keith,1733140.960.000.000.0040.96
Wang, Autumn,130495647.220.000.002071.423575.80
Liang, Alan, L,29063801.830.000.000.00801.83
Allen, Devin,15806102.850.000.0038.8863.97
Xu, Alison,14227114.960.000.0049.9964.97
Yuan, Franklin,2459439.980.000.0039.980.00
Prasad, Marco, C,15606115.930.000.0077.9637.97
Moore, Thomas,140103861.390.000.003861.390.00
Raje, Dale, H,27746628.970.000.00628.970.00
Morgan, Nathaniel, E,1662671.570.000.0036.5934.98
Tang, Rafael, A,119088079.050.003374.992319.992384.07
Madan, Rachael, R,1648676.970.000.0076.970.00
She, Lindsay,29456765.320.000.000.00765.32
Tang, Terrence, R,17303123.450.000.000.00123.45

Generated 2024-11-12 22:33:26.044 UTC