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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Rodriguez, Bobby,157524408.690.000.002071.422337.27
Hernandez, Erika,161602644.070.000.002049.10594.97
Kovar, Tabitha,158332611.410.000.002071.42539.99
Alonso, Diana, L,245903911.530.000.002181.561729.97
Zhu, Sandra, V,157324376.400.000.002071.422304.98
Anderson, Victoria,157994423.380.000.002071.422351.96
Jones, Emily,166595873.263578.270.000.002294.99
Ms., Sherwood, Irma, J.,245984228.310.000.002443.351784.96
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
Yang, Stacey,142155665.890.000.002049.103616.79
Watson, Adrian, K,13641144.740.000.00117.4627.28
Yuan, Kelsey, D,1303494.710.000.000.0094.71
Morris, Megan,2364164.470.000.000.0064.47
Malhotra, Joel, E,1634358.250.000.000.0058.25
Stone, Keith,1733140.960.000.000.0040.96
Sanchez, Abby, J,199666021.620.003578.270.002443.35
Wang, Autumn,130495647.220.000.002071.423575.80
Lee, David, J,221994693.880.000.002181.562512.32
Vance, Henry,27986553.970.000.000.00553.97
Sanz, Lawrence, M,140306905.470.000.002071.424834.05
Kapoor, Jarrod,2893015.230.000.000.0015.23
Huang, Eugene, L,110016383.883374.990.002419.93588.96
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
Gomez, Danny, V,166365932.743578.270.000.002354.47
Martinez, Roy, J,1396977.270.000.000.0077.27
Pal, Dustin,265881938.470.000.00782.991155.48
Lal, Nina, L,142635647.930.000.002049.103598.83
Gomez, Adrienne,119208156.320.003374.990.004781.33
Xu, Alison,14227114.960.000.0049.9964.97
Madan, Erick, W,1421282.260.000.000.0082.26
Raji, Brendan,131036842.600.000.002049.104793.50
He, Aimee, A,110938180.000.003399.992360.952419.06
Alonso, Stacy,28315556.930.000.000.00556.93
Ashe, Marshall,2893293.970.000.000.0093.97
Green, Jonathan, A,173324480.733578.270.000.00902.46
Wu, Shannon, F,152682840.910.000.002071.42769.49
Gao, Bianca, C,131125717.890.000.002049.103668.79
Munoz, Meredith,139575645.240.000.002071.423573.82
Martin, Pedro, B,281031214.850.000.000.001214.85
Torres, Alfredo,2768574.980.000.000.0074.98
Diaz, Jill, F,229363946.520.000.002181.561764.96
Gonzales, Hunter,265701957.470.000.00782.991174.48
Chande, Melvin, R,114608137.520.003399.992294.992442.54
Perez, Arthur, L,165264758.243578.270.000.001179.97
Xu, Tony, L,225762721.550.000.002181.56539.99
Andersen, Drew, K,224123018.330.000.002443.35574.98
Rodriguez, Kristi,143453639.920.000.002049.101590.82
Rana, Stefanie, K,196165279.260.003578.270.001700.99
Andersen, Brendan,151215202.730.000.002071.423131.31
Wang, Curtis, A,131085718.660.000.002071.423647.24
Ramos, Roberto, M,13159208.180.000.000.00208.18
Liu, Warren,150143860.870.000.002071.421789.45
Hayes, Alexis,13048190.230.000.000.00190.23
Chande, Franklin, L,2023291.950.000.000.0091.95
Wang, Roger, P,246053627.810.000.003627.810.00
Lin, Dennis,161694404.080.000.002049.102354.98
Rai, Tonya,252432155.920.000.001000.441155.48
Muñoz, Alberto, J,13008125.510.000.000.00125.51
Nath, Keith,1961761.750.000.000.0061.75
Dominguez, Roy, C,2918923.970.000.000.0023.97
Rai, Karl, M,252731898.07699.100.000.001198.97
Becker, Kelsey, G,119688079.050.003399.992294.992384.07
Vance, Monica, G,123388265.000.003374.990.004890.01
Holt, Alisha,2835013.980.000.000.0013.98
Chande, Mindy, V,274721345.950.000.00782.99562.96
Dominguez, Raquel, A,274701371.950.000.00782.99588.96
Patel, Abby,160293807.400.000.002071.421735.98
Rai, Melvin, J,246043681.800.000.003681.800.00
Zeng, Warren, R,244773302.050.000.002181.561120.49
Campbell, Jason, J,136256962.140.000.002049.104913.04
Lin, Jaclyn,2872139.980.000.000.0039.98
Cai, Trisha,1826564.980.000.000.0064.98
Hu, Alejandro,13125138.540.000.000.00138.54
West, Colleen, C,131286817.140.000.002049.104768.04
Taylor, Ashley, E,18215150.970.000.000.00150.97
Anand, Ricardo,2138369.990.000.000.0069.99
Liang, Brittney, R,261826.280.000.000.006.28
Flores, Alexandra, C,261651957.470.000.00782.991174.48
Vance, Jillian, D,15230148.980.000.000.00148.98
Sun, Lacey, L,1513181.260.000.000.0081.26
Alvarez, Kari, C,111088124.040.003374.992329.992419.06
Deng, April,111178184.990.003399.992365.942419.06
Huang, Dawn, E,119434734.290.003374.99539.99819.31
Andersen, Karl, M,231053361.530.000.003361.530.00
Coleman, Ethan, G,166936060.503578.270.002482.230.00
Sanchez, Joel,184685333.250.003578.271754.980.00
Huang, Jorge,1729186.270.000.0053.9932.28
Russell, Jonathan,1889674.980.000.000.0074.98
Prasad, Gerald, B,1203581.240.000.0064.9716.27
Hu, Omar, S,289542393.060.000.000.002393.06
Ortega, Gloria, R,195586029.570.003578.270.002451.30
Raje, Lacey, T,123586787.760.002071.420.004716.34
Andersen, Lacey,1960094.460.000.000.0094.46
Raman, Edgar, A,2759664.470.000.000.0064.47
Sanchez, Michele,2354312.940.000.000.0012.94
Huang, Lacey, J,1195163.520.000.000.0063.52
Sai, Regina,211924229.320.002443.350.001785.97
Yang, Curtis,111108093.030.003399.992294.992398.05
Ye, Brent,2892229.480.000.000.0029.48
Raje, Wayne, A,2137274.960.000.000.0074.96
Roberts, Jennifer,114478078.020.003374.992309.972393.06
Beck, Ashlee, L,266661336.960.000.001336.960.00
Zhu, Christy,110038139.293399.990.002318.962420.34
Raje, Terrence,182466030.610.003578.272452.340.00
Wood, Sydney,233103333.320.000.003333.320.00
Navarro, Melinda,114548089.040.003374.992294.992419.06
Shen, Shawn,192704127.250.003578.27548.980.00
Lu, Roger, F,197634153.250.003578.27574.980.00
Chandra, Ann,182096056.610.003578.272478.340.00
Suri, Ronald,182146093.200.003578.272514.930.00
Saunders, Micheal,175134260.240.003578.27681.970.00
Alonso, Danny, S,182176056.610.003578.272478.340.00
Chande, Lindsay,182446021.620.003578.272443.350.00
Nath, Cassie,246062155.920.001000.441155.480.00
Lin, Bianca,111078171.010.003374.992376.962419.06
Rubio, Erika, A,114528183.040.003374.992414.992393.06
Malhotra, Tina, C,27584599.470.000.000.00599.47
Romero, Jessie,250302180.410.000.001000.441179.97
Lin, Jeffery, J,2734778.980.000.000.0078.98
Alonso, Meghan, A,244573356.040.000.002181.561174.48
Gao, Todd, M,110618129.023374.990.002369.962384.07
Anand, Jodi,2612921.490.000.000.0021.49
Sun, Dennis, K,244814179.330.000.002443.351735.98
Simmons, Jordyn,164945961.203578.270.000.002382.93
Ye, Krystal, M,269231322.980.000.00782.99539.99
Johnson, Brianna, J,1731938.980.000.000.0038.98
Suri, Toni,184644698.760.003578.270.001120.49
Cook, Sydney, D,131185669.900.000.002049.103620.80
Sara, Edgar, A,111048173.030.003399.992334.982438.06
Liang, Vincent,204024.990.000.000.004.99
Vazquez, Diane, D,11987279.230.000.000.00279.23
Ruiz, Carolyn, M,27863565.470.000.000.00565.47
Xu, Alejandro, R,265851903.480.000.00782.991120.49
Yang, Jamie, S,184654752.750.003578.270.001174.48
Butler, Jason,175104369.740.003578.270.00791.47
Lin, Heather, L,1571863.970.000.000.0063.97
Sun, Louis, E,1618283.970.000.000.0083.97
Patel, Gerald,230954.990.000.000.004.99
Bailey, Melissa, C,1957282.250.000.000.0082.25
Alonso, Gloria, S,199646056.610.003578.270.002478.34
Gutierrez, Jonathon, R,165294752.753578.270.000.001174.48
Gonzalez, Carla, J,183366145.070.003578.270.002566.80
Liu, Kelli, A,244804175.610.000.002443.351732.26
Munoz, Theresa, M,139536840.750.000.002071.424769.33
Wu, Glenn, R,29343553.970.000.000.00553.97
He, Karen, C,27861539.990.000.000.00539.99
Sullivan, Ruth,277231155.480.000.000.001155.48
Rodriguez, Rachael, M,119444776.270.003374.99609.96791.32
Lopez, Deanna, L,251192148.210.000.001000.441147.77
Zhou, Clayton,273481382.460.000.00782.99599.47
Yang, Louis, J,2301312.940.000.000.0012.94
Cooper, Katherine, R,14314122.950.000.000.00122.95
Martin, Hector,27860615.470.000.000.00615.47
Alonso, Joanna, M,27862548.980.000.000.00548.98
Alonso, Armando, M,136476793.150.000.002049.104744.05
Subram, Ivan, A,2614778.980.000.000.0078.98
Zhou, Gilbert,244753945.530.000.002181.561763.97
Madan, Brandy, A,276871183.470.000.000.001183.47
Blanco, Lori, A,15735116.250.000.000.00116.25
Munoz, Carolyn, L,173156030.613578.270.000.002452.34
She, Ashlee,28319556.930.000.000.00556.93
Diaz, Cheryl, A,110928110.020.003374.992341.972393.06
Martinez, Virginia,1313662.270.000.000.0062.27
Chen, Randy,13004190.270.000.000.00190.27
Nath, Tommy, B,289377.280.000.000.007.28
Ma, Omar, I,1523239.970.000.000.0039.97
Jiménez, Briana, T,28118588.960.000.000.00588.96
Vazquez, Joan, B,16332147.230.000.000.00147.23
Rana, Evelyn, D,18262142.450.000.000.00142.45
Alvarez, Albert, R,166245938.253578.270.000.002359.98
Goldberg, Mindy,161594411.650.000.002071.422340.23
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
Townsend, Larry, D,111344911.830.003399.990.001511.84
Patel, Deanna, H,273541322.980.000.00782.99539.99
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
Rana, Joe, D,119168178.510.003374.992405.472398.05
West, Nathan,2437067.930.000.000.0067.93
Navarro, Theresa,206276044.590.003578.270.002466.32
Fernandez, Holly, M,126756812.770.002071.420.004741.35
Mr., Solanki, Ajay,18295144.270.000.000.00144.27
Vazquez, Marvin, K,2195335.000.000.000.0035.00
Dominguez, Kellie, E,1724486.270.000.000.0086.27
Deng, Grant, C,1662581.810.000.000.0081.81
Prasad, Ross,289632398.050.000.000.002398.05
Gomez, Marvin, C,28479831.330.000.000.00831.33
Li, Luis, K,2025159.470.000.000.0059.47
Sharma, Corey, M,17495119.910.000.000.00119.91
Sullivan, Henry, L,2060323.780.000.000.0023.78
Chander, Carl,14315109.710.000.000.00109.71
Carson, Terrence,113565069.290.003374.990.001694.30
Adams, Isabella,1571539.970.000.000.0039.97
Chandra, Cynthia,220004663.790.000.002181.562482.23
Guo, Ernest,257171274.080.00699.100.00574.98
Lal, Dustin, A,164844175.533578.270.000.00597.26
Liu, Glenn,188994118.260.003578.27539.990.00
Patterson, Antonio, G,119638068.030.003374.992294.992398.05
Rai, Clarence, D,110186533.283399.990.002341.97791.32
Kapoor, Brett, L,2214769.990.000.000.0069.99
Xu, Tonya,1732480.940.000.000.0080.94
Gao, Stacey,166624355.713578.270.00777.440.00
Garcia, Ruth,206236093.200.003578.270.002514.93
Yang, Jon, V,110008248.993399.990.002341.972507.03
Gomez, Felicia, J,182196038.560.003578.272460.290.00
Suarez, Carolyn, B,182226044.590.003578.272466.320.00
Chande, Jaclyn, S,186985314.250.003578.271735.980.00
Rogers, Seth, R,14318138.450.000.0063.9774.48
Long, Isabelle, W,231043490.030.000.003490.030.00
Fernandez, Kristopher, O,192714153.250.003578.27574.980.00
Kumar, Lacey,139606871.740.000.002071.424800.32
Gonzalez, Phillip, N,182076089.590.003578.272511.320.00
Malhotra, Stanley, H,114538176.980.003374.992382.932419.06
Mehta, Tina, C,114448136.020.003374.992376.962384.07
Pal, Christine, I,182426121.710.003578.272543.440.00
Zhu, Wesley, L,1962423.780.000.000.0023.78
Raman, Cassandra,2871867.970.000.000.0067.97
Shen, Alison, A,1661471.160.000.000.0071.16
Alvarez, Adrienne, L,17067113.960.000.000.00113.96
Alvarez, Marc, B,1822145.950.000.000.0045.95
Sharma, Sharon, T,252941882.57699.100.000.001183.47
Vazquez, Kristine, M,177364742.740.003578.270.001164.47
Goel, Lacey, N,1870433.260.000.0030.972.29
Allen, Mary,212034633.900.002181.560.002452.34
Ye, Christy,142195744.220.000.002071.423672.80
Arthur, Regina, A,190896093.200.003578.270.002514.93
Andersen, Rafael, E,12691247.460.000.000.00247.46
Xie, Drew, A,20218104.690.000.000.00104.69
She, Eugene, L,209982806.510.002181.560.00624.95

Generated 2024-11-09 23:47:29.120 UTC