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

248 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Ramos, Theresa, G,110316478.603399.990.000.003078.61
Carlson, Jay,202645333.250.003578.270.001754.98
Xie, Kelli, J,204526156.700.003578.270.002578.43
Serrano, Kristi,206166093.200.003578.270.002514.93
Luo, Shawn,122463947.250.003374.990.00572.26
Sun, Shannon,120077023.780.003399.990.003623.79
Wilson, Sam,259471854.580.00699.100.001155.48
Perez, Ronald,259441274.080.00699.100.00574.98
Vance, Meredith, B,209834178.730.003578.270.00600.46
Sara, Cassandra, D,209894148.740.003578.270.00570.47
Perez, Molly,259411255.360.00699.100.00556.26
Lu, Margaret, D,208144186.230.003578.27607.960.00
Sun, Jenny, L,122534066.930.003399.990.00666.94
Arun, Gerald,259401277.560.00699.100.00578.46
Carlson, Robin,197866021.620.003578.270.002443.35
Chen, Jaclyn, C,2284737.290.000.000.0037.29
Wang, Micah, C,146765188.410.000.002049.103139.31
Evans, Jackson,1432127.280.000.000.0027.28
Zheng, Dawn, F,1957983.980.000.000.0083.98
Patel, Douglas,179274726.040.003578.270.001147.77
Stone, Brenda, J,12697296.190.000.000.00296.19
Suarez, Briana, A,152662935.370.000.002071.42863.95
She, Jaime, D,28482777.340.000.000.00777.34
Coleman, Melanie, H,1563934.570.000.000.0034.57
Romero, Max, C,293162433.040.000.000.002433.04
Vazquez, Arthur,28480742.350.000.000.00742.35
Anand, Lacey, J,27150201.280.000.000.00201.28
Zimmerman, Krystal,1722877.270.000.000.0077.27
Suarez, Meredith,150323800.080.000.002049.101750.98
Sai, Martin, L,2122129.990.000.000.0029.99
Wu, Alisha,2365459.980.000.000.0059.98
Reed, Steven,2437327.770.000.000.0027.77
Chander, Lindsay, R,1997249.700.000.000.0049.70
Powell, Elizabeth, K,283064.990.000.000.004.99
Navarro, Teresa, E,258167.280.000.000.007.28
Zhu, Sandra, V,157324376.400.000.002071.422304.98
Nath, Omar, F,146725237.720.000.002071.423166.30
Deng, Michele,219464659.800.002181.560.002478.24
Kumar, Louis, A,182034172.250.003578.270.00593.98
Shen, Dustin,27974553.970.000.000.00553.97
Williams, Alexis, D,14674142.470.000.000.00142.47
Mehta, Regina,1724592.970.000.000.0092.97
Blanco, Wendy, J,19604171.730.000.000.00171.73
Rubio, Kristy,122433914.980.003374.990.00539.99
Suarez, Jerome, L,206226139.590.003578.270.002561.32
Yuan, Lacey, W,123496772.140.002049.100.004723.04
Green, Jennifer,125712641.390.002071.420.00569.97
Moreno, Roberto, R,212063882.550.002181.560.001700.99
Kumar, Katie, P,123416840.620.002049.100.004791.52
Moreno, Hector,211834657.510.002181.560.002475.95
Ortega, Alfredo, W,259581903.480.00782.990.001120.49
Huang, Crystal, L,260231917.460.00782.990.001134.47
Pal, Sheena, D,211973917.540.002181.560.001735.98
Rogers, Anna,212014921.690.002443.350.002478.34
Gutierrez, Clinton,210013018.330.002443.350.00574.98
Goel, Mario, J,123606750.480.002071.420.004679.06
Chapman, Clifford, C,211684624.910.002181.560.002443.35
Ashe, Joanna, F,209972744.520.002181.560.00562.96
She, Corey, T,212144659.900.002181.560.002478.34
Becker, Kara,211674657.510.002181.560.002475.95
Nath, Cassie,246062155.920.001000.441155.480.00
Prasad, Gerald, B,1203581.240.000.0064.9716.27
Price, Ian, J,224012983.340.000.002443.35539.99
Garcia, Ruben,196136093.200.003578.270.002514.93
Kumar, Tony, P,197836021.620.003578.270.002443.35
Chander, Julie, E,18763123.960.000.000.00123.96
She, Colleen, E,2931269.970.000.000.0069.97
Ye, Marshall, R,2655938.980.000.000.0038.98
Rana, Henry,273421348.460.000.00782.99565.47
Kumar, Mindy, R,127006860.440.000.002071.424789.02
She, Kathryn, I,264431938.470.000.00782.991155.48
Gutierrez, Larry,259261308.060.00699.100.00608.96
Li, Margaret,157534399.080.000.002049.102349.98
Rai, Johnny, A,131356773.140.000.002049.104724.04
Chande, Jerry,183314752.750.003578.270.001174.48
Blanco, Natasha,158084424.080.000.002049.102374.98
Barnes, Faith, F,157264393.360.000.002049.102344.26
Hernandez, Walter,13141240.240.000.000.00240.24
Gao, Christy, D,262041967.450.000.00782.991184.46
Huang, Amy, C,12244114.960.000.0049.9964.97
Moreno, Dwayne, T,2310385.480.000.000.0085.48
Raje, Raul, L,2678574.980.000.000.0074.98
Gill, Mallory, P,16698197.880.000.000.00197.88
Rodriguez, Francisco,243613391.030.000.002181.561209.47
Navarro, Casey,197956044.590.003578.270.002466.32
Browning, Javier,231204144.340.000.002443.351700.99
Ortega, Anne,130116819.110.000.002049.104770.01
Alvarez, Stacy,119018248.010.003399.990.004848.02
Vazquez, Hector, E,197726030.610.003578.270.002452.34
Allen, Mary,212034633.900.002181.560.002452.34
Gao, Jamie,260221938.470.00782.990.001155.48
Gomez, Sheila, J,211654673.880.002181.560.002492.32
Wood, Maria,126676813.120.002049.100.004764.02
Arun, Candace, J,213934925.170.002443.350.002481.82
Hernandez, Kellie, A,125862636.410.002071.420.00564.99
Serrano, Gloria, G,215564930.680.002443.350.002487.33
Liu, Cedric,126776785.470.002071.420.004714.05
Jai, Michele, E,212254732.860.002181.560.002551.30
Vazquez, Danny, J,260331903.480.00782.990.001120.49
Ms., Roy, Lisa, K.,214034895.690.002443.350.002452.34
Chapman, Alicia, A,214184659.900.002181.560.002478.34
Alvarez, Francis,215524624.910.002181.560.002443.35
Sara, Candace,213802735.530.002181.560.00553.97
Xu, Kelvin, K,212223936.540.002181.560.001754.98
Sanz, Francis,125772614.080.002049.100.00564.98
Johnsen, Ross,19618119.450.000.000.00119.45
Sanchez, Bryant, C,131136832.410.000.002071.424760.99
Xu, Jessie, R,27517539.990.000.000.00539.99
Sara, Carmen, W,1258283.970.000.000.0083.97
Prasad, Harold,1960868.450.000.000.0068.45
Madan, Martin, M,24911102.960.000.000.00102.96
Gill, Eddie, J,1271574.540.000.0064.979.57
Li, Jack, J,140715617.920.000.002049.103568.82
Ortega, Shannon,263751971.450.000.00782.991188.46
Yuan, Karla, W,136296889.110.000.002049.104840.01
Xie, Alicia,26427123.980.000.000.00123.98
Xu, Colleen, C,18325108.850.000.0038.8869.97
Chande, Alvin, W,2489323.780.000.000.0023.78
Alonso, Krista, P,20212100.740.000.000.00100.74
Gutierrez, Diana,1967667.970.000.000.0067.97
Raman, Pamela, C,2736978.980.000.000.0078.98
She, Willie,170554347.763578.270.000.00769.49
Ray, Bobby,235753302.050.000.002181.561120.49
Zhou, Jamie,1732799.940.000.000.0099.94
Pal, Dale,1845175.470.000.000.0075.47
Smith, Christian, L,14313222.440.000.000.00222.44
Prasad, Tabitha, D,267611938.470.000.00782.991155.48
Jai, Warren, S,164834118.263578.270.000.00539.99
Perez, Carmen, C,131396854.450.000.002071.424783.03
Blanco, Mallory,219584696.490.000.002181.562514.93
Deng, Jaime, R,219684722.880.000.002181.562541.32
Zhao, Alisha, M,2198835.000.000.000.0035.00
She, Roger, L,157244359.070.000.002049.102309.97
Shan, Yolanda,127026911.100.000.002049.104862.00
Martinez, Kari,196096093.200.003578.270.002514.93
Ye, Tamara, A,2024360.470.000.000.0060.47
Zhou, Laura, D,126836801.450.002071.420.004730.03
Chander, Devon,246122152.200.001000.441151.760.00
Madan, Michele, A,126766859.460.002071.420.004788.04
Lopez, Kristopher, L,215604702.390.002181.560.002520.83
Rodriguez, Ruben,125892665.060.002049.100.00615.96
Madan, Jarrod, C,215554715.490.002181.560.002533.93
King, Kevin, W,214024624.910.002181.560.002443.35
Zhu, Candice, S,212194696.490.002181.560.002514.93
Vazquez, Roy,260291930.760.00782.990.001147.77
Martinez, Ian,125852629.070.002049.100.00579.97
Garcia, Brandy,260281938.470.00782.990.001155.48
Sun, Micah,248872218.900.001000.441218.460.00
Gill, Jaime, M,261521938.470.00782.990.001155.48
Madan, Ann,219484886.700.002443.350.002443.35
Thompson, Michael, M,261481917.460.00782.990.001134.47
Pal, Mohamed, D,126986786.750.002071.420.004715.33
Reed, Kimberly, D,1731169.970.000.000.0069.97
Deng, Colleen, S,2772867.490.000.000.0067.49
Zhang, Claudia,131146807.450.000.002071.424736.03
Diaz, Briana,131316737.150.000.002049.104688.05
Cox, Angel, M,1879330.480.000.000.0030.48
Goel, Yolanda, M,264351957.470.000.00782.991174.48
Ortega, Lawrence,14685146.740.000.000.00146.74
Ms., Rousey, Linda, R.,212794.990.000.000.004.99
Mehta, Ann, M,14518126.950.000.0063.9762.98
Zhu, Erica,252212143.900.000.001000.441143.46
Nath, Jaime,110336495.293374.990.000.003120.30
Foster, Madison,140386819.120.000.002049.104770.02
Huang, Lisa, L,141023667.230.000.002910.90756.33
Butler, Elijah, D,2155129.990.000.000.0029.99
Zeng, Ramon,279794.990.000.000.004.99
Kumar, Warren, A,240032806.530.000.002181.56624.97
Zhou, Kelvin,2023160.470.000.000.0060.47
Zhao, Jessie, R,110276591.573399.990.000.003191.58
Serrano, Randall,27973539.990.000.000.00539.99
Subram, Kari,12682227.960.000.000.00227.96
Hill, Kaylee, L,119188204.990.003399.990.004805.00
Liang, Valerie,280911249.840.000.000.001249.84
Xu, Keith, J,2512464.470.000.000.0064.47
Sun, Tamara, L,1997644.040.000.000.0044.04
Zhao, Gilbert,231193945.530.000.002181.561763.97
Gomez, Adrienne,119208156.320.003374.990.004781.33
Jimenez, Naomi,249222145.920.000.001000.441145.48
Rivera, Devin, J,251094.990.000.000.004.99
Hayes, Eric, A,22964123.980.000.000.00123.98
Vazquez, Janet, R,2197356.970.000.000.0056.97
Serrano, Danny,243813970.520.000.002181.561788.96
Prasad, Levi,257051274.080.00699.100.00574.98
Nara, Karl,15142138.460.000.000.00138.46
Serrano, Alberto, L,158004399.080.000.002049.102349.98
Rana, Meredith,250322184.900.000.001000.441184.46
Rai, Tonya,252432155.920.000.001000.441155.48
Zhou, Krystal,235933990.010.000.002181.561808.45
He, Dennis, J,278781283.820.000.000.001283.82
Munoz, Robyn,142145759.870.000.002049.103710.77
Arun, Levi, A,1107494.190.000.000.0094.19
Ramirez, Olivia, D,197856076.610.003578.270.002498.34
Saunders, Patricia, J,195655308.240.003578.270.001729.97
Rana, Carla, K,195935306.540.003578.270.001728.27
Bradley, Emma,142115662.900.000.002049.103613.80
Pal, Jenny,15132151.940.000.000.00151.94
Rana, Nancy, H,261501992.460.000.00782.991209.47
Tang, April, A,259351256.030.00699.100.00556.93
Diaz, Vanessa, J,29100102.960.000.000.00102.96
Gill, Theodore,1114941.260.000.000.0041.26
Lin, Dennis,161694404.080.000.002049.102354.98
Raman, Meagan, J,151345151.710.000.002071.423080.29
Li, Alejandro, A,2751978.980.000.000.0078.98
Hernandez, Frank, G,221984661.500.000.002181.562479.94
Blanco, Leslie, L,276951120.490.000.000.001120.49
Rai, Michele, M,265671957.470.000.00782.991174.48
Madan, Stanley,196026093.200.003578.270.002514.93
Lopez, Brandy, S,1819999.940.000.000.0099.94
Gray, Jeremiah,233314144.340.000.002443.351700.99
Arthur, Raymond, S,202286093.200.003578.270.002514.93
Lal, Drew, A,28325574.980.000.000.00574.98
Gomez, Jerome, J,250572120.930.000.001000.441120.49
Ward, Brooke,130075671.240.000.002071.423599.82
Perez, Evelyn,143463583.260.000.002071.421511.84
Rodriguez, Toni, J,2525139.980.000.000.0039.98
Davis, Isabella, A,229294673.880.000.002181.562492.32
Chande, Bonnie, L,239923167.820.000.002443.35724.47
Yang, Lacey,1315089.240.000.000.0089.24
Chander, Karla,236484144.340.000.002443.351700.99
Zhu, Omar,250332120.930.000.001000.441120.49
Torres, Gina,179044733.750.003578.270.001155.48
Xu, Edwin, J,252721873.58699.100.000.001174.48
Nath, Kara, S,2117739.990.000.000.0039.99
Madan, Geoffrey, M,1524151.910.000.000.0051.91
Roberts, Jennifer,114478078.020.003374.992309.972393.06
Kapoor, Rachael, D,1191162.460.000.000.0062.46
Martin, Jaime,28316539.990.000.000.00539.99
Hernandez, Gina,140495290.680.000.002071.423219.26
Rana, Cory, E,1617343.210.000.0031.2711.94
He, Susan, A,244673337.040.000.002181.561155.48
Xu, Martha, C,163515873.263578.270.000.002294.99
Subram, Virginia,130362677.070.000.002049.10627.97
Vazquez, Jonathon,1790621.490.000.000.0021.49
Sai, Jay, A,234274.990.000.000.004.99
Romero, Francis,221964632.860.000.002181.562451.30
Torres, Michele, A,161764404.080.000.002049.102354.98
Madan, Cassandra, D,29068751.340.000.000.00751.34
Chander, Shawn, S,202165338.740.003578.270.001760.47
Cooper, Alex, L,273621407.450.000.00782.99624.46
Diaz, Marc,110588248.023399.990.002374.982473.05
Tang, Cristina, D,19623153.930.000.000.00153.93
Ramos, Kristine,17479163.400.000.000.00163.40
Sanz, Lawrence, M,140306905.470.000.002071.424834.05
Fernandez, Rachael, M,239933072.320.000.002443.35628.97
Dominguez, Kristine, A,140206831.760.000.002071.424760.34
Zeng, Ernest, M,12992158.510.000.000.00158.51
Yang, Wesley, K,151275182.730.000.002071.423111.31

Generated 2024-11-10 09:14:11.242 UTC