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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Madan, Michele, A,126766859.460.002071.420.004788.04
Xie, Kurt, A,14344126.950.000.000.00126.95
Ma, Curtis,28119574.980.000.000.00574.98
Raman, Dominique, D,1302358.980.000.000.0058.98
Lopez, Kristopher, L,215604702.390.002181.560.002520.83
Diaz, Felicia, J,1502629.980.000.000.0029.98
Martinez, Roy, J,1396977.270.000.000.0077.27
Jimenez, Neil,22151133.490.000.000.00133.49
Rodriguez, Ruben,125892665.060.002049.100.00615.96
Hernandez, Melody, E,28212619.460.000.000.00619.46
Blanco, Hector, J,229384173.320.000.002443.351729.97
Flores, Brianna,27706553.970.000.000.00553.97
Madan, Jarrod, C,215554715.490.002181.560.002533.93
Raje, Lacey, T,123586787.760.002071.420.004716.34
Pal, Dustin,265881938.470.000.00782.991155.48
Kapoor, Troy, E,2461039.980.000.000.0039.98
King, Kevin, W,214024624.910.002181.560.002443.35
Gonzalez, Summer, L,2026660.470.000.000.0060.47
Chande, Tonya,119928123.030.003399.990.004723.04
Shan, Connor, C,1890135.000.000.000.0035.00
Zhu, Candice, S,212194696.490.002181.560.002514.93
Stone, Christine, D,259481819.590.00699.100.001120.49
Lal, Nina, L,142635647.930.000.002049.103598.83
Nara, Michele, R,2284286.460.000.000.0086.46
Vazquez, Roy,260291930.760.00782.990.001147.77
Powell, Rachel,208184230.730.003578.27652.460.00
Gonzalez, Cynthia,15787167.930.000.000.00167.93
Travers, Reginald,28488742.350.000.000.00742.35
Martinez, Ian,125852629.070.002049.100.00579.97
Hernandez, Philip,211933905.520.002181.560.001723.96
Xu, Alison,14227114.960.000.0049.9964.97
Liu, Dennis,29062742.350.000.000.00742.35
Garcia, Brandy,260281938.470.00782.990.001155.48
Munoz, Casey, W,125702654.060.002049.100.00604.96
Subram, Ronald, P,27733157.290.000.000.00157.29
Romero, Raquel, Z,2291658.980.000.000.0058.98
Sun, Micah,248872218.900.001000.441218.460.00
Blanco, Larry, E,212164935.670.002443.350.002492.32
Ashe, Marshall,2893293.970.000.000.0093.97
Gill, Dwayne, A,19675198.990.000.000.00198.99
Gill, Jaime, M,261521938.470.00782.990.001155.48
Rai, Grant, R,125732668.080.002049.100.00618.98
Blanco, Jimmy, V,14013138.450.000.000.00138.45
Gill, Jay,2797583.470.000.000.0083.47
Madan, Ann,219484886.700.002443.350.002443.35
Rai, Bradley,1910079.260.000.000.0079.26
Sanchez, Michelle, R,265691938.470.000.00782.991155.48
Lu, Todd, D,2426914.980.000.000.0014.98
Deng, Michele,219464659.800.002181.560.002478.24
Navarro, Daisy,27514539.990.000.000.00539.99
Rodriguez, Brett,2513439.980.000.000.0039.98
Gao, Candice, M,17493130.960.000.000.00130.96
Thompson, Michael, M,261481917.460.00782.990.001134.47
Vance, Denise, L,212054886.700.002443.350.002443.35
Diaz, Jill, F,229363946.520.000.002181.561764.96
Walker, Seth, E,27689539.990.000.000.00539.99
Lal, Mario, T,233454.990.000.000.004.99
Rubio, Desiree, D,211894208.310.002443.350.001764.96
Gonzales, Hunter,265701957.470.000.00782.991174.48
Fernandez, Shane, A,1312786.260.000.000.0086.26
He, Colin, B,143005322.730.000.002071.423251.31
Torres, Theresa,212024632.860.002181.560.002451.30
Raman, Ruben,155802910.900.000.002071.42839.48
Yuan, Warren, P,190912.290.000.000.002.29
Goel, Bethany,27511548.980.000.000.00548.98
Arun, Nancy, C,211694647.880.002181.560.002466.32
Jai, Brendan,26755123.980.000.000.00123.98
King, Jesse, J,1466581.260.000.000.0081.26
Hill, Aaron,2581835.960.000.000.0035.96
Chande, Tracy, J,125882639.080.002049.100.00589.98
Zhang, Dawn, A,1422282.260.000.000.0082.26
Nath, Tommy, B,289377.280.000.000.007.28
Taylor, Logan,1352259.980.000.000.0059.98
Diaz, Nelson, C,213872745.330.002181.560.00563.77
Ye, Dennis, M,166385974.233578.270.000.002395.96
Van, Brenda, J,2489039.980.000.0039.980.00
Andersen, Rafael, E,12691247.460.000.000.00247.46
Chen, Autumn, I,214084624.910.002181.560.002443.35
Raje, Donna, A,2060723.780.000.000.0023.78
Moreno, Tanya,1113983.970.000.000.0083.97
She, Colin, M,1513959.980.000.0034.9924.99
Rodriguez, Wyatt, D,212184661.500.002181.560.002479.94
Wu, Warren, M,1560263.970.000.000.0063.97
Raji, Colleen,27707561.480.000.000.00561.48
Deng, Johnny,2140935.000.000.000.0035.00
Romero, Ricky,213612997.320.002443.350.00553.97
Ye, Martha,222004659.900.000.002181.562478.34
Gutierrez, Dana,2025460.470.000.000.0060.47
Xu, Clarence,218774624.910.002181.560.002443.35
Sanchez, Lydia, S,125792589.090.002049.100.00539.99
Suarez, Rebekah,136496812.130.000.002049.104763.03
Gutierrez, Victor, J,2735769.990.000.000.0069.99
Nara, Dawn, M,218914921.690.002443.350.002478.34
Mr., Solanki, Ajay,18295144.270.000.000.00144.27
Dominguez, Raquel, A,274701371.950.000.00782.99588.96
Kapoor, Arthur,2448323.970.000.000.0023.97
Li, Marshall,126876805.470.002071.420.004734.05
Sanz, Walter, J,1819594.470.000.000.0094.47
Shan, Thomas, N,274831382.460.000.00782.99599.47
Martin, Jésus,28324548.980.000.000.00548.98
Sun, Erica, P,261351967.450.00782.990.001184.46
Gomez, Marvin, C,28479831.330.000.000.00831.33
Ms., Sanchez, Madalena, J.,130202589.090.000.002049.10539.99
Morgan, Natalie,1514963.970.000.000.0063.97
Madan, Cory,261541938.470.00782.990.001155.48
Deng, Tracy, E,2197837.290.000.000.0037.29
Long, Nicole, C,13624114.970.000.0059.9854.99
Cai, Trisha,1826564.980.000.000.0064.98
Long, Emily, L,261401917.460.000.00782.991134.47
Sullivan, Henry, L,2060323.780.000.000.0023.78
Rodriguez, Kristi,143453639.920.000.002049.101590.82
Johnson, Brianna, J,1731938.980.000.000.0038.98
Navarro, Kellie, I,218734661.500.000.002181.562479.94
Madan, Kristi, I,291842420.340.000.000.002420.34
Chandra, Arthur, L,140326859.430.000.002071.424788.01
Ramos, Jaime,1572070.220.000.0035.2334.99
Romero, Diane, F,219474632.860.000.002181.562451.30
Travers, Jimmy, V,126746829.470.002071.420.004758.05
Carson, Mitchell,1362399.200.000.000.0099.20
Carter, Amber, E,16679106.560.000.0071.5834.98
Pal, Tamara,126896846.920.000.002071.424775.50
Vazquez, Marie,218994663.790.002181.560.002482.23
Zhang, Ronnie,166565930.233578.270.000.002351.96
Guo, Don,1874221.980.000.000.0021.98
Rai, Brendan, A,215694960.160.000.002443.352516.81
Hernandez, Orlando, C,219514923.290.002443.350.002479.94
Baker, Jose, A,229374179.330.000.002443.351735.98
Shen, Carly,2291513.980.000.000.0013.98
Blanco, Mallory,219584696.490.000.002181.562514.93
Arthur, Jay, R,126946785.130.002049.100.004736.03
Gill, Lee, L,276941184.460.000.000.001184.46
Deng, Willie, J,278761214.850.000.000.001214.85
Rana, Nancy, H,261501992.460.000.00782.991209.47
Jiménez, Daisy,219444713.890.002181.560.002532.33
Xu, Alejandro, R,265851903.480.000.00782.991120.49
Navarro, Jaime, T,27690574.980.000.000.00574.98
Li, David, A,218944624.910.000.002181.562443.35
Serrano, Stacy,246132148.210.001000.441147.770.00
Butler, Jason,175104369.740.003578.270.00791.47
Suarez, Linda,1666581.810.000.000.0081.81
Dominguez, Micheal,261421952.450.000.00782.991169.46
Jai, Katrina,1304459.980.000.000.0059.98
Yuan, Sharon,1200855.760.000.000.0055.76
Ma, Todd,1958121.490.000.000.0021.49
Subram, Francisco, A,218974909.670.000.002443.352466.32
James, Mariah, M,1910430.970.000.000.0030.97
Sun, Louis, E,1618283.970.000.000.0083.97
Zhu, Gilbert,1192163.240.000.000.0063.24
She, Kelli, J,248892269.910.000.002269.910.00
Suarez, Tabitha,2511039.980.000.000.0039.98
Hu, Edwin,242404.990.000.000.004.99
Malhotra, Marco, L,29459805.330.000.000.00805.33
Ramos, Jay, D,218824886.700.000.002443.352443.35
Sun, Aimee, R,1831960.470.000.000.0060.47
Liu, Kelli, A,244804175.610.000.002443.351732.26
Romero, Joy, D,2488680.470.000.000.0080.47
Ma, Rafael, T,130222644.020.000.002049.10594.92
Gomez, Mallory, R,248987.280.000.000.007.28
Turner, Rebecca, W,276991155.480.000.000.001155.48
Dominguez, Gerald, E,2063171.960.000.000.0071.96
Torres, Jacqueline,219764198.330.000.002443.351754.98
Jenkins, Noah, A,2437913.980.000.000.0013.98
Fernandez, Brenda, L,164934197.253578.270.000.00618.98
Fernandez, Jay,2015559.980.000.000.0059.98
Liang, Glenn,219834144.340.000.002443.351700.99
Anand, Alícia, J,291132453.040.000.000.002453.04
Sanz, Rodney,1692644.950.000.000.0044.95
Chen, Claudia, R,1662764.880.000.0029.9934.89
Martinez, Cynthia,221702745.330.000.002181.56563.77
She, Candice,291782452.040.000.000.002452.04
Arthur, Joel,277011155.480.000.000.001155.48
Garcia, Troy, M,292904.990.000.004.990.00
Murphy, Jill, J,249022120.930.000.001000.441120.49
Jai, Drew, M,215624632.860.000.002181.562451.30
She, Mindy, J,13009168.670.000.000.00168.67
Weber, Jarrod, M,1485931.270.000.0031.270.00
Torres, Eddie, L,219853936.540.000.002181.561754.98
Chavez, Clayton,219494659.900.000.002181.562478.34
Alvarez, Adrienne, L,17067113.960.000.000.00113.96
Romero, Jacquelyn,2581539.980.000.0039.980.00
Ortega, Shannon,263751971.450.000.00782.991188.46
Mehta, Mayra,129985694.900.000.002049.103645.80
Henderson, Marcus, D,1521268.960.000.000.0068.96
Moore, Nathan, N,283232384.070.000.002384.070.00
Fernandez, Ivan,220323882.550.000.002181.561700.99
Sharma, Lindsay, E,244783337.040.000.002181.561155.48
Martin, Hector,27860615.470.000.000.00615.47
Navarro, Erik, E,250557.280.000.000.007.28
Cai, Bianca, D,221732735.530.000.002181.56553.97
Deng, Jodi,161612700.050.000.002049.10650.95
Alonso, Joanna, M,27862548.980.000.000.00548.98
Gomez, Carrie,229657.280.000.000.007.28
Subram, Virginia,130362677.070.000.002049.10627.97
Xu, Willie, C,131606839.460.000.002071.424768.04
Subram, Joe,136316817.120.000.002049.104768.02
Ma, Jeffery,1826469.970.000.000.0069.97
Chandra, Cynthia,220004663.790.000.002181.562482.23
Lopez, Sergio, L,1512381.260.000.000.0081.26
Washington, Sydney,289244.990.000.000.004.99
Nara, Devon, C,21964103.490.000.000.00103.49
Hernandez, Frank, G,221984661.500.000.002181.562479.94
Raji, Andres, E,139556888.440.000.002071.424817.02
Rubio, Daisy, A,16181170.060.000.000.00170.06
Ramos, Sabrina, L,29082742.350.000.000.00742.35
Pal, Jenny,15132151.940.000.000.00151.94
Martin, Byron, E,2521739.980.000.000.0039.98
Cai, Alvin, D,1111535.230.000.0027.287.95
Shan, Jenny, W,1670692.970.000.000.0092.97
Yuan, Willie,234214208.310.000.002443.351764.96
Suarez, Dana, M,235413337.040.000.002181.561155.48
Saunders, Brandy,119464697.310.003399.99554.97742.35
Andersen, Roger,2446964.470.000.0064.470.00
Yang, Kevin, F,2060584.960.000.000.0084.96
Becker, Julie,13614114.210.000.000.00114.21
Rana, Evelyn, D,18262142.450.000.000.00142.45
Rodriguez, Dylan, E,1661175.530.000.0042.9332.60
Zhang, Tiffany, R,1731843.970.000.000.0043.97
Lu, Micah,221743007.830.000.002443.35564.48
Goldberg, Mindy,161594411.650.000.002071.422340.23
Andersen, Ashlee, J,11059116.930.000.00116.930.00
Gao, Christy, D,262041967.450.000.00782.991184.46
Serrano, Reginald, J,130252690.400.000.002071.42618.98
Kumar, Lacey,139606871.740.000.002071.424800.32
Vazquez, Krista,2616469.990.000.000.0069.99
Deng, Jaime, R,219684722.880.000.002181.562541.32
Cai, Jorge,220313896.530.000.002181.561714.97
Dominguez, Kristi, M,136446864.460.000.002071.424793.04
Zhang, Roger,126906.280.000.000.006.28
Suarez, Kristy,219844175.610.000.002443.351732.26
Moreno, Marc,130242665.060.000.002049.10615.96
Alonso, Kristine,166864157.733578.270.000.00579.46
Tang, Ashlee, D,11369118.960.000.000.00118.96
Romero, Francis,221964632.860.000.002181.562451.30
Suri, Arthur,261901932.460.000.00782.991149.47
Zhao, Bianca,139716772.130.000.002049.104723.03
Nath, Dale, B,27343132.970.000.000.00132.97
Lee, David, J,221994693.880.000.002181.562512.32
Goel, Alejandro, K,130776766.630.000.002049.104717.53
Serrano, Joy, L,14069173.940.000.000.00173.94
Raman, Sergio,278662398.050.000.000.002398.05
Perez, Ebony, M,249002155.920.000.002155.920.00
Black, Tracy, B,249032164.910.000.002164.910.00
Hall, Haley,274891383.450.000.00782.99600.46
Vance, Ruth, D,17302147.440.000.0058.9888.46
Lal, Deborah, T,219823882.550.000.002181.561700.99
Dominguez, Theodore, F,219874638.890.000.002181.562457.33
Gill, Anne,274691331.970.000.00782.99548.98
Sanchez, Manuel,1512686.260.000.0058.9827.28
Garcia, Toni,221934886.700.000.002443.352443.35
Zhao, Jaclyn, D,261671903.480.000.00782.991120.49

Generated 2024-11-10 07:42:23.706 UTC