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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Jai, Tommy, C,150272853.570.000.002049.10804.47
Suarez, Meredith,150323800.080.000.002049.101750.98
Ross, Julian,113635035.810.003399.990.001635.82
Gonzalez, Heidi, Z,1315724.990.000.000.0024.99
Goel, Katie, D,2770864.470.000.000.0064.47
Raji, Michele,151834368.700.000.002071.422297.28
Raman, Abby, T,151225193.720.000.002071.423122.30
Gonzalez, Joel, A,150433846.890.000.002071.421775.47
Yang, Wesley, K,151275182.730.000.002071.423111.31
Luo, Lacey,241752743.040.000.002181.56561.48
Zeng, Amy,242422756.540.000.002181.56574.98
Browning, Jay, M,242512983.340.000.002443.35539.99
Xu, Jaclyn,242522744.520.000.002181.56562.96
Chander, Keith, A,241742983.340.000.002443.35539.99
Tang, Drew, W,151784445.060.000.002049.102395.96
Suri, Carmen, E,242502738.490.000.002181.56556.93
Dominguez, Roberto, A,269171339.250.000.00782.99556.26
Romero, Frank, M,152092916.560.000.002049.10867.46
Chen, Jon,269201336.960.000.00782.99553.97
Raman, Meagan, J,151345151.710.000.002071.423080.29
Pal, Jenny,15132151.940.000.000.00151.94
Tang, April, A,259351256.030.00699.100.00556.93
Diaz, Vanessa, J,29100102.960.000.000.00102.96
Gill, Theodore,1114941.260.000.000.0041.26
Alvarez, Arthur,248927.280.000.000.007.28
Saunders, Brandy,119464697.310.003399.99554.97742.35
Nara, Tonya, C,17251123.960.000.0069.9753.99
Rana, Evelyn, D,18262142.450.000.000.00142.45
Zhu, Ernest,201594167.230.003578.27588.960.00
Randall, Toni,1660566.260.000.0027.2838.98
Reed, Riley, A,201574118.260.003578.27539.990.00
Yang, Darryl, K,215714624.910.002181.560.002443.35
Mr., Rovira Diez, Pablo,2119042.280.000.0042.280.00
Gutierrez, Gary, C,127016868.440.000.002071.424797.02
Lal, Franklin, A,141013679.900.000.002888.58791.32
Carson, Mitchell,1362399.200.000.000.0099.20
Cai, Gilbert, J,1825698.960.000.0063.9734.99
Ye, Vincent,13013256.240.000.000.00256.24
Madan, Summer, D,123476839.120.002049.100.004790.02
Ruiz, Kari, L,12695192.970.000.000.00192.97
Wang, Randy, G,2512568.490.000.000.0068.49
Serrano, Lori,17066105.750.000.000.00105.75
Srini, Jay, M,1832662.980.000.000.0062.98
Hernandez, Mathew, A,151844441.380.000.002071.422369.96
Rubio, Randall, M,172866029.570.003578.270.002451.30
Chen, Clayton, A,152194399.080.000.002049.102349.98
Bailey, Allison,2137769.990.000.000.0069.99
Wilson, Zachary,255581307.06699.100.000.00607.96
Lal, Devon, L,1523766.260.000.000.0066.26
Weber, Levi, A,13120205.390.000.0049.48155.91
Rubio, Larry,14223155.940.000.000.00155.94
Schmidt, Monica,1201273.960.000.008.9964.97
Carson, Terrence,113565069.290.003374.990.001694.30
Martinez, Cory, A,1512581.260.000.0031.2749.99
Vazquez, Theresa, F,225812749.320.000.002181.56567.76
Guo, Susan, A,2654314.230.000.0014.230.00
Suarez, Casey,265481322.980.000.00782.99539.99
Goldberg, Mindy,161594411.650.000.002071.422340.23
Zhang, Glenn, A,139675721.910.000.002049.103672.81
Kumar, Lacey,139606871.740.000.002071.424800.32
Martinez, Frederick,119918128.020.003374.990.004753.03
Dominguez, Kristi, M,136446864.460.000.002071.424793.04
He, Karen, C,27861539.990.000.000.00539.99
Alonso, Kristine,166864157.733578.270.000.00579.46
Sullivan, Ruth,277231155.480.000.000.001155.48
Zhao, Bianca,139716772.130.000.002049.104723.03
Sharma, Jerry, C,136516812.120.000.002049.104763.02
Serrano, Joy, L,14069173.940.000.000.00173.94
Sara, Barry, R,139656872.390.000.002071.424800.97
Hall, Haley,274891383.450.000.00782.99600.46
Arun, Ross, C,236583936.540.000.002181.561754.98
Gill, Anne,274691331.970.000.00782.99548.98
Xu, Tracy, L,179164787.740.003578.270.001209.47
Liang, Eugene,1397277.270.000.000.0077.27
Coleman, Brittany,1557934.980.000.0034.980.00
Raji, Brendan,131036842.600.000.002049.104793.50
Patel, Jillian,266671390.950.000.001390.950.00
Weber, Deanna, L,148553759.080.000.002049.101709.98
Gutierrez, Desiree,15216101.740.000.0027.2874.46
Chande, Katrina, L,199686021.620.003578.270.002443.35
Sanchez, Marie,2292490.950.000.0090.950.00
Suarez, Nelson,273551383.450.000.00782.99600.46
Evans, Adam, H,2582048.970.000.0048.970.00
Ye, Amy,11073191.900.000.000.00191.90
Martin, Felicia, L,15018112.460.000.00112.460.00
Yuan, Sharon,1200855.760.000.000.0055.76
Goel, April, C,16166108.850.000.0069.9738.88
Blanco, Orlando,225753018.330.000.002443.35574.98
Johnson, Morgan, E,120114735.810.003374.99618.47742.35
Lin, Darryl, J,1503141.270.000.0032.288.99
Srini, Carolyn, S,273711350.750.000.00782.99567.76
Madan, Raymond, W,208194181.760.003578.27603.490.00
Guo, Krystal, S,17381188.930.000.00188.930.00
Rana, Bryant,218784663.790.002181.560.002482.23
Martin, Anna, L,209884118.260.003578.270.00539.99
Hernandez, Danny,2714674.980.000.000.0074.98
Zhou, Trisha, B,126866864.460.002071.420.004793.04
Dominguez, Jimmy,219594702.390.002181.560.002520.83
Gonzalez, Tina,196535314.250.003578.270.001735.98
Hernandez, Leslie, D,129906829.470.000.002071.424758.05
Blanco, Ricky, F,1660667.170.000.000.0067.17
She, Valerie, C,202266067.200.003578.270.002488.93
Raje, Kurt,152102926.390.000.002071.42854.97
Rodriguez, Geoffrey,208174118.260.003578.27539.990.00
Wang, Alejandro,173106029.573578.270.000.002451.30
Chander, Melvin, L,242662749.320.000.002181.56567.76
Yuan, Maurice,243804.990.000.000.004.99
Chander, Drew, J,251112145.920.000.001000.441145.48
Murphy, Seth, A,257041239.090.00699.100.00539.99
Collins, Andrea,122503964.980.003399.990.00564.99
Flores, Miranda,1724383.980.000.0053.9929.99
Navarro, Sheila, L,218894624.910.002181.560.002443.35
Sara, Jarrod,206266038.560.003578.270.002460.29
Gill, Stacy,12679187.980.000.0024.99162.99
Liu, Jaclyn,129966808.150.000.002049.104759.05
Sanders, Devin, J,120143949.970.003399.990.00549.98
Jackson, Joshua,1723583.980.000.000.0083.98
Alexander, Austin,266731505.760.000.001505.760.00
Yuan, Chad, C,211734659.900.002181.560.002478.34
Alonso, Armando, M,136476793.150.000.002049.104744.05
Sharma, Donna,119986962.100.003374.991249.842337.27
Garcia, Ruth,206236093.200.003578.270.002514.93
Zeng, Erica,269241350.750.000.00782.99567.76
Anand, Johnny,140585652.520.000.003355.242297.28
Gonzalez, Francisco, L,122453967.260.003399.990.00567.27
Fernandez, Brandy, B,229584208.310.000.002443.351764.96
Carlson, Lawrence, L,2206469.990.000.0069.990.00
Navarro, Theresa,206276044.590.003578.270.002466.32
Hernandez, Hailey, A,1872786.270.000.000.0086.27
Deng, Tasha,114598141.330.003399.992322.282419.06
Liang, Gilbert,122423948.970.003374.990.00573.98
Alonso, Jimmy, T,18280126.560.000.000.00126.56
Moore, Natalie, W,182736104.210.003578.272525.940.00
Vazquez, Casey, S,131326880.620.000.002049.104831.52
Subram, Ivan, A,2614778.980.000.000.0078.98
She, Katie, B,11965118.740.000.0094.2524.49
Shan, Deborah,206246021.620.003578.270.002443.35
Xie, Kurt, A,14344126.950.000.000.00126.95
Suarez, Natasha,1467937.970.000.000.0037.97
Ross, Connor, J,208164228.720.003578.27650.450.00
Madan, Brandy, A,276871183.470.000.000.001183.47
Tang, Dawn, R,164965960.233578.270.000.002381.96
Andersen, Tracy,208154118.260.003578.27539.990.00
Lopez, Mayra, E,273561336.960.000.00782.99553.97
Raji, Christy,1558462.270.000.000.0062.27
Yuan, Rafael, J,206256029.570.003578.270.002451.30
Yang, Stacey,142155665.890.000.002049.103616.79
Serrano, Neil, L,17076103.460.000.000.00103.46
Martinez, Troy, L,208234216.750.003578.270.00638.48
Malhotra, Joel, E,1634358.250.000.000.0058.25
Hernandez, Ross,1467781.260.000.000.0081.26
Sharma, Clayton, D,122403964.980.003399.990.00564.99
Gonzalez, Carolyn, H,224072756.540.000.002181.56574.98
Suri, Molly,1750398.960.000.000.0098.96
Shan, Elijah, L,267951992.460.000.00782.991209.47
Xu, Kathryn,2521023.780.000.000.0023.78
Kumar, Barbara, N,274991331.970.000.00782.99548.98
Yuan, Tamara, E,211664909.670.002443.350.002466.32
Ruiz, Sabrina, A,2221442.280.000.000.0042.28
Li, Colin, J,1844521.490.000.000.0021.49
Kumar, Alison,212003932.540.002181.560.001750.98
Sutton, Kern, A,266601957.470.000.00782.991174.48
Diaz, Devin, D,15829187.980.000.000.00187.98
Hu, Marshall, H,267971957.470.000.00782.991174.48
Fernandez, Michele, M,2488423.780.000.000.0023.78
Martin, Jay,1959733.980.000.000.0033.98
Rodriguez, Carolyn,210022992.330.002443.350.00548.98
Sai, Lydia, L,139685181.700.000.002071.423110.28
Chander, Edwin, T,173704742.740.003578.270.001164.47
Ortega, Lance, C,123546797.130.002049.100.004748.03
Serrano, Tyrone,113605025.800.003399.990.001625.81
Rodriguez, Kristi,143453639.920.000.002049.101590.82
Sun, Lacey, L,1513181.260.000.000.0081.26
Luo, Ashlee,235344179.330.000.002443.351735.98
Sun, Todd,2201876.970.000.000.0076.97
Raman, Ruth, L,211994144.340.002443.350.001700.99
Lal, Shawna,179244733.750.003578.270.001155.48
Sanz, Jimmy,25810114.460.000.000.00114.46
Yang, Tiffany, K,212154624.910.002181.560.002443.35
Sharma, Terrence, N,173516117.693578.270.000.002539.42
Zimmerman, Jenny,1819730.970.000.008.9921.98
Gutierrez, Joy, A,1846653.990.000.000.0053.99
Yang, Todd, J,190946021.620.003578.270.002443.35
She, Marshall, D,18707122.760.000.00120.472.29
Xu, Rafael, N,211954144.340.002443.350.001700.99
She, Stacey,267481357.970.000.001357.970.00
He, Louis, E,212114900.680.002443.350.002457.33
Edwards, Evan, L,218884925.580.002443.350.002482.23
Nara, Katrina, Z,246082120.930.001000.441120.490.00
Suarez, Renee, L,127036891.120.000.002049.104842.02
Raje, Derek,125742626.390.002071.420.00554.97
Huang, Valerie, J,267451932.460.000.00782.991149.47
Sai, Regina,211924229.320.002443.350.001785.97
Blanco, Brandi, L,209867.280.000.000.007.28
Raman, Arthur,240012983.340.000.002443.35539.99
Zhou, Brent,1543432.280.000.000.0032.28
Chen, Alisha, J,142255603.920.000.002049.103554.82
Lal, Bradley,131562663.690.000.002071.42592.27
Jimenez, Melody, S,140663612.190.000.002853.57758.62
Chander, Tonya,15794113.970.000.000.00113.97
Anand, Alison, J,240092746.040.000.002181.56564.48
Raman, Brett, L,229304900.680.000.002443.352457.33
Zhou, Jaclyn, C,211794935.670.002443.350.002492.32
Sanchez, Nancy, L,222074921.690.000.002443.352478.34
Lee, Destiny,1705883.980.000.000.0083.98
Jai, Lacey, C,1137174.980.000.000.0074.98
Rodriguez, Cynthia, E,22206201.280.000.000.00201.28
Lin, Alan,229737.280.000.000.007.28
Saunders, Jillian,2117839.990.000.000.0039.99
King, Mackenzie, M,269161322.980.000.00782.99539.99
Rana, Stanley, J,2291958.980.000.000.0058.98
Rubio, Daisy, A,16181170.060.000.000.00170.06
Zeng, Stacey, J,17317128.950.000.000.00128.95
Perez, Henry,267521917.460.000.00782.991134.47
Hu, Omar, S,289542393.060.000.000.002393.06
Gutierrez, Jill, N,260241952.450.00782.990.001169.46
Andersen, Lacey,1960094.460.000.000.0094.46
Carlson, Jill,218864696.490.002181.560.002514.93
Raman, Edgar, A,2759664.470.000.000.0064.47
Suarez, Alfredo,196015314.250.003578.270.001735.98
Gill, Kristy,13669102.430.000.000.00102.43
Nelson, Natalie, C,2292858.980.000.000.0058.98
Lopez, Stanley, M,289622477.530.000.000.002477.53
Fernandez, Geoffrey,199636054.220.003578.270.002475.95
Hernandez, Victor, T,2353759.980.000.000.0059.98
Rodriguez, Pamela,29065777.340.000.000.00777.34
Andersen, Marshall, V,157864366.070.000.002049.102316.97
Mr., Spencer, Phil,199606120.110.003578.270.002541.84
Guo, Lisa, S,1731478.960.000.000.0078.96
Gao, Todd, M,110618129.023374.990.002369.962384.07
Srini, Candace,154372.290.000.000.002.29
Ye, Ramon,113574943.800.003374.990.001568.81
Bell, Jessica,221784233.320.000.002443.351789.97
Johnson, Sydney,1957190.950.000.0033.9856.97
Goel, Dawn,235354.990.000.000.004.99
Mr., Shen, Alan,242572770.520.000.002181.56588.96
Chander, Alisha,125722611.410.002071.420.00539.99
Jimenez, Jill,110286474.623374.990.000.003099.63
Nara, Tara,211943911.530.002181.560.001729.97
Raji, Lacey, E,1634188.250.000.000.0088.25
Xu, Jaclyn, L,126856904.110.002049.100.004855.01
Lopez, Patricia,2830529.480.000.000.0029.48
Navarro, Albert, L,215614947.780.002443.350.002504.43
Martinez, Anna, J,129946855.440.000.002071.424784.02
Parker, Gabriella,213944657.510.002181.560.002475.95
Long, Nicole, C,13624114.970.000.0059.9854.99
Suarez, Pedro, A,246112219.420.001000.441218.980.00
Anand, Andrés,110968063.040.003374.992294.992393.06
Cai, Vincent, L,1175758.050.000.0024.4933.56
Jai, Karla,18263126.940.000.0034.9991.95

Generated 2024-11-10 05:22:07.115 UTC