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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Serrano, Dwayne,1669576.150.000.000.0076.15
Liang, Brittney, R,261826.280.000.000.006.28
Huang, Barbara,264421919.750.000.00782.991136.76
Chen, Clarence, R,1514797.450.000.000.0097.45
Pal, Willie, J,1175546.250.000.000.0046.25
Deng, Tasha,114598141.330.003399.992322.282419.06
Russell, Jonathan,1889674.980.000.000.0074.98
Alonso, Diane, M,2063074.980.000.000.0074.98
He, Brent, R,257121262.060.00699.100.00562.96
Gill, Javier,156453785.080.000.002049.101735.98
Carlson, Alfredo,16178108.850.000.000.00108.85
Alonso, Sheila,25054103.480.000.000.00103.48
Navarro, Kathleen, J,192694118.260.003578.27539.990.00
Ma, Christy,1502040.260.000.000.0040.26
Sanz, Marvin,196126029.570.003578.270.002451.30
Dominguez, Stacy, S,191056056.610.003578.270.002478.34
Ramos, Michele, J,1957496.740.000.000.0096.74
Suarez, Alfredo,196015314.250.003578.270.001735.98
Perez, Martin,195776037.890.003578.270.002459.62
Lu, Roger, F,197634153.250.003578.27574.980.00
Guo, Brent, J,259451248.080.00699.100.00548.98
Torres, Sebastian, V,258311882.570.00699.100.001183.47
Alvarez, Max, M,119868245.230.003399.990.004845.24
Hill, Alex, C,197876054.220.003578.270.002475.95
Kelly, Zoe,2312339.980.000.000.0039.98
Vazquez, Marvin, K,2195335.000.000.000.0035.00
Liu, Clarence,197976021.620.003578.270.002443.35
Prasad, Ross,289632398.050.000.000.002398.05
Patel, Toni, E,258291894.070.00699.100.001194.97
Gutierrez, Ricky,197736056.610.003578.270.002478.34
Sara, Marco, L,1564196.750.000.000.0096.75
Liu, Darryl,199476056.510.003578.270.002478.24
Smith, Tina, K,197936056.610.003578.270.002478.34
Fernandez, Geoffrey,199636054.220.003578.270.002475.95
Mr., Spencer, Phil,199606120.110.003578.270.002541.84
Rodriguez, Frederick, S,244584144.340.000.002443.351700.99
Jai, Kathryn,235463337.040.000.002181.561155.48
Ashe, Jimmy, S,2895914.980.000.000.0014.98
Xie, Drew, A,20218104.690.000.000.00104.69
She, Eugene, L,209982806.510.002181.560.00624.95
Hu, Leah,119948169.030.003374.990.004794.04
Yuan, Grant, C,249092149.910.000.001000.441149.47
Nath, Alvin, R,29301134.980.000.000.00134.98
Martinez, Ann,120098195.500.003399.990.004795.51
Vance, Monica, G,123388265.000.003374.990.004890.01
Gonzalez, Cynthia,15787167.930.000.000.00167.93
Vazquez, Jerome,231163936.540.000.002181.561754.98
Srini, Joe,221804632.860.000.002181.562451.30
Cai, Jorge,220313896.530.000.002181.561714.97
Moreno, Marc,130242665.060.000.002049.10615.96
Suri, Arthur,261901932.460.000.00782.991149.47
Black, Tracy, B,249032164.910.000.002164.910.00
Suri, Whitney, J,219744925.170.000.002443.352481.82
Serrano, Pedro,261891926.450.000.00782.991143.46
Martin, Ruben,224002737.820.000.002181.56556.26
She, Tamara, M,142245621.220.000.002049.103572.12
Perez, Marie,1399666.260.000.000.0066.26
Chande, Carl,1893259.260.000.000.0059.26
Johnston, Tamara, H,18492218.260.000.000.00218.26
Rai, Christy,1668369.870.000.000.0069.87
Munoz, Darren,235394144.340.000.002443.351700.99
Gomez, Hector, A,2933749.990.000.000.0049.99
Sanz, Kari, V,273411322.980.000.00782.99539.99
She, Sheena, R,2300859.980.000.000.0059.98
Arthur, Cassandra, M,224102983.340.000.002443.35539.99
Xie, Clarence,224022721.550.000.002181.56539.99
Suri, Pedro,264221980.960.000.00782.991197.97
Kumar, Cedric, B,228604663.790.000.002181.562482.23
Sai, Bryant, S,225772743.040.000.002181.56561.48
Moreno, Mallory, P,229124659.900.000.002181.562478.34
Jenkins, Joan,161554489.570.000.002049.102440.47
Liang, Barbara, T,229533899.490.000.002181.561717.93
Russell, Noah, M,264471938.470.000.00782.991155.48
Van, Cassandra,135254607.230.000.002071.422535.81
Schmidt, Joe, M,229054624.910.000.002181.562443.35
Cai, Warren,249182120.930.000.001000.441120.49
Fernandez, Brandy, B,229584208.310.000.002443.351764.96
Moreno, Jessie, C,229064624.910.000.002181.562443.35
Griffin, Noah, E,2911873.960.000.000.0073.96
Gonzalez, Roy, M,1304059.980.000.000.0059.98
Alonso, Billy, M,2285239.990.000.000.0039.99
Gill, Joanna,2618638.980.000.000.0038.98
Rubio, Natasha, K,13627214.250.000.0066.97147.28
Ortega, Renee,1844721.490.000.000.0021.49
Gutierrez, Armando,293102419.060.000.000.002419.06
Navarro, Francis, J,2752078.980.000.000.0078.98
Mehta, Chelsea,229514242.310.000.002443.351798.96
Sara, Ebony,249232159.400.000.001000.441158.96
Alonso, Armando, M,136476793.150.000.002049.104744.05
Raman, César, C,240042744.520.000.002181.56562.96
Hu, Susan,252422120.930.000.001000.441120.49
Stewart, Margaret, C,29096574.980.000.000.00574.98
Dominguez, Darren, M,139666842.120.000.002049.104793.02
Allen, Kaylee,266531938.470.000.00782.991155.48
Chen, Aimee,265911957.470.000.00782.991174.48
Sai, Lydia, L,139685181.700.000.002071.423110.28
Sutton, Kern, A,266601957.470.000.00782.991174.48
Shan, Kristin,234163598.830.000.003598.830.00
Jenkins, Angela,157224448.570.000.002049.102399.47
Zhao, Jamie,1617972.160.000.000.0072.16
Chandra, Veronica,146815178.400.000.002049.103129.30
Madan, Denise, R,2524839.980.000.000.0039.98
Sanchez, Abby, J,199666021.620.003578.270.002443.35
Mr., Schmidt, Steve,157894486.070.000.002049.102436.97
Anand, Niñia, L,199496054.220.003578.270.002475.95
Alonso, Jimmy, T,18280126.560.000.000.00126.56
Chande, Katrina, L,199686021.620.003578.270.002443.35
Sara, Ann, A,2357639.980.000.000.0039.98
Ramos, Dana, D,259191248.080.00699.100.00548.98
Romero, Walter, A,250201549.420.000.001000.44548.98
Wang, Valerie,202176089.590.003578.270.002511.32
Powell, Adam,234233936.540.000.002181.561754.98
She, Rafael, I,201524142.750.003578.27564.480.00
Hernandez, Raquel, W,139974586.350.000.002071.422514.93
Gonzalez, Virginia,119294965.780.003374.990.001590.79
Adams, Sydney,2736769.990.000.000.0069.99
Sanders, Kaylee, C,202216035.600.003578.270.002457.33
Mrs., Nara, Barbara,12704217.460.000.000.00217.46
Watson, Anna,202386021.620.003578.270.002443.35
Nath, Latoya, A,27582561.920.000.000.00561.92
Xylaras, Ioannis,202155279.260.003578.270.001700.99
Kumar, Luke,241612983.340.000.002443.35539.99
Gill, Carolyn,2309467.930.000.000.0067.93
Navarro, Rodney, L,293092419.060.000.000.002419.06
Sai, Frederick,209914118.260.003578.270.00539.99
Hernandez, Wendy, A,15124122.440.000.000.00122.44
Gomez, Erik, T,291802452.040.000.000.002452.04
Shan, Bridget,2933839.980.000.000.0039.98
Carlson, Lance, E,228564.990.000.000.004.99
Sai, Kari, E,1423183.970.000.0024.9958.98
Deng, Colin, B,1829932.220.000.000.0032.22
Liu, Omar, L,122523938.950.003374.990.00563.96
Martin, Diane,139586838.640.000.002049.104789.54
Nara, Yolanda,29080777.340.000.000.00777.34
Goel, Jodi,204476035.600.003578.270.002457.33
Suri, Stanley, J,2749642.280.000.000.0042.28
Gutierrez, Micheal, S,272991322.980.000.00782.99539.99
Gill, Kristine,199776044.590.003578.270.002466.32
Shen, Katie, A,202835314.250.003578.270.001735.98
Hu, Cara,206086035.600.003578.270.002457.33
Gao, Curtis, D,204295377.750.003578.270.001799.48
Sharma, Donna,119986962.100.003374.991249.842337.27
Shen, Alisha, J,264381938.470.000.00782.991155.48
Pal, Kara,249162169.900.000.001000.441169.46
Shan, Carl, D,249192212.890.000.001000.441212.45
Cai, Amy,249202155.920.000.001000.441155.48
McDonald, Brent,1406877.270.000.000.0077.27
Martinez, Heidi, L,2292268.970.000.000.0068.97
Arun, Brenda,136306824.730.000.002071.424753.31
Kapoor, Jay, F,219564632.860.002181.560.002451.30
Yuan, Calvin,1790525.480.000.000.0025.48
Cook, Victoria, J,206206044.590.003578.270.002466.32
Diaz, Devin, D,15829187.980.000.000.00187.98
Raje, Jenny,2023369.970.000.000.0069.97
Xu, Kara, E,2221239.990.000.000.0039.99
Chandra, Tina, S,139745237.730.000.002071.423166.31
Ashe, Barbara,1873424.270.000.000.0024.27
Fernandez, Arthur, J,223992785.050.000.002181.56603.49
Dominguez, Leslie,273461390.950.000.00782.99607.96
Henderson, Isabella, L,2198175.970.000.000.0075.97
Stone, Mitchell,2501369.970.000.000.0069.97
Wood, Jacqueline,1670597.960.000.000.0097.96
Guo, Autumn, A,1421386.260.000.000.0086.26
Carlson, Briana,264361957.470.000.00782.991174.48
Patel, Summer, G,267531957.470.000.00782.991174.48
Zhu, Roger, J,280981249.840.000.000.001249.84
Blanco, Jimmy, V,14013138.450.000.000.00138.45
Perez, Stefanie,27518123.980.000.000.00123.98
Goel, Bradley,1580366.260.000.000.0066.26
Yuan, Roger,1962261.750.000.000.0061.75
Lal, Corey, H,233132906.030.000.002181.56724.47
Lu, Willie,211914169.330.002443.350.001725.98
Flores, Katherine,211803882.550.002181.560.001700.99
Li, Alvin,267641938.470.000.00782.991155.48
Prasad, Ebony,243683946.520.000.002181.561764.96
Raji, Warren, J,267961957.470.000.00782.991174.48
Madan, Candace,224092746.040.000.002181.56564.48
Sanz, Lance,225732721.550.000.002181.56539.99
Luo, Devon, D,228504657.510.000.002181.562475.95
Zheng, Alisha,222034624.910.000.002181.562443.35
Cai, Karen,225722997.320.000.002443.35553.97
Shen, Kelvin,224063018.330.000.002443.35574.98
Ruiz, Krista, C,130816772.150.000.002049.104723.05
Lu, Valerie,229134684.390.000.002181.562502.83
Guo, Jon,229273913.820.000.002181.561732.26
Tang, Latoya, F,229103882.550.000.002181.561700.99
Torres, Kellie,19569112.240.000.000.00112.24
Moreno, Melody, R,11760274.920.000.000.00274.92
Carlson, Billy, C,19667150.950.000.000.00150.95
Nelson, Mary, L,131075650.900.000.002049.103601.80
Mehta, Levi, M,131105583.940.000.002049.103534.84
Becker, Gregory, M,131046894.440.000.002071.424823.02
Shen, Kelsey, R,229214647.880.000.002181.562466.32
Wilson, Edward, L,265621925.410.000.00782.991142.42
Muñoz, Pedro, A,234333882.550.000.002181.561700.99
Shen, Tamara, G,229353951.520.000.002181.561769.96
Munoz, Kendra, S,235293617.830.000.003617.830.00
Kapoor, Bryant,229463911.530.000.003911.530.00
Rubio, Derrick, P,235253302.050.000.002181.561120.49
Nelson, Carol,135204551.360.000.004551.360.00
Li, Ramon,2124834.980.000.000.0034.98
Kumar, Tonya, A,229344173.320.000.002443.351729.97
Chapman, Pamela, L,2714535.000.000.000.0035.00
Ramos, Joy,131296823.150.000.002049.104774.05
Gonzalez, Tabitha, A,2613639.980.000.000.0039.98
Pal, Derek,2459158.980.000.000.0058.98
Kumar, Shawna, L,1908578.260.000.000.0078.26
Chen, Randy,13004190.270.000.000.00190.27
Kapoor, Phillip,27581539.990.000.000.00539.99
Raje, Grant, S,241623004.830.000.002443.35561.48
Alvarez, Erik, M,14311138.450.000.0074.4863.97
Luo, Kenneth, S,152112910.900.000.002071.42839.48
Davis, Nicole,2295739.980.000.000.0039.98
Kumar, Bridget,158024444.070.000.002049.102394.97
Martin, Briana, L,152132818.590.000.002049.10769.49
Lopez, Toni, K,2514021.490.000.000.0021.49
Carlson, Marie,29311603.960.000.000.00603.96
Zimmerman, Candice, J,267541938.470.000.00782.991155.48
Suarez, Hector, L,15034103.450.000.000.00103.45
Malhotra, Meredith,29314564.480.000.000.00564.48
Goel, Chad,2821939.980.000.000.0039.98
Lopez, Edgar, O,1734681.460.000.000.0081.46
Perez, Joe, A,143265207.700.000.002071.423136.28
Li, Jake, L,1958397.960.000.000.0097.96
Yang, Crystal, A,236654207.320.000.002443.351763.97
Yuan, Keith, N,229263936.540.000.002181.561754.98
Lee, Richard, I,239962744.520.000.002181.56562.96
Lu, Sandra, N,135214514.770.000.004514.770.00
Butler, Katherine, F,267601322.980.000.001322.980.00
Prasad, Cesar,234113577.820.000.003577.820.00
Ross, Arianna, E,267741331.970.000.001331.970.00
Xu, Sharon, A,233443882.550.000.002181.561700.99
Serrano, Mallory, E,267511903.480.000.00782.991120.49
Lin, Damien, L,234143391.030.000.003391.030.00
Kumar, Tommy,17297100.250.000.0037.2762.98
Wu, Brittney,234183400.020.000.003400.020.00
Serrano, Anne,242443617.830.000.002443.351174.48
Lewis, Jasmine,139646806.450.000.002071.424735.03
Li, Cara,275871145.480.000.000.001145.48
Anand, Tamara,29088756.330.000.000.00756.33
Nara, Calvin, J,1136786.260.000.000.0086.26
Blanco, Ricky, F,1660667.170.000.000.0067.17
Shen, Brendan, L,143053652.200.000.002049.101603.10
Yuan, Maurice,243804.990.000.000.004.99
Arun, Ross, C,236583936.540.000.002181.561754.98
Anderson, Richard, G,249242143.900.000.001000.441143.46
Alvarez, Randall,267501938.470.000.00782.991155.48
Raman, Jay, M,136186763.150.000.002049.104714.05
Yuan, Carl, P,241603046.840.000.002443.35603.49
She, Jessie, A,136506768.140.000.002049.104719.04

Generated 2024-11-10 05:14:55.122 UTC