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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Lopez, Manuel, M,140505650.240.000.003295.262354.98
Ramirez, Mason, K,251072143.900.000.001000.441143.46
Hernandez, Melinda,16174140.450.000.0092.4847.97
Nath, Cassie,246062155.920.001000.441155.480.00
Ramos, Danny,231214144.340.000.002443.351700.99
Madan, Brenda,13043175.930.000.0088.9886.95
Ortega, Dwayne, C,246152155.920.001000.441155.480.00
Ruiz, Kari, L,12695192.970.000.00159.0033.97
Hernandez, Ross,1467781.260.000.000.0081.26
Sai, Francisco, W,187664752.750.003578.270.001174.48
Dominguez, Lee, R,245974009.500.000.002181.561827.94
Liang, Vincent,204024.990.000.000.004.99
Watson, Nathaniel, H,258261854.580.00699.100.001155.48
Morgan, Nathaniel, E,1662671.570.000.0036.5934.98
Zhao, Micah,187086056.510.003578.272478.240.00
Jai, Karla,18263126.940.000.0034.9991.95
Suarez, Pedro, A,246112219.420.001000.441218.980.00
Ramos, Jay, D,218824886.700.002443.350.002443.35
Lal, Darrell,1995325.480.000.000.0025.48
Garcia, Jermaine,2156642.280.000.0042.280.00
Lal, Alicia,157344426.410.000.002071.422354.99
Gomez, Armando, S,2117535.000.000.000.0035.00
Rana, Terrance, M,28134574.980.000.000.00574.98
Deng, Johnny,2140935.000.000.0035.000.00
Wang, Trisha, V,172594404.733578.270.000.00826.46
Navarro, Bruce, D,173536035.603578.270.000.002457.33
Guo, Autumn, A,1421386.260.000.0058.9827.28
Xu, Barbara,1407459.880.000.000.0059.88
Huang, Micah,251307.280.000.007.280.00
Ruiz, Adrienne,1352367.260.000.000.0067.26
Ruiz, Bruce, W,16171103.860.000.00103.860.00
Chander, Tonya,15794113.970.000.0088.9824.99
Shen, Michele,27985539.990.000.000.00539.99
Powell, Alexis, M,235313337.280.000.003337.280.00
Yuan, Alicia,252252129.920.000.001000.441129.48
Gonzalez, Carolyn, H,224072756.540.000.002181.56574.98
Martinez, Anna, J,129946855.440.002071.420.004784.02
Martinez, Jermaine, L,151704391.410.000.002071.422319.99
Navarro, Mathew, A,1967337.290.000.000.0037.29
Powell, Rachel,208184230.730.003578.27652.460.00
Guo, Lisa, S,1731478.960.000.000.0078.96
Cai, Jorge,220313896.530.002181.560.001714.97
Butler, Jose,29064815.810.000.000.00815.81
Sullivan, Summer, E,2118132.280.000.000.0032.28
Clark, Joshua, A,2613769.990.000.000.0069.99
Zhao, Jessie, R,110276591.573399.990.000.003191.58
He, Amy,224112770.520.000.002181.56588.96
Raji, Omar,156433807.400.000.002071.421735.98
Luo, Colleen, E,152082951.560.000.002049.10902.46
Chande, Ashlee, N,230967.280.000.007.280.00
Guo, Glenn, J,1871224.270.000.0021.982.29
Bell, Jessica,221784233.320.002443.350.001789.97
Madan, Marco,1889527.770.000.0027.770.00
Sai, Lydia, L,139685181.700.000.002862.742318.96
Kovár, Barry, A,215704705.480.002181.560.002523.92
Subram, Evelyn, S,212574144.340.002443.350.001700.99
Martin, Tabitha,2526923.780.000.000.0023.78
Pal, Arturo, P,293032419.060.000.000.002419.06
Arthur, Carla,1671091.260.000.000.0091.26
Raman, Edgar, A,2759664.470.000.0064.470.00
Carlson, Joanna,1559434.990.000.000.0034.99
Hernandez, Kellie, A,125862636.410.002071.420.00564.99
Andersen, Jodi,2676678.980.000.000.0078.98
Vazquez, Latasha,2195299.470.000.000.0099.47
Suri, Toni,184644698.760.003578.270.001120.49
Navarro, Leslie, E,243714193.820.000.002443.351750.47
Rodriguez, Wyatt, D,212184661.500.002181.560.002479.94
Raji, Brendan,131036842.600.000.002049.104793.50
Lopez, Heidi,110528131.323374.990.002337.272419.06
Patel, Bryant, L,27969599.470.000.000.00599.47
Lu, Warren, H,289257.280.000.000.007.28
Martinez, Terrance,257181274.080.00699.100.00574.98
Alvarez, Albert, R,166245938.253578.270.000.002359.98
Serrano, Danny,243813970.520.000.002181.561788.96
Zhao, Jamie,1617972.160.000.000.0072.16
Shan, Tasha,151924384.080.000.002049.102334.98
Ramos, Victor, D,242469.990.000.009.990.00
Subram, Joe,136316817.120.000.002049.104768.02
Jimenez, Felicia, L,110758068.033374.990.002294.992398.05
Sanz, Linda, P,2294512.940.000.0012.940.00
Blanco, Erika, L,1466990.250.000.000.0090.25
Serrano, Gerald, M,275914.990.000.000.004.99
Yang, Darryl, K,215714624.910.002181.560.002443.35
Liang, Alan, L,29063801.830.000.000.00801.83
She, Glenn, L,291179.990.000.000.009.99
Pal, Terry, H,2582439.980.000.000.0039.98
Malhotra, Geoffrey, W,1829824.270.000.000.0024.27
Martinez, Pamela, A,135294614.860.000.002071.422543.44
Gutierrez, Desiree,15216101.740.000.00101.740.00
Andersen, Willie, M,2797064.470.000.0064.470.00
Guo, Sandra,236643941.530.000.002181.561759.97
Lin, Jaclyn,2872139.980.000.000.0039.98
Torres, Carolyn,1526170.740.000.0053.4717.27
Ye, Martha,222004659.900.002181.560.002478.34
Cai, Autumn, O,26163123.980.000.00123.980.00
Lin, Kelvin, A,130756843.940.002071.422294.992477.53
Gutierrez, Darren, A,257141308.060.00699.100.00608.96
Huang, Colleen, S,213792992.330.002443.350.00548.98
Ramos, Kristy,1668266.580.000.000.0066.58
Subram, Cory, B,27599603.490.000.000.00603.49
Guo, Cedric, R,274871322.980.000.00782.99539.99
Rai, Michele, M,265671957.470.000.00782.991174.48
Chande, Raul, L,2117635.000.000.0035.000.00
Hernandez, Armando,219504900.680.002443.350.002457.33
Torres, Kristy, M,130352638.060.002049.100.00588.96
Raji, Maurice, C,2061974.980.000.000.0074.98
Sharma, Cedric, A,1406099.470.000.0049.9949.48
Chandra, Monica, H,1889874.980.000.0074.980.00
Hernandez, Erik, C,2199856.980.000.000.0056.98
Raje, Derek,125742626.390.002071.420.00554.97
Gonzalez, Phillip, N,182076089.590.003578.272511.320.00
Butler, Destiny,278652419.060.000.000.002419.06
Madan, Roy,157164467.060.000.002049.102417.96
Foster, Lucas,135194492.450.000.004492.450.00
Chande, Alvin, W,2489323.780.000.000.0023.78
Carlson, Alfredo,16178108.850.000.0038.8869.97
Lin, Dawn, N,15805127.470.000.000.00127.47
Blue, Richard,12006144.740.000.0092.9751.77
Jai, Calvin, S,229184.990.000.000.004.99
Zhang, Louis, K,202276054.220.003578.270.002475.95
Suri, Kaitlin, C,291902447.050.000.002447.050.00
Andersen, Gilbert, T,273531371.950.000.00782.99588.96
Zeng, Ernest, M,12992158.510.000.0036.27122.24
Rubio, Randall, M,172866029.573578.270.000.002451.30
Sara, Jarrod,206266038.560.003578.270.002460.29
Kumar, Gilbert, L,2814039.980.000.000.0039.98
Ramos, Stacy, D,1826185.960.000.000.0085.96
Moreno, Tanya,1113983.970.000.000.0083.97
Russell, Seth,251382120.930.000.001000.441120.49
Allen, Ian, A,160313750.090.000.002049.101700.99
Jai, Alison,236574.990.000.000.004.99
Raman, Patricia, T,167026021.623578.270.002443.350.00
Raji, Jaime, L,150373856.380.000.002071.421784.96
Pais, Wilson, C,130385581.260.002071.420.003509.84
Long, Julian,1203472.250.000.000.0072.25
Shan, Elijah, L,267951992.460.000.00782.991209.47
Shan, Warren,2197132.280.000.000.0032.28
Zeng, Marshall, M,209874132.240.003578.27553.970.00
Alexander, Alyssa, M,1728237.270.000.000.0037.27
Serrano, Hector, K,28308588.960.000.00588.960.00
Tang, Louis, A,1829239.250.000.000.0039.25
Evans, Mason,154393804.080.000.002049.101754.98
Saunders, Bobby, D,22205120.480.000.000.00120.48
Malhotra, Veronica, J,259221274.080.00699.100.00574.98
Martin, Diane,139586838.640.000.002049.104789.54
Zhou, Cedric,175144142.233578.270.00563.960.00
Liu, Erica, A,2156474.980.000.0074.980.00
Xu, Martha, C,163515873.263578.270.000.002294.99
Morris, Megan,2364164.470.000.000.0064.47
Thompson, Cameron, M,166205895.243578.270.000.002316.97
Alvarez, Stacy,119018248.010.003399.990.004848.02
Raje, Ashlee, E,166585873.263578.270.000.002294.99
Kumar, Yolanda, J,1819485.960.000.000.0085.96
Perez, Henry,267521917.460.000.00782.991134.47
Andersen, Carl, J,110578088.043374.990.002319.992393.06
Gutierrez, Meghan, E,260211917.460.00782.990.001134.47
Zhang, Jon,28111865.310.000.00865.310.00
Lewis, Justin, L,2830374.980.000.000.0074.98
Hu, Omar, S,289542393.060.000.002393.060.00
Howard, Jesse, D,242492756.540.000.002181.56574.98
Lin, Clarence,29069756.330.000.000.00756.33
Wu, Ernest, L,111478195.500.003374.992376.962443.55
Alvarez, Mathew, L,17494111.960.000.000.00111.96
Liu, Krystal, D,135264549.760.000.002071.422478.34
Jai, Brendan,26755123.980.000.000.00123.98
Liu, Christy,197846021.620.003578.270.002443.35
Gao, Gilbert,241653046.840.000.002443.35603.49
Nara, Katrina, Z,246082120.930.001000.441120.490.00
Martin, Alyssa,1958721.490.000.0021.490.00
He, Jon, L,142625652.540.000.002071.423581.12
Browning, Javier,231204144.340.000.002443.351700.99
Ruiz, Hector,275924.990.000.000.004.99
Andersen, Marshall, V,157864366.070.000.002049.102316.97
Ye, Gilbert,29344548.980.000.000.00548.98
Srini, Candace,154372.290.000.000.002.29
Martin, Jay,1959733.980.000.000.0033.98
Zhu, Colin,1997383.440.000.0022.9760.47
Diaz, Tyrone,13116230.250.000.0032.27197.98
Hernandez, Orlando, C,219514923.290.002443.350.002479.94
Rai, Karl, M,252731898.07699.100.000.001198.97
Wu, Margaret,289282473.050.000.002473.050.00
Suarez, Erika,151205217.700.000.002049.103168.60
Martin, Arthur, L,2894349.970.000.000.0049.97
Huang, Mandy,1826672.260.000.000.0072.26
Sara, Tabitha, W,257151274.080.00699.100.00574.98
Zheng, Sandra, P,1514163.970.000.000.0063.97
Gao, Lisa, A,197534.990.000.000.004.99
Li, Barbara,157884443.380.000.002071.422371.96
Dominguez, Micheal,261421952.450.00782.990.001169.46
Perez, Brett, M,28313647.940.000.000.00647.94
Jimenez, Walter,172324347.763578.270.000.00769.49
Ortega, Armando, K,25223102.960.000.00102.960.00
Allen, Devin,15806102.850.000.00102.850.00
Xie, Lindsey, M,251324.990.000.000.004.99
Alonso, Sheila,25054103.480.000.000.00103.48
Jiménez, Alberto, C,152154468.560.000.002049.102419.46
Xie, Alicia,26427123.980.000.000.00123.98
Hernandez, Julio, J,2307815.230.000.000.0015.23
Vazquez, Jésus,2666578.980.000.000.0078.98
Srini, Roy,248882174.920.001000.441174.480.00
Li, Luis, K,2025159.470.000.0059.470.00
Sharma, Donna,119986962.100.003374.991249.842337.27
Long, Megan, J,1579142.260.000.0024.9917.27
Lal, Nina, L,142635647.930.000.002049.103598.83
Suarez, Brandi,218744638.890.002181.560.002457.33
Ma, Curtis,28119574.980.000.000.00574.98
Arun, Nancy, C,211694647.880.002181.560.002466.32
Tang, Leonard, L,28109778.620.000.00778.620.00
Russell, Alexis, L,13634234.930.000.000.00234.93
Xie, Casey,212174659.900.002181.560.002478.34
Alonso, Kristine,166864157.733578.270.000.00579.46
Sanchez, Patrick, W,24382143.780.000.000.00143.78
Li, Glenn, A,292952384.070.000.002384.070.00
Ruiz, Marie, J,274981350.750.000.00782.99567.76
Shen, Wayne, P,2364712.940.000.000.0012.94
Henderson, Dalton,248954.990.000.004.990.00
Mehta, Abby, C,2217921.980.000.000.0021.98
Kumar, Kenneth,114728165.820.003399.992322.282443.55
Tang, Terrence, R,17303123.450.000.000.00123.45
Lu, Candice, I,2120474.980.000.000.0074.98
Kumar, Alison,212003932.540.002181.560.001750.98
Sun, Lacey, L,1513181.260.000.000.0081.26
Madan, Joe,293002419.060.000.000.002419.06
Wu, Kelvin,2459561.960.000.0061.960.00
Williams, Nicholas, A,2580921.490.000.000.0021.49
James, Mariah, M,1910430.970.000.000.0030.97
Alvarez, Lori, C,266621938.470.000.00782.991155.48
Navarro, Sheila, L,218894624.910.002181.560.002443.35
Moore, Natalie, W,182736104.210.003578.272525.940.00
Gao, Todd, M,110618129.023374.990.002369.962384.07
Fernandez, Cassandra, C,141343835.070.000.003835.070.00
Deng, Arturo, A,281021299.830.000.000.001299.83
Raman, Shane,166615908.253578.270.000.002329.98
Weber, Deanna, L,148553759.080.000.002049.101709.98
Long, Emily, L,261401917.460.00782.990.001134.47
Shan, Franklin, C,2771858.980.000.000.0058.98
Hall, Jesse,261331938.470.00782.990.001155.48
Zhang, Ronnie,166565930.233578.270.000.002351.96
Hill, Aaron,2581835.960.000.0035.960.00
Johnsen, Willie,152184399.080.000.002049.102349.98
Arthur, Jay, R,126946785.130.002049.100.004736.03
Xu, Tony, L,225762721.550.002181.560.00539.99
Carlson, Jonathon, N,1707378.970.000.000.0078.97
Rubio, Nelson,264331903.480.00782.990.001120.49
Gao, Susan,274711386.480.000.00782.99603.49
Serrano, Tyrone,113605025.800.003399.990.001625.81
Diaz, Nelson, C,213872745.330.002181.560.00563.77
Suarez, Casey,265481322.980.000.00782.99539.99
Zheng, Erica, K,236434.990.000.004.990.00
Luo, Michele,260271938.470.00782.990.001155.48

Generated 2024-09-20 01:03:22.118 UTC