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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Malhotra, Janelle,2642569.990.000.000.0069.99
Arthur, Regina, A,190896093.200.003578.270.002514.93
Sai, Martin, L,2122129.990.000.000.0029.99
Raje, Dale, H,27746628.970.000.00628.970.00
Black, Russell,1889737.290.000.000.0037.29
Shen, Lindsey,265601396.440.000.00782.99613.45
Carlson, Clinton, E,11116148.700.000.0027.28121.42
Beck, Barbara,265471407.960.000.00782.99624.97
Hernandez, Roberto,289232393.060.000.002393.060.00
Luo, Colin, L,2121039.990.000.000.0039.99
Nara, Tara,211943911.530.002181.560.001729.97
Johnson, Brianna, J,1731938.980.000.000.0038.98
Navarro, Kristy, J,1957074.940.000.0045.9528.99
Hernandez, Raquel, W,139974586.350.000.002071.422514.93
Wu, Warren, M,1560263.970.000.000.0063.97
Romero, Dwayne,28314553.970.000.000.00553.97
Gomez, Marvin, C,28479831.330.000.000.00831.33
Lin, Clayton, M,274921344.910.000.00782.99561.92
Chande, Casey,2614978.980.000.000.0078.98
Lal, Mario, T,233454.990.000.000.004.99
Lin, Wesley,2140742.280.000.0042.280.00
Jai, Dylan, J,2312839.980.000.000.0039.98
Black, Tommy,243764.990.000.000.004.99
Romero, Mallory,2643469.990.000.000.0069.99
Navarro, Eddie, C,245043563.840.000.002443.351120.49
Murphy, Seth, A,257041239.090.00699.100.00539.99
Sai, Emmanuel,234173337.040.000.002181.561155.48
Harris, Thomas,240022744.520.000.002181.56562.96
Jai, Brad, C,1826764.980.000.0034.9929.99
Lal, Kate,215574886.700.002443.350.002443.35
Becker, Kelli, E,1663371.580.000.000.0071.58
Raje, Jodi, E,1963074.450.000.000.0074.45
Sara, Geoffrey,261881938.470.000.00782.991155.48
Deng, Carl,182846029.570.003578.272451.300.00
Thomas, Sydney,143225111.440.000.002049.103062.34
Wilson, Jasmine,173296021.620.003578.270.002443.35
Navarro, Carolyn,110698104.050.003399.992319.992384.07
Moreno, Mallory, P,229124659.900.000.002181.562478.34
Lopez, Heidi,110528131.323374.990.002337.272419.06
Martinez, Douglas, C,2284135.000.000.0035.000.00
Suarez, Nelson,273551383.450.000.00782.99600.46
Gonzalez, Tina,196535314.250.003578.270.001735.98
Ashe, Kathryn,1616880.110.000.0034.8945.22
Browning, Jay, M,242512983.340.000.002443.35539.99
Diaz, Emma, L,1871110.240.000.000.0010.24
She, Mandy, K,2197240.230.000.000.0040.23
Suarez, Jerome, L,206226139.590.003578.270.002561.32
Alonso, Jimmy, T,18280126.560.000.000.00126.56
Smith, Thomas,1706853.990.000.000.0053.99
Deng, Kate, L,157234444.070.000.002049.102394.97
Morcos, Hany,208214118.260.003578.270.00539.99
Tang, Terrence, R,17303123.450.000.000.00123.45
Huang, Omar, C,1423277.270.000.000.0077.27
Madan, Martin, M,24911102.960.000.000.00102.96
Huang, Lacey, J,1195163.520.000.000.0063.52
Hernandez, Wendy, A,15124122.440.000.000.00122.44
Cooper, Katherine, R,14314122.950.000.000.00122.95
Cai, Tiffany,182044133.240.003578.270.00554.97
Huang, Barbara,264421919.750.000.00782.991136.76
Lal, Terrence,1236994.230.000.000.0094.23
Raji, Lindsey,182056056.610.003578.272478.340.00
Gomez, Carrie,229657.280.000.000.007.28
Anderson, Richard, G,249242143.900.000.001000.441143.46
Fernandez, Kristi,1958528.990.000.000.0028.99
Raje, Lacey, T,123586787.760.002071.420.004716.34
Dominguez, Walter,125762653.070.002049.100.00603.97
Arun, Denise,2821818.970.000.000.0018.97
Rivera, Jada,2197032.280.000.000.0032.28
Shen, Misty, S,2501923.970.000.000.0023.97
Gill, Kellie,1729294.220.000.000.0094.22
Munoz, Jacquelyn,291152407.040.000.000.002407.04
Ross, Brandon,141323804.080.000.002049.101754.98
Lopez, Mayra, E,273561336.960.000.00782.99553.97
Subram, Ronald, P,27733157.290.000.000.00157.29
Diaz, Gerald, M,251187.280.000.000.007.28
Perez, Toni,15581113.940.000.000.00113.94
Cai, Warren,249182120.930.000.001000.441120.49
Huang, Willie, C,28133574.980.000.000.00574.98
Torres, Gina,179044733.750.003578.270.001155.48
Pal, Dale,1845175.470.000.000.0075.47
Lopez, Patricia,2830529.480.000.000.0029.48
Dominguez, Kristine, A,140206831.760.000.002071.424760.34
Li, Dawn, B,1396240.220.000.0040.220.00
Alvarez, Tyrone, K,27693539.990.000.000.00539.99
Munoz, Felicia, D,2040659.980.000.000.0059.98
Nath, Tommy, B,289377.280.000.000.007.28
Kapoor, Jay, F,219564632.860.002181.560.002451.30
Malhotra, Joel, E,1634358.250.000.000.0058.25
Chavez, Karla, K,1670491.260.000.000.0091.26
Andersen, Jodi,2676678.980.000.000.0078.98
Alonso, Joanna, M,27862548.980.000.000.00548.98
Ramos, Michele, J,1957496.740.000.000.0096.74
Kumar, Alejandro,140555177.400.000.002049.103128.30
Munoz, Diane, R,15795132.440.000.000.00132.44
Gonzalez, Eric, C,1909278.260.000.000.0078.26
Yang, Lacey,1315089.240.000.000.0089.24
Shen, Calvin, W,2614578.980.000.000.0078.98
Xu, Peter, K,282042419.060.000.002419.060.00
Xu, Kathryn,2521023.780.000.000.0023.78
Gill, Dwayne, A,19675198.990.000.000.00198.99
Luo, Bethany,1958236.270.000.000.0036.27
Madan, Rachael, R,1648676.970.000.0076.970.00
She, Jeffery, M,2714942.280.000.000.0042.28
Martin, Casey, J,2296239.980.000.000.0039.98
Goel, Katie, D,2770864.470.000.000.0064.47
Gonzalez, Dominique, J,2797658.980.000.000.0058.98
Weber, Jarrod, M,1485931.270.000.0031.270.00
Thompson, Michael, M,261481917.460.00782.990.001134.47
Goel, Dale, M,204164118.260.003578.27539.990.00
Arun, Bryant, C,2045321.490.000.0021.490.00
Collins, Logan, H,13983180.410.000.00145.4234.99
Suarez, Linda,1666581.810.000.000.0081.81
Jimenez, Victor,114618089.040.003374.992294.992419.06
Goldstein, Brendan,135182638.360.000.002049.10589.26
Patel, Virginia, R,1136677.270.000.000.0077.27
Lal, Alicia,157344426.410.000.002071.422354.99
Serrano, Tabitha,283272407.040.000.002407.040.00
Gonzalez, Jay, C,142385642.900.000.002049.103593.80
Sutton, Cassie, S,16613129.350.000.000.00129.35
Mehta, Evelyn, S,204204132.240.003578.27553.970.00
Sun, Edwin, O,2117074.980.000.000.0074.98
Chen, Erica, P,183086037.890.003578.272459.620.00
Garcia, Rebekah, M,140073772.410.000.003772.410.00
Gill, Joanna,2618638.980.000.000.0038.98
Dominguez, Larry,221974740.980.000.002181.562559.42
Dominguez, Roberto, A,269171339.250.000.00782.99556.26
Weber, Cynthia,269211336.960.000.00782.99553.97
Huang, Crystal, L,260231917.460.00782.990.001134.47
Jiménez, Darren, W,28931166.280.000.000.00166.28
Rana, Jermaine, S,289272419.060.000.002419.060.00
Torres, Eddie, L,219853936.540.000.002181.561754.98
Sanz, Lance,225732721.550.000.002181.56539.99
Gutierrez, Larry,259261308.060.00699.100.00608.96
Shen, Kelsey, R,229214647.880.000.002181.562466.32
Sai, Evelyn,2041513.980.000.000.0013.98
Serrano, Beth,243043946.520.000.002181.561764.96
Ma, Cara,18885110.460.000.00110.460.00
Raje, Shawn,1705483.980.000.000.0083.98
Ramos, Adrienne, L,282167.280.000.007.280.00
Lopez, Chelsea,243694.990.000.000.004.99
Raman, Candace, M,117668280.480.003399.992419.462461.03
Navarro, Rodney, L,293092419.060.000.000.002419.06
Li, Edwin,269671336.960.000.001336.960.00
Rubio, Bruce, E,233433936.540.000.002181.561754.98
Sullivan, Henry, L,2060323.780.000.000.0023.78
Gonzalez, Summer, L,2026660.470.000.000.0060.47
Romero, Lawrence, C,166876070.593578.270.002492.320.00
Sharma, Mario, J,259281316.050.00699.100.00616.95
Chandra, Jarrod,241713006.310.000.002443.35562.96
Alvarez, Jessie,143245121.430.000.002049.103072.33
Vazquez, Mallory, M,18283119.950.000.000.00119.95
Lal, Nicolas, D,2121274.980.000.0074.980.00
Goel, Bridget,261341926.450.00782.990.001143.46
Ruiz, Carolyn, M,27863565.470.000.000.00565.47
Moreno, Danny, M,29458811.320.000.000.00811.32
Perez, Joe, A,143265207.700.000.002071.423136.28
Mehta, Regina,1724592.970.000.000.0092.97
Chande, Raul, L,2117635.000.000.0035.000.00
Ye, Willie,2296358.980.000.000.0058.98
Ramos, Danny,231214144.340.000.002443.351700.99
Xu, Kristen,157514446.400.000.002071.422374.98
Zhou, Gilbert,244753945.530.000.002181.561763.97
Allen, Kaylee,266531938.470.000.00782.991155.48
Shen, Mitchell, M,229044759.990.000.002181.562578.43
Serrano, Jésus, B,129915641.900.000.002049.103592.80
Chande, Ricardo, L,244714.990.000.000.004.99
Sanchez, Henry,2696878.980.000.000.0078.98
Ramirez, Cole, E,136166872.060.000.002049.104822.96
Griffin, Rachel,182556067.200.003578.270.002488.93
Liu, Glenn,188994118.260.003578.27539.990.00
Perry, Madison, R,233084.990.000.000.004.99
Kumar, Bethany,29299548.980.000.000.00548.98
Ruiz, Leslie, J,260327.280.000.007.280.00
Wu, Arturo, A,28321599.470.000.000.00599.47
Barnes, Taylor,142795137.710.000.002049.103088.61
Chen, Crystal, M,265662016.950.000.00782.991233.96
Gutierrez, Victor, J,2735769.990.000.000.0069.99
Carlson, Orlando, J,118938123.030.003374.992319.992428.05
Deng, Latoya, H,219694759.470.000.002181.562577.91
Cook, Victoria, J,206206044.590.003578.270.002466.32
Zhang, Suzanne, R,2031639.980.000.0039.980.00
Ramos, Mary, B,1501972.960.000.008.9963.97
Lopez, Savannah,257091308.060.00699.100.00608.96
Rana, Stanley, J,2291958.980.000.000.0058.98
Zhu, Sandra, V,157324376.400.000.002071.422304.98
Gutierrez, Tabitha, A,2188474.980.000.000.0074.98
Zhu, Suzanne, E,251122155.920.000.001000.441155.48
Washington, Sydney,289244.990.000.000.004.99
Cai, Gilbert, J,1825698.960.000.0063.9734.99
Davis, Isabella, A,229294673.880.000.002181.562492.32
Nara, Cedric, M,218754921.690.002443.350.002478.34
Sharma, Tony,182416058.210.003578.272479.940.00
Lee, Destiny,1705883.980.000.000.0083.98
Sara, Clifford, M,241782810.530.000.002181.56628.97
Huang, Eugene, L,110016383.883374.990.002419.93588.96
Ye, Franklin, L,1395282.260.000.000.0082.26
Johnson, Emma, M,1513662.270.000.0034.9927.28
Mr., Rodgers, Scott, M.,202115333.250.003578.270.001754.98
Goel, Ricardo, T,259611938.470.00782.990.001155.48
Madan, Candace,224092746.040.000.002181.56564.48
Carlson, Mathew, A,230124.990.000.000.004.99
Ruiz, Shannon,208224134.530.003578.27556.260.00
Watson, Alexandra, H,252491868.56699.100.000.001169.46
Simpson, Sharon, L,2512339.980.000.000.0039.98
Jai, Maurice,229324169.330.000.004169.330.00
Sara, Marco, L,1564196.750.000.000.0096.75
Gao, Amy,219963946.520.000.002181.561764.96
Reed, Steven,2437327.770.000.000.0027.77
Lu, Willie,211914169.330.002443.350.001725.98
Raji, Sharon,2332939.980.000.000.0039.98
Gill, Kristine,199776044.590.003578.270.002466.32
Gutierrez, Diana,1967667.970.000.000.0067.97
Gutierrez, Latasha, C,150222999.910.000.002071.42928.49
Gill, Billy, L,1670092.970.000.000.0092.97
Lopez, Cesar,17500156.960.000.000.00156.96
Raman, Rachael,2521679.470.000.000.0079.47
Shen, Kathryn, R,219574919.300.002443.350.002475.95
Griffin, Olivia,2120839.980.000.000.0039.98
Madan, Meagan,117678319.510.003399.992475.972443.55
Patel, Pamela, G,278751268.840.000.001268.840.00
Williams, Anna, R,175044362.740.003578.270.00784.47
Rodriguez, Pamela,29065777.340.000.000.00777.34
Zhao, Kelvin,251357.280.000.000.007.28
Ramos, Stacy, D,1826185.960.000.000.0085.96
Munoz, Shannon, S,2912249.970.000.000.0049.97
Blanco, Orlando,225753018.330.000.002443.35574.98
Chapman, Jodi, L,229663917.540.000.002181.561735.98
Shen, Michele,27985539.990.000.000.00539.99
Nath, Bethany,16177133.340.000.000.00133.34
Xu, Crystal, E,157544416.380.000.002071.422344.96
Foster, Lucas,135194492.450.000.004492.450.00
Rubio, Pedro, E,230982745.330.000.002181.56563.77
Chander, Roger,252142149.910.000.001000.441149.47
King, Hailey, A,2821459.980.000.000.0059.98
Rana, Raymond,251152155.920.000.001000.441155.48
Liang, Gilbert,122423948.970.003374.990.00573.98
Ferrier, Jaime, P,2352875.970.000.000.0075.97
Jai, Calvin, S,229184.990.000.000.004.99
Martin, Tabitha,2526923.780.000.000.0023.78
Dominguez, Ebony, R,17350127.470.000.0034.9992.48
She, Corey, T,212144659.900.002181.560.002478.34
Diaz, Felicia, J,1502629.980.000.000.0029.98
Harrison, Colleen, L,202196044.590.003578.270.002466.32
Serrano, Mallory, E,267511903.480.000.00782.991120.49
Sanz, Larry,14067114.960.000.000.00114.96
Smith, Andre,2117442.280.000.000.0042.28
Li, Cara,275871145.480.000.000.001145.48
Morris, Megan,2364164.470.000.000.0064.47
Romero, Jacquelyn,2581539.980.000.0039.980.00
Huang, Micah,251307.280.000.000.007.28

Generated 2024-11-14 16:56:40.329 UTC