[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 250  >   <  TAKE 250  >   

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Griffin, Rachel,182556067.200.003578.270.002488.93
Mehta, Pamela,22005135.460.000.000.00135.46
Patterson, Jennifer, M,151295177.730.000.002071.423106.31
Sharma, Terrence, N,173516117.690.003578.270.002539.42
Sanz, Renee, L,14319138.450.000.000.00138.45
Jai, Michele, E,212254732.860.002181.560.002551.30
Moreno, Marc,130242665.060.000.002049.10615.96
Martinez, Holly, B,196286035.600.003578.270.002457.33
Hernandez, Walter,13141240.240.000.000.00240.24
Goel, Bridget,261341926.450.00782.990.001143.46
Lin, Alan,229737.280.000.000.007.28
Zheng, Colleen,13026155.940.000.000.00155.94
Shen, Barbara,220304144.340.000.002443.351700.99
Li, Vincent, D,21207123.960.000.000.00123.96
Chavez, Clayton,219494659.900.000.002181.562478.34
Dominguez, Robyn, P,233057.280.000.000.007.28
He, Curtis, D,249212180.410.000.001000.441179.97
Hu, Omar, S,289542393.060.000.000.002393.06
Patel, Ruben, I,197654132.240.003578.27553.970.00
Liu, Autumn, J,209854118.260.003578.270.00539.99
Perez, Toni,15581113.940.000.000.00113.94
Prasad, Dominic, D,1996246.750.000.000.0046.75
Miller, Zachary, M,151692919.890.000.002071.42848.47
Kumar, Warren, A,240032806.530.000.002181.56624.97
Lal, Jodi, J,2294464.470.000.000.0064.47
Lopez, Brandy, S,1819999.940.000.000.0099.94
Beck, Bonnie, A,29097548.980.000.000.00548.98
Xu, Grant, M,1926642.280.000.000.0042.28
Dominguez, Theodore, F,219874638.890.000.002181.562457.33
Yuan, Alicia,252252129.920.000.001000.441129.48
Vazquez, Marvin, K,2195335.000.000.000.0035.00
Sai, Evelyn,2041513.980.000.000.0013.98
Xie, Jaime,258231887.560.00699.100.001188.46
Luo, Colleen, E,152082951.560.000.002049.10902.46
Lin, Karen,2424348.970.000.000.0048.97
Liang, Jenny, S,27351123.980.000.000.00123.98
Smith, Allen,1407274.980.000.000.0074.98
Alvarez, Beth, M,2930514.980.000.000.0014.98
Madan, Raymond, W,208194181.760.003578.27603.490.00
Anand, Tamara,29088756.330.000.000.00756.33
She, Derek,150363785.080.000.002049.101735.98
Ortega, Eddie,229084661.500.000.002181.562479.94
Nath, Jaime,110336495.293374.990.000.003120.30
Fernandez, Emmanuel,2895514.980.000.000.0014.98
Ms., Rusek, Pearlie, J.,219454886.700.002443.350.002443.35
Cai, Jessie, A,12249114.960.000.000.00114.96
Campbell, Jason, J,136256962.140.000.002049.104913.04
Nara, Kelsey, A,249052195.910.000.001000.441195.47
Yuan, Terry, R,136466843.600.000.002049.104794.50
Li, Lisa, J,246004.990.000.000.004.99
Guo, Aimee,1707577.270.000.000.0077.27
Munoz, Shannon, S,2912249.970.000.000.0049.97
Kumar, Keith, M,252247.280.000.000.007.28
Torres, Naomi, J,1406182.260.000.0032.2749.99
Carson, Kelvin, A,119958249.010.003399.990.004849.02
Suarez, Erika,151205217.700.000.002049.103168.60
Alonso, Lance, I,1405764.970.000.000.0064.97
Flores, Alexandra, C,261651957.470.000.00782.991174.48
Hernandez, Max,1819263.970.000.000.0063.97
Shen, Mitchell, M,229044759.990.000.002181.562578.43
Cai, Jeffery, A,155822907.560.000.002049.10858.46
Davis, Nicole,2295739.980.000.000.0039.98
Munoz, Felicia, D,2040659.980.000.000.0059.98
Rubio, Monique, M,291017.280.000.000.007.28
Wang, Arturo, A,2772039.980.000.0039.980.00
Yuan, Jaclyn,249042199.900.000.001000.441199.46
Hernandez, Mallory,29091756.330.000.000.00756.33
Guo, Randy, L,2295664.470.000.000.0064.47
Beck, Barbara,265471407.960.000.00782.99624.97
Madan, Summer, D,123476839.120.002049.100.004790.02
Sanz, Orlando,1430999.470.000.0074.4824.99
Yang, Valerie, L,2736169.990.000.000.0069.99
Chavez, Karla, K,1670491.260.000.000.0091.26
Tang, Willie, A,259391264.570.00699.100.00565.47
Lin, Autumn, E,182726056.610.003578.272478.340.00
Lu, Alan,1976167.930.000.000.0067.93
Tang, Ashlee, D,11369118.960.000.000.00118.96
Raman, Allen, R,2512960.470.000.0060.470.00
Johnson, Emma, M,1513662.270.000.0034.9927.28
Hu, Ramon,2343968.970.000.0068.970.00
Ruiz, Melody,13621167.400.000.000.00167.40
Malhotra, Ruben, M,1707490.250.000.0058.9831.27
Chen, Bianca,248914.990.000.000.004.99
Mehta, Carla, L,2156339.990.000.0039.990.00
Perez, Janelle,16172186.040.000.000.00186.04
Fernandez, Ivan,220323882.550.000.002181.561700.99
Lal, Tommy,1451678.980.000.0024.9953.99
She, Jeffery, M,2714942.280.000.000.0042.28
Lin, Dawn, N,15805127.470.000.000.00127.47
Davis, Isabella, A,229294673.880.000.002181.562492.32
Xu, Clayton, W,2500149.970.000.000.0049.97
Kapoor, Cynthia,29457756.330.000.000.00756.33
Xie, Dustin,2220442.280.000.000.0042.28
Ashe, Tara, J,190936035.600.003578.270.002457.33
Sharma, Dustin, M,184846093.200.003578.272514.930.00
Rai, Nina,1401863.870.000.000.0063.87
Lin, Wesley,2140742.280.000.0042.280.00
Raji, Carl,195956095.080.003578.270.002516.81
Rai, Karl, M,252731898.07699.100.000.001198.97
Deng, Arturo, A,281021299.830.000.000.001299.83
Martin, Beth, K,2331739.980.000.000.0039.98
Shen, Katrina,158014381.380.000.002049.102332.28
Rodriguez, Geoffrey,208174118.260.003578.27539.990.00
Pal, Gilbert,27744643.950.000.00643.950.00
Raji, Warren, J,267961957.470.000.00782.991174.48
Torres, Wendy, A,182696113.200.003578.270.002534.93
Suarez, Casey,265481322.980.000.00782.99539.99
Lopez, Stanley, M,289622477.530.000.000.002477.53
Wood, Fernando, K,242539.990.000.000.009.99
She, Kathryn, I,264431938.470.000.00782.991155.48
Serrano, Jacquelyn,2196339.990.000.000.0039.99
Alvarez, Gloria, B,182976119.590.003578.272541.320.00
Chande, Franklin, L,2023291.950.000.000.0091.95
Sullivan, Carla, A,206116021.620.003578.270.002443.35
Kumar, Kate,173218.990.000.000.008.99
Carlson, Orlando, J,118938123.030.003374.992319.992428.05
Guo, Autumn, A,1421386.260.000.000.0086.26
Serrano, Joanna, J,266631976.940.000.00782.991193.95
Rai, Terrence, R,250372174.920.000.001000.441174.48
Moreno, Dwayne, T,2310385.480.000.000.0085.48
Murphy, Grace, J,236554144.340.000.002443.351700.99
Ma, Jeffery,1826469.970.000.000.0069.97
Gomez, Adrienne,119208156.320.003374.990.004781.33
Parker, Mason, W,259236.280.000.006.280.00
Romero, Latasha,142205696.190.000.002071.423624.77
Gill, Mathew, M,274861371.950.000.00782.99588.96
Sharma, Keith,1572863.970.000.0028.9834.99
Kapoor, Abby, J,29054751.340.000.000.00751.34
Hernandez, Ebony, S,235743337.040.000.002181.561155.48
Garcia, Virginia, C,2459926.970.000.000.0026.97
Gomez, Felicia, J,182196038.560.003578.272460.290.00
Andersen, Willie, M,2797064.470.000.000.0064.47
Li, Elijah,167406099.103578.270.002520.830.00
Gill, Gina, F,241772721.550.000.002181.56539.99
Cai, Amy,249202155.920.000.001000.441155.48
Gill, Gary, B,251082199.410.000.001000.441198.97
Munoz, Briana,234374.990.000.000.004.99
Coleman, Nicole, A,215584919.300.002443.350.002475.95
Xu, Peter, K,282042419.060.000.002419.060.00
Alonso, Darren,27501578.460.000.000.00578.46
Sara, Ross,243674179.330.000.002443.351735.98
West, James, M,1514890.750.000.000.0090.75
Rodriguez, Pedro, L,179114698.760.003578.270.001120.49
Munoz, Teresa, R,277121174.480.000.000.001174.48
Dominguez, Darren, M,139666842.120.000.002049.104793.02
Evans, Xavier,19098122.240.000.000.00122.24
Sun, Franklin,196155279.260.003578.270.001700.99
Lal, Barbara, W,231012795.010.000.002181.56613.45
Sara, Clifford, M,241782810.530.000.002181.56628.97
Rogers, Seth, R,14318138.450.000.0063.9774.48
Lopez, Clifford, E,27709628.970.000.000.00628.97
Rana, Cindy,213677.280.000.007.280.00
Ferrier, Linda, D,1314964.970.000.000.0064.97
Rai, Johnny, A,131356773.140.000.002049.104724.04
Huang, Damien,165244733.753578.270.000.001155.48
Zhao, Kelvin,251357.280.000.000.007.28
Raji, Willie, T,110708165.550.003399.992345.222420.34
Moreno, Kristine, K,28481778.620.000.000.00778.62
Lal, Gabriel,274731398.460.000.00782.99615.47
Schmidt, Deanna, H,259361248.080.00699.100.00548.98
Hernandez, Roberto,289232393.060.000.002393.060.00
Rodriguez, Sergio, D,15239123.450.000.000.00123.45
Cai, Warren,249182120.930.000.001000.441120.49
Anand, Rafael,293062384.070.000.000.002384.07
Lopez, Savannah,257091308.060.00699.100.00608.96
Pal, Willie, J,1175546.250.000.000.0046.25
Jenkins, Wyatt,27987553.970.000.000.00553.97
Serrano, Jésus, B,129915641.900.000.002049.103592.80
Xu, Kate, R,289572419.060.000.000.002419.06
Ashe, Barbara,1873424.270.000.000.0024.27
Ramos, Rodney, C,14059106.750.000.000.00106.75
Ortega, Monique, C,123556818.110.002049.100.004769.01
Gutierrez, Larry,259261308.060.00699.100.00608.96
Subram, Cassandra, M,1661876.150.000.000.0076.15
Yang, Colin, J,206126060.500.003578.270.002482.23
Ramos, Larry,1844621.490.000.000.0021.49
Liu, Steve, V,235233337.040.000.003337.040.00
Raje, Grant, S,241623004.830.000.002443.35561.48
Parker, Gabriel,1960683.970.000.000.0083.97
Subram, Douglas,273521357.970.000.00782.99574.98
Subram, Ross, L,230857.280.000.000.007.28
Chapman, Clifford, C,211684624.910.002181.560.002443.35
Kumar, Tasha, M,202495333.250.003578.270.001754.98
Liu, Glenn,188994118.260.003578.27539.990.00
Hernandez, Erika,161602644.070.000.002049.10594.97
Yuan, Melvin,2933147.970.000.000.0047.97
Suri, Cassandra, B,1871787.210.000.000.0087.21
Deng, Priscilla, M,251272174.920.000.001000.441174.48
Sanchez, Ross,283104.990.000.000.004.99
Moore, Olivia, A,252312189.900.000.001000.441189.46
Subram, Meredith, S,142615653.920.000.002049.103604.82
Martinez, Emmanuel, V,2137039.980.000.000.0039.98
Xylaras, Ioannis,202155279.260.003578.270.001700.99
Madan, Ann,219484886.700.002443.350.002443.35
Shen, Priscilla, A,28215589.960.000.000.00589.96
Guo, Glenn, J,1871224.270.000.000.0024.27
Dominguez, Lee, R,245974009.500.000.002181.561827.94
Fernandez, Brandy, B,229584208.310.000.002443.351764.96
Gill, Gerald, A,28487805.330.000.000.00805.33
Jones, Ethan,130516831.740.000.002071.424760.32
Goel, April, C,16166108.850.000.0069.9738.88
Zeng, Dawn, D,29455751.340.000.000.00751.34
Munoz, Diane, R,15795132.440.000.000.00132.44
Raji, Kathryn, C,2199537.290.000.000.0037.29
Patel, Monica, J,252342174.920.000.001000.441174.48
Chander, Karla,236484144.340.000.002443.351700.99
Chande, Carl,1893259.260.000.000.0059.26
Zhu, Wesley, L,1962423.780.000.000.0023.78
Saunders, Patricia, J,195655308.240.003578.270.001729.97
Deng, Barbara,204456078.710.003578.270.002500.44
Shan, Carl, D,249192212.890.000.001000.441212.45
Raman, Frederick, F,289429.990.000.000.009.99
Raji, Bradley, E,179254698.760.003578.270.001120.49
Sanchez, Michele,2354312.940.000.000.0012.94
Sara, Adriana, M,15146161.940.000.000.00161.94
Xie, Nina,12997118.180.000.000.00118.18
Huang, Lisa, L,141023667.230.000.002910.90756.33
Chander, Clarence, E,1398259.980.000.0034.9924.99
Patel, Arthur, B,2667169.990.000.000.0069.99
Zhou, Jessie,206106021.620.003578.270.002443.35
Dominguez, Gerald, E,2063171.960.000.000.0071.96
Jai, Melvin, M,27722564.210.000.000.00564.21
Gonzalez, George, L,119424792.290.003399.99614.96777.34
Moyer, Meghan,2122074.980.000.000.0074.98
Suri, Rachael, J,18279162.020.000.000.00162.02
Torres, Monique,252352155.920.000.001000.441155.48
Rubio, Jay,151794444.890.000.002071.422373.47
She, Ricardo, A,1423378.970.000.000.0078.97
Patel, Pamela, G,278751268.840.000.001268.840.00
Cooper, Cody, A,160283807.400.000.002071.421735.98
Raji, Jaime, L,150373856.380.000.002071.421784.96
Sun, Candice, A,195686060.500.003578.270.002482.23
Xu, Colleen, C,18325108.850.000.0038.8869.97
Zeng, Wesley,2046021.490.000.0021.490.00
Hu, Cara,206086035.600.003578.270.002457.33
Lopez, Ross,1844360.470.000.000.0060.47
Dominguez, Josue, R,156004590.400.000.002071.422518.98
Jiménez, Briana, T,28118588.960.000.000.00588.96
Lopez, Kari,15235190.890.000.000.00190.89
Hayes, Christian, R,2853739.980.000.000.0039.98
Rai, Clayton, K,204466029.570.003578.270.002451.30
Sai, Harold,110266575.793399.990.000.003175.80
Zhang, Alejandro, P,21992184.260.000.000.00184.26
Gonzalez, Marco,27598556.260.000.000.00556.26
Vance, Toni, L,23438123.480.000.000.00123.48
Luo, Lacey,241752743.040.000.002181.56561.48
Watson, Adrian, K,13641144.740.000.000.00144.74
Jimenez, Jaime, E,29095777.340.000.000.00777.34
Diaz, Marc,110588248.023399.990.002374.982473.05
Ashe, Brad,252282120.930.000.001000.441120.49

Generated 2024-11-14 05:49:27.536 UTC