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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Zhu, Christy,110038139.293399.990.004739.300.00
Raji, Misty,165204727.743578.270.001149.470.00
Gonzales, Logan,166075897.533578.270.000.002319.26
Pal, Casey,165224698.763578.270.001120.490.00
Torres, Ruben,110028114.043399.990.004714.050.00
Arun, Cory, O,165274752.753578.270.000.001174.48
Fernandez, Manuel, A,165144761.743578.270.001183.470.00
Liang, Kelvin, L,166165915.543578.270.000.002337.27
Wang, Shannon,110176434.313374.990.002316.97742.35
Huang, Damien,165244733.753578.270.001155.480.00
Zhao, Jessie, R,110276591.573399.990.000.003191.58
Zhang, Warren, L,252521893.05699.100.000.001193.95
Lal, Dustin, A,164844175.533578.270.000.00597.26
Moreno, Jimmy, L,110296565.293399.990.002408.97756.33
Ramos, Francis,163454173.243578.270.000.00594.97
She, Tonya, L,165214698.763578.270.001120.490.00
Sai, Harold,110266575.793399.990.002399.47776.33
Chander, Yolanda,165194752.753578.270.001174.480.00
Sutton, Jaime, L,166305973.243578.270.000.002394.97
Stewart, Ariana,167436070.593578.270.002492.320.00
Jimenez, Gary, E,16609344.040.000.00344.040.00
Yang, Todd, J,190946021.620.003578.272443.350.00
Sanchez, Terrance,19584116.740.000.00116.740.00
Wu, Kelvin,2459561.960.000.0061.960.00
Gray, Faith,2291459.980.000.0059.980.00
Madan, Toni,26668119.980.000.00119.980.00
Ramos, Briana, J,143033636.910.000.002894.56742.35
Ramos, Joe,123536765.460.002071.422309.972384.07
Chapman, Kathryn,119888078.020.003374.992309.972393.06
Gao, Stacey,166624355.713578.270.00777.440.00
Andersen, Tonya, N,135274529.040.000.002049.102479.94
Gonzalez, Ebony,110346491.323399.990.000.003091.33
Sharma, Terrence, N,173516117.693578.270.000.002539.42
Romero, Lawrence, C,166876070.593578.270.002492.320.00
West, Colleen, C,131286817.140.000.002049.104768.04
Lu, Suzanne, K,167124417.753578.270.00839.480.00
Zeng, Claudia, M,166964506.763578.270.00928.490.00
Munoz, Theresa, M,139536840.750.000.002071.424769.33
Romero, Renee, E,166395908.253578.270.000.002329.98
Hernandez, Diana, F,110386437.333374.990.000.003062.34
Perez, Joel,166844158.243578.270.000.00579.97
Sanchez, Denise,167036090.593578.270.002512.320.00
Rodriguez, Monica, J,289519.990.000.000.009.99
Zheng, Laura,167014426.743578.270.00848.470.00
Patel, Monica, J,252342174.920.000.001000.441174.48
Andersen, Carl, J,110578088.043374.990.002319.992393.06
Diaz, Briana,131316737.150.000.002049.104688.05
Lu, Krystal,170494347.763578.270.000.00769.49
Henderson, Xavier, K,1299396.250.000.0039.9856.27
Liu, Autumn, J,209854118.260.003578.27539.990.00
Clark, Sydney,1661067.580.000.0067.580.00
Ruiz, Bruce, W,16171103.860.000.00103.860.00
Lal, Karla,2521939.980.000.0039.980.00
Coleman, Melanie, H,1563934.570.000.002.2932.28
Jimenez, Jacquelyn,143043595.930.000.002818.59777.34
Cai, Cedric,195596056.610.003578.272478.340.00
Martinez, Manuel, J,158322611.410.000.002611.410.00
Ma, Cedric, W,11094157.930.000.0029.98127.95
Chande, Dale, K,172424387.233578.270.000.00808.96
Diaz, Marc,110588248.023399.990.002374.982473.05
Moore, Michael,172474432.723578.270.000.00854.45
Rana, Darren, M,172574480.733578.270.000.00902.46
Luo, Dustin,172404385.033578.270.000.00806.76
Rubio, Randall, M,172866029.573578.270.000.002451.30
Sanchez, Troy, H,255591253.07699.100.000.00553.97
Flores, Noah,172564362.743578.270.000.00784.47
Torres, Dwayne, R,172884426.243578.270.000.00847.97
Luo, Casey,110728194.003399.990.002395.962398.05
Butler, Jason,175104369.743578.270.000.00791.47
Nelson, Julia, L,11102102.910.000.000.00102.91
Zheng, Jeffery, W,150303786.390.000.002071.421714.97
Zhou, Cedric,175144142.233578.270.00563.960.00
Chander, Damien,110808204.023374.990.002359.982469.05
Navarro, Latasha, L,111008172.513374.990.002399.472398.05
Hernandez, Bruce,179194733.753578.270.000.001155.48
Goel, Drew,173526021.623578.270.000.002443.35
Jackson, Eduardo, C,1174939.970.000.0039.970.00
Williams, Anna, R,175044362.743578.270.000.00784.47
Patel, Douglas,179274726.043578.270.000.001147.77
Martin, Renee, L,174784758.243578.270.000.001179.97
Zeng, Ernest, M,12992158.510.000.0036.27122.24
Zeng, Suzanne,179184733.753578.270.000.001155.48
Sun, Shannon,120077023.780.003399.991283.822339.97
Raji, Willie, T,110708165.553399.990.002345.222420.34
Jimenez, Felicia, L,110758068.033374.990.002294.992398.05
Xu, Lacey, S,179134733.753578.270.000.001155.48
Griffin, Caroline,177264721.733578.270.000.001143.46
Townsend, Larry, D,111344911.833399.990.000.001511.84
Jordan, Ross, F,111248129.023399.990.002309.972419.06
Lopez, Adriana, A,120028145.330.003374.992357.282413.06
Chapman, Patricia,120377107.100.003374.991249.842482.27
Sanz, Larry,14067114.960.000.0049.9964.97
Huang, Jake,1958995.260.000.0062.9832.28
Raman, Mayra, P,209904196.220.003578.27617.950.00
Jai, Clayton,123396865.460.002071.422374.982419.06
Shan, Keith, T,209964149.990.003578.27571.720.00
Gomez, Alfredo, C,182004150.533578.270.000.00572.26
Raji, Lindsey,182056056.613578.270.002478.340.00
Kumar, Louis, A,182034172.253578.270.000.00593.98
Fernandez, Candace,111058095.990.003399.992294.992401.01
Xie, Karla,182014157.730.003578.270.00579.46
Goel, Misty, M,182456021.620.003578.270.002443.35
Chapman, Preston, O,182686102.190.003578.270.002523.92
Gonzalez, Phillip, N,182076089.590.003578.272511.320.00
Xu, Cedric,181984143.250.003578.270.00564.98
Chande, Lindsay,182446021.620.003578.272443.350.00
Martin, Larry,182546021.620.003578.272443.350.00
Gomez, Felicia, J,182196038.560.003578.272460.290.00
Moreno, Pedro, A,182486037.890.003578.272459.620.00
Moore, Natalie, W,182736104.210.003578.272525.940.00
Sanz, Ricky,182516035.600.003578.272457.330.00
Diaz, Aaron, C,186956029.570.003578.272451.300.00
Alonso, Ricky, S,140705618.930.000.003298.942319.99
Munoz, Diane, R,15795132.440.000.00132.440.00
Raje, Casey, A,14686203.460.000.0059.98143.48
Henderson, Marcus, D,1521268.960.000.004.9963.97
Chander, Alejandro, M,2445575.470.000.0075.470.00
She, Bridget, M,195575358.240.003578.271779.970.00
Martin, Randall, B,195606117.690.003578.272539.420.00
Raman, Frederick, F,289429.990.000.009.990.00
She, Rosa,189316060.500.003578.272482.230.00
Yang, Shannon,120018113.010.003374.992318.962419.06
Blanco, Marc,249082155.920.000.002155.920.00
Martin, Justin,235423337.040.000.003337.040.00
Suarez, Ricky,29066539.990.000.000.00539.99
Hu, Amy,14320261.950.000.000.00261.95
Cai, Susan,19101104.420.000.000.00104.42
Beck, April,143025140.730.000.002071.423069.31
Lal, Barbara, W,231012795.010.000.002181.56613.45
Jackson, Joshua,1723583.980.000.000.0083.98
Morris, Eduardo,19619112.750.000.0088.9723.78
Coleman, Jocelyn,206066054.220.003578.270.002475.95
Shen, Gilbert, C,120056984.810.003399.991214.852369.97
Raji, Tasha, T,1705732.280.000.0032.280.00
Srini, Kristopher, A,2399739.980.000.0039.980.00
Carlson, Krista,28209574.980.000.00574.980.00
Suri, Erick,1663538.880.000.0038.880.00
Xie, Kurt, A,14344126.950.000.0063.9762.98
Diaz, Ricky, E,183356035.600.003578.270.002457.33
Kim, Kari, S,114458098.030.003399.992304.982393.06
Griffin, Grace,114438235.000.003374.992440.952419.06
Black, Mindy, W,186966149.570.003578.272571.300.00
Prasad, Jarrod,113594960.070.003374.990.001585.08
Gonzalez, Michele, D,184916056.610.003578.272478.340.00
Patterson, Kyle,114488132.010.003374.992318.962438.06
Ye, Ramon,113574943.800.003374.990.001568.81
Nara, Sharon,184826030.610.003578.272452.340.00
Sharma, Misty,257081253.070.00699.100.00553.97
Alvarez, Gloria, B,182976119.590.003578.272541.320.00
Xie, Wayne, S,183026029.570.003578.272451.300.00
Chen, Clarence, R,1514797.450.000.0037.9759.48
Prasad, Gerald, B,1203581.240.000.0078.952.29
Hernandez, Melody, E,28212619.460.000.00619.460.00
Hu, Omar, S,289542393.060.000.002393.060.00
Ortega, Gloria, R,195586029.570.003578.272451.300.00
Alvarez, Max, M,119868245.230.003399.992392.202453.04
Vazquez, Marvin, K,2195335.000.000.0035.000.00
Dominguez, Kellie, E,1724486.270.000.0053.9932.28
Carlson, Armando,17484126.960.000.00126.960.00
Sara, Marco, L,1564196.750.000.0096.750.00
Sharma, Corey, M,17495119.910.000.0056.9762.94
Sullivan, Henry, L,2060323.780.000.0023.780.00
Young, Marcus, A,184946037.890.003578.272459.620.00
Zheng, Claudia,186916070.590.003578.272492.320.00
Sanz, Ross,114558142.030.003374.992319.992447.05
Alvarez, Reginald, A,187466135.090.003578.272556.820.00
Chavez, Jodi, A,189096035.600.003578.272457.330.00
Anand, Katrina, L,187265314.250.003578.271735.980.00
Rubio, Erika, A,114528183.040.003374.992414.992393.06
Ashe, Tara, J,190936035.600.003578.272457.330.00
Torres, Mathew, L,189004132.240.003578.27553.970.00
Gomez, Andy,187215333.250.003578.271754.980.00
Lin, Laura, L,114628116.330.003374.992322.282419.06
Zeng, Louis,189034143.740.003578.27565.470.00
Ma, Lacey, K,187235279.260.003578.271700.990.00
Garcia, Dalton, M,187685314.250.003578.271735.980.00
Jai, Kathryn,235463337.040.000.003337.040.00
Travers, Jimmy, V,126746829.470.002071.422319.992438.06
She, Colin, M,1513959.980.000.0059.980.00
Sun, Aimee, R,1831960.470.000.0060.470.00
Gomez, Mallory, R,248987.280.000.007.280.00
Jenkins, Noah, A,2437913.980.000.0013.980.00
Anand, Alícia, J,291132453.040.000.002453.040.00
Hu, Leah,119948169.030.003374.992374.982419.06
Yang, Kevin, F,2060584.960.000.0084.960.00
Suarez, Dana, M,235413337.040.000.003337.040.00
Yuan, Ricardo,1667476.150.000.0037.2738.88
Dominguez, Kristi, M,136446864.460.000.002071.424793.04
Sanz, Reginald, K,1752274.950.000.000.0074.95
Malhotra, Darren, L,202456085.590.003578.270.002507.32
Xu, Arturo,136196808.100.000.002049.104759.00
Jimenez, Victor,114618089.040.003374.992294.992419.06
Arthur, Tammy, L,213634.990.000.004.990.00
Ramos, Gloria, A,213657.280.000.007.280.00
Shen, Devon, G,2735878.980.000.0078.980.00
Sara, Cassandra, D,209894148.740.003578.27570.470.00
Sai, Frederick,209914118.260.003578.27539.990.00
Hernandez, Logan,123506791.750.002071.422319.992400.34
Suri, Jarrod, E,120048114.040.003374.992319.992419.06
Li, Justin,1412457.590.000.0032.6024.99
Gomez, Erik, T,291802452.040.000.002452.040.00
Wood, Maria,126676813.120.002049.102344.962419.06
Sara, Tabitha, W,257151274.080.00699.100.00574.98
Gao, Edwin,257161302.590.00699.100.00603.49
He, Brent, R,257121262.060.00699.100.00562.96
Garcia, Ruben,196136093.200.003578.270.002514.93
Saunders, Patricia, J,195655308.240.003578.270.001729.97
Powell, Kaitlyn,195985310.530.003578.270.001732.26
Gutierrez, Lawrence, M,195645293.240.003578.270.001714.97
Gao, Krystal,258211879.070.00699.100.001179.97
Rana, Carla, K,195935306.540.003578.270.001728.27
Raje, Arturo, C,1422849.990.000.0049.990.00
Carlson, Francis,273401350.750.000.001350.750.00
Li, Glenn, A,292952384.070.000.002384.070.00
Gomez, Gary,1564034.570.000.0034.570.00
Zhou, Brent,1543432.280.000.0029.992.29
Navarro, Mallory,243653331.030.000.003331.030.00
Dominguez, Joy,221753018.330.002443.35574.980.00
Sun, Jamie,213892770.520.002181.56588.960.00
Pal, Alvin, C,293192447.050.000.002447.050.00
Foster, Luke,15137161.940.000.00161.940.00
Shen, Cedric,2220974.980.000.0074.980.00
Serrano, Hector, K,28308588.960.000.00588.960.00
Martinez, Cynthia,221702745.330.002181.56563.770.00
Pal, Tamara,126896846.920.002071.422331.952443.55
Dominguez, Robyn, P,233057.280.000.007.280.00
Hu, Krystal, D,130127017.440.002071.422493.982452.04
Lu, Roger, F,197634153.250.003578.27574.980.00
Torres, Sebastian, V,258311882.570.00699.100.001183.47
Martinez, Holly, B,196286035.600.003578.272457.330.00
Nath, Louis, C,258301833.570.00699.100.001134.47
Patel, Toni, E,258291894.070.00699.100.001194.97
Gonzalez, Tina,196535314.250.003578.270.001735.98
She, Nichole, M,119098105.310.003374.992297.282433.04
Mr., Spencer, Phil,199606120.110.003578.270.002541.84
Lopez, Jay, A,199656056.610.003578.270.002478.34
Carlson, Byron,119008257.010.003399.992374.982482.04
Raji, Kate, L,119038108.040.003374.992294.992438.06
Carlson, Robin,197866021.620.003578.272443.350.00
Hu, Kristen, C,197886056.610.003578.270.002478.34
Ruiz, Danny,2445621.490.000.000.0021.49
Zhu, Jamie, J,1314069.990.000.000.0069.99
Smith, Allen,1407274.980.000.000.0074.98
Ma, Christy,1502040.260.000.000.0040.26
Perez, Carmen, C,131396854.450.000.002071.424783.03
Scott, Alex, T,143482989.380.000.002071.42917.96
Beck, Cedric, L,2240369.990.000.0069.990.00
Perez, Dominique,1234468.700.000.0044.2124.49
Kumar, Ricardo, K,141333764.070.000.003764.070.00
Guo, Autumn, A,1421386.260.000.0058.9827.28

Generated 2024-09-19 16:12:38.157 UTC