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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
She, Ricardo, A,1423378.970.000.000.0078.97
Ashe, Katie, Z,2677069.990.000.000.0069.99
Sai, Regina,211924229.320.002443.350.001785.97
Jimenez, Neil,22151133.490.000.000.00133.49
Suarez, Alberto, G,1871953.990.000.000.0053.99
Sai, Cassandra, R,28110845.310.000.00845.310.00
Malhotra, Joel, E,1634358.250.000.000.0058.25
Yuan, Mitchell,267441938.470.000.00782.991155.48
Serrano, Alberto, L,158004399.080.000.002049.102349.98
Deng, Johnny,2140935.000.000.000.0035.00
Sanchez, Candace, L,215674973.280.002443.350.002529.93
Kumar, Tonya, A,229344173.320.000.002443.351729.97
Li, Marshall,126876805.470.002071.420.004734.05
Suarez, Danny,209954127.250.003578.270.00548.98
Kapoor, Denise, M,187256044.590.003578.270.002466.32
Yuan, Cassie, J,2445360.470.000.000.0060.47
Shen, Karla, E,22925134.930.000.000.00134.93
Suarez, Nelson,273551383.450.000.00782.99600.46
Kovar, Mayra, J,173124471.743578.270.000.00893.47
Alan, Bob, A,273661322.980.000.00782.99539.99
Jai, Tommy, C,150272853.570.000.002049.10804.47
Zhu, Roger, J,280981249.840.000.000.001249.84
Smith, Christian, L,14313222.440.000.000.00222.44
Young, Morgan, L,123426838.120.002049.100.004789.02
Sharma, Carl,2137539.980.000.0039.980.00
Sanchez, Olivia, J,14278177.460.000.000.00177.46
Blanco, Robyn, R,241793052.310.000.002443.35608.96
Xu, Clayton,184886056.610.003578.272478.340.00
Lal, Devon, L,1523766.260.000.000.0066.26
Ward, Jessica,155874423.380.000.002071.422351.96
Liang, Glenn,219834144.340.000.002443.351700.99
Navarro, Kellie, I,218734661.500.000.002181.562479.94
Anderson, Victoria,157994423.380.000.002071.422351.96
Wang, Willie,2930423.970.000.000.0023.97
Cai, Shannon,2615678.980.000.000.0078.98
Rai, Grant, R,125732668.080.002049.100.00618.98
Moreno, Janet, L,1559259.980.000.0024.9934.99
Hill, Luis,275001371.950.000.00782.99588.96
Zhou, Jessie,206106021.620.003578.270.002443.35
King, Jesse, J,1466581.260.000.000.0081.26
Zeng, Brittney, K,13670178.450.000.0024.49153.96
Lin, Bianca,111078171.010.003374.992376.962419.06
Lin, Darryl, J,1503141.270.000.0032.288.99
Blanco, Mallory,219584696.490.000.002181.562514.93
She, Alicia, W,1725062.980.000.000.0062.98
Saunders, Jillian,2117839.990.000.000.0039.99
Zhu, Colleen,1725292.970.000.000.0092.97
Shen, Cedric,2220974.980.000.000.0074.98
Tang, Shawn,258321850.860.00699.100.001151.76
Zeng, Amy,242422756.540.000.002181.56574.98
Hernandez, Mallory,29091756.330.000.000.00756.33
Tang, Terrence, R,17303123.450.000.000.00123.45
Ramos, Alfredo,204566029.570.003578.270.002451.30
Zhang, Jenny, H,246092120.930.001000.441120.490.00
Serrano, Diane, E,1485787.970.000.0078.988.99
Rai, Tracy, K,170794417.750.003578.270.00839.48
Gill, Lee, L,276941184.460.000.000.001184.46
Yang, Connor,177354752.750.003578.270.001174.48
Luo, Raul, Q,201544153.250.003578.27574.980.00
Yuan, Jon,259371299.560.00699.100.00600.46
Gonzalez, Carolyn, H,224072756.540.000.002181.56574.98
Johnston, Joanna, L,1729663.970.000.000.0063.97
Lin, Edwin,197664167.230.003578.27588.960.00
Sara, Carmen, W,1258283.970.000.000.0083.97
Ramos, Adrienne, L,282167.280.000.007.280.00
Navarro, Bruce, D,173536035.600.003578.270.002457.33
Cai, Willie, S,259601957.470.00782.990.001174.48
Gutierrez, Francis,2524558.980.000.000.0058.98
Blanco, Jimmy, V,14013138.450.000.000.00138.45
Gill, Erika, A,182024143.260.003578.270.00564.99
Serrano, Gloria, G,215564930.680.002443.350.002487.33
Ye, Valerie, C,289482419.060.000.002419.060.00
Chander, Alejandro, M,2445575.470.000.000.0075.47
Price, Isabella, L,172784382.750.003578.270.00804.48
Wang, Jaclyn, M,17063100.250.000.0037.2762.98
Liang, Damien, M,2215069.990.000.0069.990.00
Ramos, Juan,136336803.140.000.002049.104754.04
Butler, Carson, T,12672381.970.000.000.00381.97
Rubio, Kathleen, A,208204143.740.003578.27565.470.00
Sanz, Lance,225732721.550.000.002181.56539.99
Andersen, Jenny,202596029.570.003578.270.002451.30
McDonald, Kaitlin,184936029.570.003578.272451.300.00
Zheng, Omar, C,14522126.950.000.000.00126.95
Lopez, Ross,1844360.470.000.000.0060.47
Price, Megan,249072183.910.000.001000.441183.47
Muñoz, Pedro, A,234333882.550.000.002181.561700.99
Serrano, Randall,27973539.990.000.000.00539.99
Sharma, Bonnie, R,255621239.090.00699.100.00539.99
Liu, Micah, J,152204384.080.000.002049.102334.98
Raje, Bonnie,206296060.500.003578.270.002482.23
Malhotra, Arthur, E,2526725.480.000.000.0025.48
Patel, Douglas,179274726.040.003578.270.001147.77
Ma, Cedric, W,11094157.930.000.000.00157.93
Garcia, Tina,1723183.980.000.000.0083.98
Gill, Kristy,13669102.430.000.000.00102.43
Reed, Riley, A,201574118.260.003578.27539.990.00
Romero, Walter, A,250201549.420.000.001000.44548.98
Subram, Cassandra, M,1661876.150.000.000.0076.15
Sun, Franklin,196155279.260.003578.270.001700.99
Blanco, Rodney, A,201584153.250.003578.27574.980.00
Lin, Kelli, A,2139229.990.000.000.0029.99
Zhao, Micah,187086056.510.003578.272478.240.00
Gao, Wesley,123466864.460.002071.420.004793.04
Hernandez, Julio, J,2307815.230.000.000.0015.23
Ramos, Sabrina, L,29082742.350.000.000.00742.35
Blanco, Krista, L,2758039.980.000.000.0039.98
Chapman, Patricia,120377107.100.003374.990.003732.11
Zhou, Jon, L,110608153.023399.990.002319.992433.04
Zheng, Curtis, S,236454198.330.000.002443.351754.98
Lopez, Manuel, M,140505650.240.000.003295.262354.98
Black, Wayne, E,250567.280.000.000.007.28
Mr., Shakespear, Paul, J.,173264467.760.003578.270.00889.49
Suri, Cesar,175124170.540.003578.27592.270.00
Kumar, Louis, A,182034172.250.003578.270.00593.98
Raji, Corey,250587.280.000.000.007.28
Chander, Omar, W,172414382.750.003578.270.00804.48
Gray, Brooke, P,2675678.980.000.000.0078.98
Srini, Jay, M,1832662.980.000.000.0062.98
Sanz, Nelson, M,1405649.480.000.000.0049.48
Ortega, Linda, C,117568078.020.003374.990.004703.03
Torres, Marc,117658143.030.003374.992294.992473.05
Raje, Derek,125742626.390.002071.420.00554.97
Torres, Bailey,1825930.970.000.008.9921.98
Zheng, Christy,170694426.743578.270.000.00848.47
Bell, Stephanie, A,273701322.980.000.00782.99539.99
Lin, Margaret, C,1830687.770.000.000.0087.77
Rana, Cory, E,1617343.210.000.0031.2711.94
Raji, Kate, L,119038108.040.003374.992294.992438.06
Suarez, Gina,2024869.970.000.000.0069.97
Saunders, Ruben, G,27983539.990.000.000.00539.99
Lopez, Francisco, L,1871424.270.000.0021.982.29
Xu, Kelvin,18305160.550.000.000.00160.55
Ortega, Monique, C,123556818.110.002049.100.004769.01
Sanz, Jésus,29313539.990.000.000.00539.99
Sai, Jay, A,234274.990.000.000.004.99
Clark, Madison, A,140625647.920.000.003272.942374.98
Sanz, Paula,2643069.990.000.000.0069.99
Zhou, Brent,1543432.280.000.000.0032.28
Lin, Dawn, N,15805127.470.000.000.00127.47
Sara, Adriana, M,15146161.940.000.000.00161.94
Munoz, Theresa, M,139536840.750.000.002071.424769.33
Srini, Beth, A,259136.280.000.000.006.28
_SUM9051988.22546835.112386860.532383298.863734993.72
Martin, Roy,2206569.990.000.0069.990.00
Chander, Russell, E,29067539.990.000.000.00539.99
Chander, Lindsay, R,1997249.700.000.000.0049.70
Guo, Micah, M,241632756.540.000.002181.56574.98
Ashe, Joanna, F,209972744.520.002181.560.00562.96
She, Jaime, D,28482777.340.000.000.00777.34
Andersen, Willie, M,2797064.470.000.000.0064.47
Bailey, Melissa, C,1957282.250.000.000.0082.25
Martin, Arthur, L,2894349.970.000.000.0049.97
Zhang, Dawn, A,1422282.260.000.000.0082.26
Zheng, Edwin, J,142165653.920.000.002049.103604.82
Yang, Jon, V,110008248.993399.990.002341.972507.03
Alan, Jamie, S,2122442.280.000.000.0042.28
Madan, Brandy, A,276871183.470.000.000.001183.47
Luo, Jerry, M,245864144.340.000.002443.351700.99
Gill, Roy,29465791.320.000.000.00791.32
Torres, Michele, A,161764404.080.000.002049.102354.98
Serrano, Lori,17066105.750.000.000.00105.75
Gonzalez, Eric, C,1909278.260.000.000.0078.26
Suarez, Carolyn, B,182226044.590.003578.272466.320.00
Suarez, Dana, M,235413337.040.000.002181.561155.48
Kumar, Katie, P,123416840.620.002049.100.004791.52
Zheng, Dawn, F,1957983.980.000.000.0083.98
Shan, Carl, D,249192212.890.000.001000.441212.45
Rana, Joe, D,119168178.510.003374.992405.472398.05
Kumar, Kenneth,114728165.820.003399.990.004765.83
Morris, Isaac, G,264391938.470.000.00782.991155.48
Shan, Yolanda,127026911.100.000.002049.104862.00
Shan, Dylan,1967758.980.000.000.0058.98
Andersen, Deborah,19610118.940.000.000.00118.94
Alonso, Billy, M,2285239.990.000.000.0039.99
Lopez, Patricia,2830529.480.000.000.0029.48
Ye, Willie,2296358.980.000.000.0058.98
Chande, Casey,2614978.980.000.000.0078.98
Perez, Whitney,1661997.580.000.0067.5929.99
Chandra, Jarrod,241713006.310.000.002443.35562.96
Perez, Carmen, C,131396854.450.000.002071.424783.03
Goel, Chad,2821939.980.000.000.0039.98
Gill, Melinda, G,111518087.310.003374.990.004712.32
Gonzalez, Ruth,126936820.470.002071.420.004749.05
Vance, George, R,1203866.760.000.000.0066.76
Stone, Christine, D,259481819.590.00699.100.001120.49
Liang, Eugene,1397277.270.000.000.0077.27
Perez, Brett, M,28313647.940.000.000.00647.94
Lu, Trisha,255551277.56699.100.000.00578.46
Malhotra, Marco, L,29459805.330.000.000.00805.33
Gonzalez, Tina,196535314.250.003578.270.001735.98
Shan, Derek, R,197826089.590.003578.270.002511.32
Pal, Derek,2459158.980.000.000.0058.98
Deng, Grant, C,1662581.810.000.000.0081.81
Chande, Carl,1893259.260.000.000.0059.26
Li, Glenn, A,292952384.070.000.000.002384.07
Vance, Monica, G,123388265.000.003374.990.004890.01
Powell, Adam,234233936.540.000.002181.561754.98
Sanz, Lawrence, M,140306905.470.000.002071.424834.05
Mehta, Michele,26143123.980.000.000.00123.98
Alvarez, Lori, C,266621938.470.000.00782.991155.48
Madan, Kristopher, A,252387.280.000.000.007.28
Malhotra, Cory, E,179234752.750.003578.270.001174.48
She, Kelli, J,248892269.910.000.002269.910.00
Jimenez, Julio,240052756.540.000.002181.56574.98
He, Louis, E,212114900.680.002443.350.002457.33
Lopez, Joe, L,27512539.990.000.000.00539.99
Becker, Latoya, W,1733030.970.000.000.0030.97
Sun, Mandy, L,1669478.200.000.0039.2238.98
Malhotra, Terrance, E,20223187.380.000.000.00187.38
Subram, Douglas,273521357.970.000.00782.99574.98
Andersen, Shawna, C,195566035.600.003578.270.002457.33
Garcia, Ruth,206236093.200.003578.270.002514.93
Ruiz, Leslie, J,260327.280.000.007.280.00
Sun, Micah,248872218.900.001000.441218.460.00
Sanchez, Levi, A,27745617.470.000.00617.470.00
Luo, Colleen, E,152082951.560.000.002049.10902.46
Andersen, Ashlee, J,11059116.930.000.00116.930.00
Blue, Richard,12006144.740.000.000.00144.74
Sara, Donald, M,251142155.920.000.001000.441155.48
Dominguez, Philip,15730122.960.000.000.00122.96
Rana, Stefanie, K,196165279.260.003578.270.001700.99
Perez, Kevin, M,255651239.090.00699.100.00539.99
Dominguez, Robin,166854183.233578.270.000.00604.96
Malhotra, Ruben, M,1707490.250.000.0058.9831.27
Rodriguez, Wyatt, D,212184661.500.002181.560.002479.94
Goldstein, Dustin,123378137.010.003399.990.004737.02
Sharma, Corey, M,17495119.910.000.000.00119.91
Jenkins, Noah, A,2437913.980.000.000.0013.98
Sara, Jarrod,206266038.560.003578.270.002460.29
Yang, Clarence, D,251212155.920.000.001000.441155.48
Watson, Maria,172294471.743578.270.000.00893.47
Kovár, Whitney,131055585.450.000.002049.103536.35
Rubio, Natasha, K,13627214.250.000.0066.97147.28
Gomez, Marvin, C,28479831.330.000.000.00831.33
Ruiz, Shannon,208224134.530.003578.27556.260.00
Zheng, Jeffery, W,150303786.390.000.002071.421714.97
Allen, Logan,1581281.250.000.000.0081.25
Alonso, Natasha, L,2500914.980.000.000.0014.98
Schmidt, Kaitlin,13628191.250.000.000.00191.25
Ross, Mya, E,277151147.770.000.000.001147.77
Raji, Maurice, C,2061974.980.000.000.0074.98
Sutton, Cassie, S,16613129.350.000.000.00129.35
Sanz, Arthur,27688166.280.000.00166.280.00
Li, Lisa, J,246004.990.000.000.004.99
Martinez, Harold, J,2060493.490.000.000.0093.49
Townsend, Darren,184675279.260.003578.271700.990.00
Prasad, Candace, S,2214869.990.000.000.0069.99
Yuan, Carl, P,241603046.840.000.002443.35603.49
Gonzales, Alexis,2352121.980.000.000.0021.98
Zhang, Willie, T,16023166.890.000.000.00166.89

Generated 2024-11-10 06:13:05.371 UTC