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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Vance, Meredith, B,209834178.730.003578.270.00600.46
Liu, Jessie,111068079.050.003399.992294.992384.07
Alonso, Brandi,1706186.270.000.000.0086.27
Jimenez, Teresa, L,243723356.040.000.002181.561174.48
Butler, Austin, W,1829374.240.000.0074.240.00
Lal, Terry,182776070.590.003578.270.002492.32
Ye, Jenny,250362120.930.000.001000.441120.49
Perez, Stefanie,27518123.980.000.000.00123.98
Lu, Martha, R,2125532.280.000.0032.280.00
Vazquez, Victor, R,29453742.350.000.000.00742.35
Shan, Dylan,1967758.980.000.000.0058.98
Raji, Brendan,131036842.600.000.002049.104793.50
Zimmerman, Krystal,1722877.270.000.000.0077.27
Subram, Meredith, S,142615653.920.000.002049.103604.82
Dominguez, Gina, L,202136029.570.003578.270.002451.30
James, Evan, V,1111985.220.000.0035.2349.99
Luo, Julie, M,2912169.970.000.000.0069.97
Gutierrez, Jaime, C,114578211.480.003374.992359.962476.53
Muñoz, Alberto, J,13008125.510.000.000.00125.51
Sun, Jamie,213892770.520.002181.560.00588.96
Raman, Levi,291142384.070.000.000.002384.07
Sharma, Julie, R,1819194.470.000.008.9985.48
Raman, Deanna, H,17053123.960.000.000.00123.96
Zhou, Autumn, L,252292155.920.000.001000.441155.48
Arun, Nancy, C,211694647.880.002181.560.002466.32
Beck, Alicia, L,172484382.753578.270.000.00804.48
Hall, Jeremiah, M,182506058.210.003578.272479.940.00
Shen, Grant, B,267631957.470.000.00782.991174.48
Chen, Steve, R,189024186.230.003578.27607.960.00
Blanco, Marc,249082155.920.000.001000.441155.48
Martin, Hector,27860615.470.000.000.00615.47
Munoz, Cheryl, C,136326838.460.000.002071.424767.04
Kumar, Bridget,158024444.070.000.002049.102394.97
Gutierrez, Jaime, A,2522739.980.000.000.0039.98
Sanchez, Levi, A,27745617.470.000.00617.470.00
Rubio, Natasha, K,13627214.250.000.000.00214.25
Chavez, Jodi, A,189096035.600.003578.270.002457.33
Cai, Vincent, L,1175758.050.000.0024.4933.56
Travers, Jimmy, V,126746829.470.002071.420.004758.05
She, Keith, L,265631957.470.000.00782.991174.48
Rodriguez, Ruben,125892665.060.002049.100.00615.96
Gonzalez, Phillip, N,182076089.590.003578.272511.320.00
Diaz, Gerald, M,251187.280.000.000.007.28
Lopez, Sergio, L,1512381.260.000.000.0081.26
She, Mindy, J,13009168.670.000.000.00168.67
Gutierrez, Marvin,259381308.060.00699.100.00608.96
Mehta, Levi, M,131105583.940.000.002049.103534.84
Gonzalez, Kristopher, C,192644132.240.003578.27553.970.00
Chandra, Carmen, R,2331515.230.000.000.0015.23
Shen, Tony,29099548.980.000.000.00548.98
Rivera, Devin, J,251094.990.000.000.004.99
Dominguez, Jimmy,219594702.390.002181.560.002520.83
Raji, Donna,2490661.960.000.000.0061.96
Johnson, Emma, M,1513662.270.000.0034.9927.28
Suarez, Orlando,1112158.160.000.000.0058.16
Tang, Latoya, F,229103882.550.000.002181.561700.99
Vance, Denise, L,212054886.700.002443.350.002443.35
Bhat, Edwin,130796752.130.000.002049.104703.03
Gonzalez, Francisco, L,122453967.260.003399.990.00567.27
Yuan, Sharon,1200855.760.000.000.0055.76
Wang, Randy, G,2512568.490.000.000.0068.49
Zhao, Kelvin,251357.280.000.000.007.28
Madan, Kristopher, A,252387.280.000.000.007.28
Zhou, Rafael, A,244949.990.000.009.990.00
Zhao, Gilbert,231193945.530.000.002181.561763.97
Raji, Wayne, A,261611903.480.000.00782.991120.49
Ramos, Dana, D,259191248.080.00699.100.00548.98
Moore, Natalie, W,182736104.210.003578.272525.940.00
Gutierrez, Rodney, J,206286056.610.003578.270.002478.34
Zhang, Barbara,16338169.430.000.0058.47110.96
Mehta, Patricia, K,291792393.060.000.000.002393.06
Navarro, Kristine, B,255661253.070.00699.100.00553.97
James, Brooke,1874578.260.000.000.0078.26
Andersen, Jaime,2526860.470.000.000.0060.47
Raman, Virginia,2615969.990.000.000.0069.99
Rai, Rafael, H,18715123.960.000.000.00123.96
Gonzalez, Kaylee, L,218954657.510.002181.560.002475.95
Rubio, Randall, M,172866029.570.003578.270.002451.30
She, Lindsay,29456765.320.000.000.00765.32
Alan, Meghan, I,28210564.480.000.000.00564.48
Henderson, Dalton,248954.990.000.004.990.00
Allen, Logan,1581281.250.000.000.0081.25
Martinez, Jay,245923896.530.000.002181.561714.97
Saunders, Patricia, J,195655308.240.003578.270.001729.97
Lu, Darryl,277021155.480.000.000.001155.48
Alvarez, Rodney, D,2928613.980.000.000.0013.98
Huang, Willie, C,28133574.980.000.000.00574.98
Hernandez, Walter,13141240.240.000.000.00240.24
Chande, Bonnie, L,239923167.820.000.002443.35724.47
Rubio, Monique, M,291017.280.000.000.007.28
Romero, Philip, F,221954909.670.000.002443.352466.32
Suri, Holly, M,18286141.550.000.0069.9771.58
Lal, Alicia,157344426.410.000.002071.422354.99
Cai, Amy,249202155.920.000.001000.441155.48
Ramirez, Mason, K,251072143.900.000.001000.441143.46
Johnston, Tamara, H,18492218.260.000.000.00218.26
Kumar, Gilbert, L,2814039.980.000.000.0039.98
Serrano, Neil, L,17076103.460.000.000.00103.46
Xu, Jessie, R,27517539.990.000.000.00539.99
Zhu, Roger, J,280981249.840.000.000.001249.84
Adams, Isabella,1571539.970.000.000.0039.97
Ramos, Marc,182126029.570.003578.272451.300.00
Dominguez, Rebekah,278771228.830.000.000.001228.83
Martin, Randall, B,195606117.690.003578.270.002539.42
Vance, Monica, G,123388265.000.003374.990.004890.01
Lal, Rafael, W,2894568.970.000.000.0068.97
Diaz, Carolyn, C,243603626.820.000.002443.351183.47
Patel, Toni, E,258291894.070.00699.100.001194.97
Ashe, Deanna,202845328.230.003578.270.001749.96
Chow, Christy, M,126816784.130.002049.100.004735.03
Scott, Alex, T,143482989.380.000.002071.42917.96
Ma, Warren, A,1976248.970.000.000.0048.97
Yang, Jamie, S,184654752.750.003578.270.001174.48
Bryant, Lauren,11752137.870.000.0077.9659.91
Mehta, Heidi,142265656.240.000.002071.423584.82
Lewis, Hannah,265611336.960.000.00782.99553.97
Sanz, Jésus,29313539.990.000.000.00539.99
Navarro, Kellie, I,218734661.500.000.002181.562479.94
Li, Jake, L,1958397.960.000.000.0097.96
Sara, Troy, R,225832821.510.000.002181.56639.95
Rogers, Anna,212014921.690.002443.350.002478.34
Zhang, Jenny, H,246092120.930.001000.441120.490.00
Nath, Bethany,16177133.340.000.000.00133.34
Lu, Micah,221743007.830.000.002443.35564.48
Liang, Omar,2424517.270.000.000.0017.27
Perez, Allen, B,1422974.980.000.000.0074.98
Huang, Lisa, L,141023667.230.000.002910.90756.33
She, Eugene, L,209982806.510.002181.560.00624.95
Luo, Warren,235624.990.000.000.004.99
Arthur, Carla,1671091.260.000.000.0091.26
Madan, Candace,224092746.040.000.002181.56564.48
Lal, Leonard,261601938.470.000.00782.991155.48
Chander, Shawn, S,202165338.740.003578.270.001760.47
Gutierrez, Kari,157564441.390.000.002071.422369.97
Moreno, Lori, M,152264391.410.000.002071.422319.99
Serrano, Leslie, T,1401462.270.000.000.0062.27
Patel, Gerald,230954.990.000.000.004.99
Sanchez, Carla,1827430.970.000.000.0030.97
Garcia, Chelsea,2196142.280.000.0042.280.00
Andersen, Jenny,202596029.570.003578.270.002451.30
Gutierrez, Armando,293102419.060.000.000.002419.06
Subram, Ivan, A,2614778.980.000.000.0078.98
Lopez, Carla, G,283262442.540.000.002442.540.00
Torres, Jacqueline,219764198.330.000.002443.351754.98
Xu, Alejandro, R,265851903.480.000.00782.991120.49
Sanz, Lance,225732721.550.000.002181.56539.99
Wood, Richard, W,243773945.530.000.002181.561763.97
Shen, Karla, E,22925134.930.000.000.00134.93
Zhang, Alejandro, P,21992184.260.000.000.00184.26
Navarro, Byron,1662236.590.000.000.0036.59
Thompson, Cameron, M,166205895.243578.270.000.002316.97
Alvarez, Philip, A,1112345.880.000.000.0045.88
Pal, Mitchell, R,167426044.593578.270.002466.320.00
Munoz, Robyn,142145759.870.000.002049.103710.77
Raji, Grant, R,1618528.980.000.000.0028.98
Fernandez, Shane, A,1312786.260.000.000.0086.26
Gomez, Marvin, C,28479831.330.000.000.00831.33
Blanco, Kari,1962741.750.000.0027.7713.98
Chander, Carl,14315109.710.000.000.00109.71
Li, Lacey,175154143.260.003578.270.00564.99
Chander, Clarence, E,1398259.980.000.0034.9924.99
Rana, Terrance, M,28134574.980.000.000.00574.98
Chander, Marshall,1909059.260.000.002.2956.97
Guo, Don,1874221.980.000.000.0021.98
Becker, Latoya, W,1733030.970.000.000.0030.97
Zhang, Aimee,260251917.460.00782.990.001134.47
Subram, Tabitha, C,175114150.530.003578.27572.260.00
Weber, Levi, A,13120205.390.000.0049.48155.91
Perez, Kyle, J,161804386.370.000.002049.102337.27
Prasad, Carmen, L,189286095.080.003578.270.002516.81
Shen, Devon, G,2735878.980.000.000.0078.98
Luo, Mario, L,257111274.080.00699.100.00574.98
Munoz, Felicia, D,2040659.980.000.000.0059.98
Madan, Ronald,258281873.580.00699.100.001174.48
Xu, Wesley, K,29182539.990.000.000.00539.99
Kumar, Barbara, N,274991331.970.000.00782.99548.98
Blanco, Sheila, I,1772436.960.000.000.0036.96
Moreno, Diana, J,29298548.980.000.000.00548.98
Vazquez, Byron,1112242.930.000.007.9534.98
Goel, Alejandro, K,130776766.630.000.002049.104717.53
Alvarez, Erik, M,14311138.450.000.0074.4863.97
Srini, Beth, A,259136.280.000.000.006.28
Butler, Hannah, R,131115707.200.000.002071.423635.78
Reed, Riley, A,201574118.260.003578.27539.990.00
Gao, Eugene,29464756.330.000.000.00756.33
Hernandez, Julio, J,2307815.230.000.000.0015.23
Andersen, Roger,2446964.470.000.0064.470.00
Nara, Kelsey, A,249052195.910.000.001000.441195.47
Munoz, Gloria, L,197896058.210.003578.270.002479.94
Sun, Aimee, R,1831960.470.000.000.0060.47
Munoz, Gary, D,2023032.280.000.000.0032.28
Guo, Clarence,2026532.280.000.0032.280.00
He, Kelli, A,2887259.980.000.0059.980.00
She, Nichole, M,119098105.310.003374.990.004730.32
Zhou, Jessie,206106021.620.003578.270.002443.35
Xu, Crystal, E,157544416.380.000.002071.422344.96
Goel, Katie, D,2770864.470.000.000.0064.47
Carlson, Tanya,1618331.270.000.000.0031.27
Gao, Cara, B,156423772.410.000.002071.421700.99
Gutierrez, Kristine, G,251332155.920.000.001000.441155.48
Gutierrez, Meghan, E,260211917.460.00782.990.001134.47
Sanz, Rodney,1692644.950.000.000.0044.95
Jai, Latoya, S,212294198.330.002443.350.001754.98
Perez, Geoffrey, P,210002721.550.002181.560.00539.99
Malhotra, Tina, C,27584599.470.000.000.00599.47
Hernandez, Brandi, C,218934663.790.002181.560.002482.23
Liu, Cedric,126776785.470.002071.420.004714.05
Ye, Steve,29087810.320.000.000.00810.32
Zhou, Stacey, L,213747.280.000.007.280.00
Lopez, Carmen, S,135284531.040.000.002071.422459.62
Bradley, Emma,142115662.900.000.002049.103613.80
Ward, Shelby,2613239.980.000.0039.980.00
Li, Justin,1412457.590.000.000.0057.59
Yuan, Franklin,2459439.980.000.0039.980.00
Roberts, Jennifer,114478078.020.003374.992309.972393.06
Munoz, Anne,1579898.960.000.000.0098.96
Pal, Alvin, C,293192447.050.000.000.002447.05
Liu, Omar, L,122523938.950.003374.990.00563.96
Sara, Marco, L,1564196.750.000.000.0096.75
Moreno, Monique, R,231183913.820.000.002181.561732.26
Andersen, Nina,183386124.580.003578.270.002546.31
Watson, Nathaniel, H,258261854.580.00699.100.001155.48
Taylor, Devin, L,122483939.980.003399.990.00539.99
Yang, Rosa,18713237.260.000.000.00237.26
Mehta, Preston, G,186926035.600.003578.272457.330.00
Chande, Casey,2614978.980.000.000.0078.98
Moreno, Tabitha,199596056.610.003578.270.002478.34
Rai, Terrence, R,250372174.920.000.001000.441174.48
Blanco, Alberto, R,278672443.550.000.000.002443.55
Zhao, Shannon,1980735.470.000.000.0035.47
Taylor, Ashley, E,18215150.970.000.000.00150.97
Fernandez, Jay,2015559.980.000.000.0059.98
Gao, Wesley,123466864.460.002071.420.004793.04
Huang, Alan, A,126716802.130.002049.100.004753.03
Raji, Andres, E,139556888.440.000.002071.424817.02
Alonso, Kathleen,2119634.980.000.000.0034.98
Zheng, Randy, B,2257469.990.000.000.0069.99
Malhotra, Phillip, J,2197774.980.000.000.0074.98
Romero, Ricky,213612997.320.002443.350.00553.97
Martinez, Edgar, B,1874160.470.000.000.0060.47
Chander, Alejandro, M,2445575.470.000.000.0075.47
Raheem, Bethany, L,2196599.470.000.000.0099.47
Carlson, Jose,1995474.450.000.0060.4713.98
Gutierrez, Philip, M,219793936.540.000.002181.561754.98
Martinez, Tina, J,184614748.240.003578.270.001169.97
Thompson, Justin,229544179.330.000.002443.351735.98
Fernandez, Nancy,1485472.960.000.000.0072.96
Gomez, Jill,29315103.960.000.000.00103.96
Hill, Noah,261921903.480.000.00782.991120.49
Romero, Paula, B,166914471.743578.270.00893.470.00

Generated 2024-11-13 04:26:03.080 UTC