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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Cook, Faith,278712384.070.000.000.002384.07
Zhao, Bianca,139716772.130.000.002049.104723.03
Van, Brett,26166128.970.000.000.00128.97
Hayes, Edward,1579634.990.000.000.0034.99
Russell, Alexis, L,13634234.930.000.000.00234.93
Romero, Marie,204244132.240.003578.27553.970.00
Ross, Connor, J,208164228.720.003578.27650.450.00
Nara, Edwin, R,110978099.030.003374.992304.982419.06
Zheng, Alan,110505007.303374.990.00854.97777.34
Lin, Damien, L,234143391.030.000.003391.030.00
Watson, Adrian, K,13641144.740.000.00117.4627.28
Pal, Christy, R,187395371.740.003578.271793.470.00
Diaz, Jacquelyn, K,187476089.590.003578.272511.320.00
Xie, Ricardo,187106098.580.003578.272520.310.00
Zheng, Vincent,184966121.710.003578.272543.440.00
Townsend, Larry, D,111344911.830.003399.990.001511.84
Patel, Deanna, H,273541322.980.000.00782.99539.99
Vazquez, Eddie, T,140125249.920.000.002049.103200.82
Chander, Damien,110808204.020.003374.992359.982469.05
Lopez, Kari,15235190.890.000.000.00190.89
Scott, Savannah, E,169294733.753578.270.000.001155.48
Kapoor, Ruben, D,111098245.010.003374.992476.962393.06
Taylor, Logan,1352259.980.000.000.0059.98
Suarez, Natasha,1467937.970.000.000.0037.97
Kumar, Cedric, B,228604663.790.000.002181.562482.23
Schmidt, Joe, M,229054624.910.000.002181.562443.35
Dominguez, Darren, M,139666842.120.000.002049.104793.02
Serrano, Neil, L,17076103.460.000.000.00103.46
Ms., Robinson, Rebecca, A.,1191341.260.000.000.0041.26
Chen, Jake,228454633.900.000.002181.562452.34
Chandra, Troy,2140674.980.000.0074.980.00
Nath, Tasha, J,184876021.620.003578.272443.350.00
Rodriguez, Jonathan, J,1304664.970.000.0029.9834.99
Zeng, Heather, E,1828772.160.000.0072.160.00
Lu, Curtis,110118133.043399.990.004733.050.00
Moore, Lucas, J,1502138.980.000.0029.998.99
Zhao, Laura, T,2458968.970.000.0068.970.00
Diaz, Danny, C,1819030.970.000.008.9921.98
Liu, Susan,187186035.600.003578.272457.330.00
Liu, Trisha, V,202145304.250.003578.270.001725.98
Arun, Cory, O,165274752.753578.270.000.001174.48
Zhou, Jon, L,110608153.023399.990.002319.992433.04
Ruiz, Adrienne,1352367.260.000.000.0067.26
Raji, Willie, T,110708165.550.003399.992345.222420.34
Munoz, Teresa, R,277121174.480.000.000.001174.48
Collins, Jennifer,113644921.820.003374.990.001546.83
Ye, Gilbert,29344548.980.000.000.00548.98
Ashe, Ebony, E,166125898.263578.270.000.002319.99
Zheng, Jenny, R,119474747.300.003374.99629.96742.35
Lopez, Mason, E,2292321.980.000.000.0021.98
Malhotra, Terrance, E,20223187.380.000.000.00187.38
She, Jessie, A,136506768.140.000.002049.104719.04
Mehta, Erick, E,1412361.580.000.000.0061.58
Sutton, Cassie, S,16613129.350.000.000.00129.35
West, James, M,1514890.750.000.000.0090.75
Patterson, Ashley, R,187366035.600.003578.270.002457.33
Nath, Dawn, L,117598054.050.003374.990.004679.06
Raji, Katrina, M,165174698.763578.270.000.001120.49
Prasad, Darren,1237299.030.000.000.0099.03
Gonzales, Victoria,117518215.020.003399.990.004815.03
Parker, Gabriel,1960683.970.000.000.0083.97
Malhotra, Arthur, E,2526725.480.000.000.0025.48
Ye, Willie,2296358.980.000.000.0058.98
Romero, Erika,199586056.510.003578.270.002478.24
Patel, Kaitlin, L,1661595.840.000.000.0095.84
Dominguez, Gerald, E,2063171.960.000.000.0071.96
Chen, Claudia, R,1662764.880.000.0029.9934.89
Kumar, Deborah, K,173086021.623578.270.000.002443.35
Lin, Sandra, A,250522155.920.000.001000.441155.48
Martinez, Ethan, C,202605314.250.003578.270.001735.98
Ramos, Sabrina, L,29082742.350.000.000.00742.35
Deng, Priscilla, M,251272174.920.000.001000.441174.48
Cook, Kaylee,119048214.500.003399.990.004814.51
Vazquez, Byron,1112242.930.000.007.9534.98
Sun, Leah,177344698.760.003578.270.001120.49
Andersen, Brendan,151215202.730.000.002071.423131.31
She, Jerry, C,142775196.740.000.002071.423125.32
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
Nara, Tara,211943911.530.002181.560.001729.97
Allen, Luis, C,260191957.470.00782.990.001174.48
Nara, Dale, L,212264659.800.002181.560.002478.24
Alvarez, Jessie,143245121.430.000.002049.103072.33
Raje, Casey, A,14686203.460.000.000.00203.46
Pal, Sheena, D,211973917.540.002181.560.001735.98
Flores, Brianna,27706553.970.000.000.00553.97
Anand, Chad,244843563.840.000.002443.351120.49
Hill, Luis,275001371.950.000.00782.99588.96
She, Ricardo, A,1423378.970.000.000.0078.97
Rai, Johnny, A,131356773.140.000.002049.104724.04
Ruiz, Melody,13621167.400.000.000.00167.40
Shen, Franklin,2714439.990.000.000.0039.99
Yuan, Kelsey, D,1303494.710.000.000.0094.71
Perez, Bryant, L,150423807.400.000.002071.421735.98
Lal, Nina, L,142635647.930.000.002049.103598.83
Alvarez, Larry, T,142355682.200.000.002071.423610.78
Prasad, Cory,197484.990.000.000.004.99
Xie, Nina,12997118.180.000.000.00118.18
Madan, Bruce, G,1820665.960.000.000.0065.96
Miller, Dalton, D,131306797.150.000.002049.104748.05
Rodriguez, Tammy,1523359.980.000.000.0059.98
Luo, Julie, M,2912169.970.000.000.0069.97
Washington, Marcus,283296.280.000.000.006.28
Goel, Ricardo, T,259611938.470.00782.990.001155.48
Hernandez, Jaime,241703018.330.000.002443.35574.98
Parker, Gabriella,213944657.510.002181.560.002475.95
Gill, Jay,2797583.470.000.000.0083.47
Tang, Christy, R,236603917.540.000.002181.561735.98
Raman, Geoffrey, P,154353801.390.000.002071.421729.97
Ms., Ryan, Justine, J.,230797.280.000.000.007.28
Prasad, Harold,1960868.450.000.000.0068.45
Deng, Deborah,233242730.540.000.002181.56548.98
Bryant, Lauren,11752137.870.000.0077.9659.91
Vazquez, Casey, S,131326880.620.000.002049.104831.52
Liu, Jenny,1616581.810.000.000.0081.81
Suarez, Erika,151205217.700.000.002049.103168.60
Romero, Desiree, J,1723932.280.000.000.0032.28
Lu, Todd, D,2426914.980.000.000.0014.98
Raman, Deanna, H,17053123.960.000.000.00123.96
Vazquez, Diane, D,11987279.230.000.000.00279.23
Suri, Phillip,179144698.760.003578.270.001120.49
Hernandez, Bruce,179194733.750.003578.270.001155.48
Walker, Seth, E,27689539.990.000.000.00539.99
Bradley, Victoria,29454742.350.000.000.00742.35
Flores, Antonio, D,142593630.930.000.002888.58742.35
Lin, Jorge,2759313.980.000.000.0013.98
Zhao, Jamie,1617972.160.000.000.0072.16
Yang, Tiffany, K,212154624.910.002181.560.002443.35
Lin, Heather, L,1571863.970.000.000.0063.97
Carlson, Marc, W,17501141.980.000.000.00141.98
Madan, Johnathan, D,136266909.090.000.002049.104859.99
Alexander, David,1578398.960.000.000.0098.96
Rodriguez, Ebony,1451782.970.000.000.0082.97
Raman, Jay, M,136186763.150.000.002049.104714.05
Diaz, Frank, F,29086805.330.000.000.00805.33
Shan, Gregory,206146035.600.003578.270.002457.33
Sun, Christy,252182184.900.000.001000.441184.46
Gonzalez, Clifford,245053302.050.000.002181.561120.49
She, Tamara, M,142245621.220.000.002049.103572.12
Johnson, Brianna, J,1731938.980.000.000.0038.98
Ramos, Roberto, M,13159208.180.000.000.00208.18
Serrano, Jésus, B,129915641.900.000.002049.103592.80
Torres, Jacquelyn, P,274646.280.000.000.006.28
Ma, Darryl, R,1559981.240.000.000.0081.24
Chow, Shannon,1844425.480.000.000.0025.48
Alvarez, Beth, M,2930514.980.000.000.0014.98
Alonso, Brandi,1706186.270.000.000.0086.27
Lal, Tommy,1451678.980.000.0024.9953.99
Ward, Katelyn,202586029.570.003578.270.002451.30
Sara, Troy, R,225832821.510.000.002181.56639.95
Sanz, Nelson, M,1405649.480.000.000.0049.48
Chandra, Harold, K,1723686.270.000.000.0086.27
Hernandez, Marvin, A,230777.280.000.000.007.28
Luo, Colin, L,2121039.990.000.000.0039.99
Chande, Carl,1893259.260.000.000.0059.26
Hernandez, Darren, A,187096098.540.003578.270.002520.27
Serrano, Dana, S,12678341.430.000.000.00341.43
Suri, Evelyn, A,2122356.980.000.000.0056.98
Goel, Alisha, C,267671331.970.000.00782.99548.98
She, Nichole, M,119098105.310.003374.990.004730.32
Chavez, Corey, R,1573159.980.000.000.0059.98
Rodriguez, Ruth, R,2617938.980.000.000.0038.98
Kapoor, Denise, M,187256044.590.003578.270.002466.32
Zhou, Ernest, P,157922645.400.000.002071.42573.98
Hernandez, Tabitha, L,1960325.480.000.000.0025.48
Sai, Harold,110266575.793399.990.000.003175.80
Chandra, Jarrod,241713006.310.000.002443.35562.96
Jai, Michele, E,212254732.860.002181.560.002551.30
Chow, Christy, M,126816784.130.002049.100.004735.03
Sara, Geoffrey,261881938.470.000.00782.991155.48
Lin, Jake,242482770.520.000.002181.56588.96
Mr., Schmidt, Irving, W,126696791.100.002049.100.004742.00
Patterson, Jordan,17238147.480.000.0053.9993.49
Ashe, Kathryn,1616880.110.000.0034.8945.22
Cai, Jessie, A,12249114.960.000.000.00114.96
Chavez, Jodi, A,189096035.600.003578.270.002457.33
Moyer, Meghan,2122074.980.000.000.0074.98
Huang, Omar, C,1423277.270.000.000.0077.27
Torres, Naomi, J,1406182.260.000.0032.2749.99
Gonzalez, Ivan, C,1962552.770.000.000.0052.77
Mehta, Patricia, K,291792393.060.000.000.002393.06
Raje, Alison, J,1234564.710.000.000.0064.71
Liang, Candice,2220842.280.000.000.0042.28
Arun, Marie, E,2284439.990.000.000.0039.99
Wang, Jaclyn, M,17063100.250.000.0037.2762.98
Moreno, Melody, R,11760274.920.000.000.00274.92
Lopez, Virginia, J,273381339.920.000.00782.99556.93
Ashe, Tara, J,190936035.600.003578.270.002457.33
Nara, Kelsey, A,249052195.910.000.001000.441195.47
She, Tonya, L,165214698.763578.270.000.001120.49
Martinez, Roy, J,1396977.270.000.000.0077.27
Wang, Lacey,241732771.520.000.002181.56589.96
Ms., Roy, Lisa, K.,214034895.690.002443.350.002452.34
Alvarez, Francis,215524624.910.002181.560.002443.35
Sanz, Francis,125772614.080.002049.100.00564.98
Andersen, Jaime,2526860.470.000.000.0060.47
Gomez, Carrie,229657.280.000.000.007.28
Ma, Jeffery,1826469.970.000.000.0069.97
Vazquez, Ruben, B,143015142.750.000.002071.423071.33
Zhou, Laura, D,126836801.450.002071.420.004730.03
Subram, Arthur, E,2735069.990.000.000.0069.99
Zhao, Kristen,169307.950.000.000.007.95
Ma, Autumn,209944191.720.003578.270.00613.45
Sharma, Alvin, M,195866056.610.003578.270.002478.34
Lu, Candice, I,2120474.980.000.000.0074.98
Sanz, Paula,2643069.990.000.000.0069.99
Zhu, Candice, S,212194696.490.002181.560.002514.93
Flores, Noah,172564362.740.003578.270.00784.47
Martin, Lance,2523639.980.000.000.0039.98
Suri, Patricia, E,154363772.410.000.002071.421700.99
Raman, Summer, C,259491882.570.00699.100.001183.47
Srini, Manuel,241682790.520.000.002181.56608.96
Suarez, Melinda,29181553.970.000.000.00553.97
Lal, Kate,215574886.700.002443.350.002443.35
Cai, Gilbert, J,1825698.960.000.0063.9734.99
Barnes, Taylor,142795137.710.000.002049.103088.61
Goel, Mario, J,123606750.480.002071.420.004679.06
Xie, Chad, A,26155128.970.000.000.00128.97
Hernandez, Logan,123506791.750.002071.420.004720.33
Shan, Jaime,2202056.970.000.000.0056.97
Prasad, Arthur,142755158.370.000.002800.442357.93
Kapoor, Dominic, J,1669967.580.000.000.0067.58
Xu, Brad,2615769.990.000.000.0069.99
Shen, Jaclyn, A,125752668.080.002049.100.00618.98
Zeng, Dawn, D,29455751.340.000.000.00751.34
Navarro, Jacquelyn,1546540.230.000.0029.9910.24
Pal, Mohamed, D,126986786.750.002071.420.004715.33
Rubio, Jessie, J,278682419.060.000.000.002419.06
Vance, Ruth, D,17302147.440.000.0058.9888.46
Fernandez, Michele, M,2488423.780.000.000.0023.78
Li, Lisa, J,246004.990.000.000.004.99
Yang, Darryl, K,215714624.910.002181.560.002443.35
Torres, Dwayne, R,172884426.240.003578.270.00847.97
Deng, Casey, C,1967442.280.000.000.0042.28
Barnes, Alexia, D,1523159.480.000.000.0059.48
Raji, Shawna, P,1396149.990.000.000.0049.99
Serrano, Lori,17066105.750.000.000.00105.75
Hernandez, Leslie, D,129906829.470.000.002071.424758.05
Liu, Jaclyn,129966808.150.000.002049.104759.05
Jones, Destiny,151714392.020.000.002049.102342.92
Suarez, Renee, L,127036891.120.000.002049.104842.02
Chander, Lindsay, R,1997249.700.000.000.0049.70
Raman, Meagan, J,151345151.710.000.002071.423080.29
Patel, Arthur, B,2667169.990.000.000.0069.99
Schmidt, Shane,179224821.720.003578.270.001243.45
King, Nathan,27719599.470.000.000.00599.47
Mehta, Cindy, A,219434624.910.000.002181.562443.35
Shen, Brendan, L,143053652.200.000.002049.101603.10
She, Jeffery, M,2714942.280.000.000.0042.28

Generated 2024-11-10 03:04:53.761 UTC