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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Sanz, Ricky,182516035.600.003578.272457.330.00
Diaz, Aaron, C,186956029.570.003578.272451.300.00
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
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
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
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
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
She, Rosa,189316060.500.003578.272482.230.00
Ma, Lacey, K,187235279.260.003578.271700.990.00
Garcia, Dalton, M,187685314.250.003578.271735.980.00
Jai, Katrina,1304459.980.000.000.0059.98
Moreno, Leslie, C,11114122.890.000.007.95114.94
Deng, Colin, B,1829932.220.000.000.0032.22
Goel, Bethany,27511548.980.000.000.00548.98
Sanchez, Patrick, W,24382143.780.000.000.00143.78
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
Yang, Shannon,120018113.010.003374.992318.962419.06
Blanco, Marc,249082155.920.000.002155.920.00
Martin, Justin,235423337.040.000.003337.040.00
Deng, Jodi,161612700.050.000.002049.10650.95
Pal, Jenny,15132151.940.000.000.00151.94
Chandra, Harold, K,1723686.270.000.000.0086.27
Zeng, Tiffany, B,2189039.990.000.000.0039.99
Martinez, Heidi, L,2292268.970.000.000.0068.97
Ramos, Roberto, M,13159208.180.000.000.00208.18
Yuan, Willie,234214208.310.000.002443.351764.96
Arun, Brenda,136306824.730.000.002071.424753.31
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
Ortega, Gloria, R,195586029.570.003578.272451.300.00
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
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
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
Zimmerman, Krystal,1722877.270.000.000.0077.27
Suarez, Meredith,150323800.080.000.002049.101750.98
Sullivan, Carla, A,206116021.620.003578.270.002443.35
Yuan, Alicia,252252129.920.000.001000.441129.48
Lal, Corey, H,233132906.030.000.002181.56724.47
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
Munoz, Shannon, S,2912249.970.000.000.0049.97
Sanchez, Abby, J,199666021.620.003578.270.002443.35
Johnsen, Ross,19618119.450.000.000.00119.45
Ramirez, Olivia, D,197856076.610.003578.270.002498.34
Garcia, George,201604237.220.003578.27658.950.00
Blanco, Rodney, A,201584153.250.003578.27574.980.00
Carlson, Philip, P,119158143.000.003374.992369.962398.05
Andersen, Warren,119198171.520.003374.990.004796.53
Suri, Lydia,131266815.080.000.002049.104765.98
Chande, Katrina, L,199686021.620.003578.270.002443.35
Reed, Riley, A,201574118.260.003578.27539.990.00
She, Valerie, C,202266067.200.003578.270.002488.93
Xu, Jessie, R,27517539.990.000.000.00539.99
Mr., Rodgers, Scott, M.,202115333.250.003578.270.001754.98
Raji, Dawn, C,202446021.620.003578.270.002443.35
Yuan, Marshall, P,199786060.500.003578.270.002482.23
Harrison, Colleen, L,202196044.590.003578.270.002466.32
Sanders, Kaylee, C,202216035.600.003578.270.002457.33
Moreno, Dana, D,150333797.400.000.002071.421725.98
Rana, Meagan, M,119148165.960.003374.992329.982460.99
Rodriguez, Rachael, M,119444776.270.003374.99609.96791.32
Raje, Bonnie,206296060.500.003578.270.002482.23
Xu, Randy, S,119698173.020.003399.992319.992453.04
Shan, Colin,259211253.070.00699.100.00553.97
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
Jai, Kathryn,235463337.040.000.003337.040.00
Gill, Kristine,199776044.590.003578.270.002466.32
Carlson, Wendy,202206060.500.003578.270.002482.23
Sai, Rachael,119128095.320.003374.990.004720.33
Mehta, Evelyn, S,204204132.240.003578.27553.970.00
Perez, Johnathan, D,204264139.750.003578.27561.480.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
Suri, Jarrod, E,120048114.040.003374.992319.992419.06
Gomez, Mallory, R,248987.280.000.007.280.00
Jenkins, Noah, A,2437913.980.000.0013.980.00
Shan, Johnny,119997043.270.003399.991308.312334.97
Wang, Rosa, I,119938131.320.003374.990.004756.33
Anand, Alícia, J,291132453.040.000.002453.040.00
Chande, Tonya,119928123.030.003399.990.004723.04
Blanco, Jésus, E,204486044.590.003578.270.002466.32
Wu, Laura,206156060.500.003578.270.002482.23
Ortega, Lawrence,14685146.740.000.000.00146.74
Vazquez, Mallory, M,18283119.950.000.000.00119.95
Li, Gilbert,239992730.540.000.002181.56548.98
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
Xie, Kelli, J,204526156.700.003578.270.002578.43
Serrano, Kristi,206166093.200.003578.270.002514.93
Ma, Autumn,209944191.720.003578.27613.450.00
Yuan, Deborah,120214043.460.003399.990.00643.47
Sai, Frederick,209914118.260.003578.27539.990.00
Rubio, Sabrina, A,209844153.250.003578.27574.980.00
Sara, Cassandra, D,209894148.740.003578.27570.470.00
Liang, Gilbert,122423948.970.003374.990.00573.98
Perez, Molly,259411255.360.00699.100.00556.26
Cook, Victoria, J,206206044.590.003578.270.002466.32
Rana, Meredith,250322184.900.000.001000.441184.46
Johnston, Tamara, H,18492218.260.000.000.00218.26
Srini, Douglas, M,1673335.260.000.000.0035.26
Lin, Claudia, A,14312191.270.000.00166.2824.99
Huang, Mandy,1826672.260.000.000.0072.26
Vance, Denise, L,212054886.700.002443.350.002443.35
Munoz, Robyn,142145759.870.000.002049.103710.77
Chandra, Arthur, L,140326859.430.000.002071.424788.01
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
Hernandez, Logan,123506791.750.002071.422319.992400.34
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
Serrano, Lori,17066105.750.000.000.00105.75
Garcia, Monica, D,2026749.970.000.000.0049.97
Nath, Kara, S,2117739.990.000.000.0039.99
Guo, Brent, J,259451248.080.00699.100.00548.98
Powell, Rachel,208184230.730.003578.27652.460.00
Nath, Ricardo, C,120398213.000.003374.992394.462443.55
Hernandez, Philip,211933905.520.002181.560.001723.96
Yuan, Lacey, W,123496772.140.002049.102329.982393.06
Lu, Willie,211914169.330.002443.350.001725.98
Raman, Ruth, L,211994144.340.002443.350.001700.99
Lopez, Barry, R,260201932.460.00782.990.001149.47
He, Louis, E,212114900.680.002443.350.002457.33
Ruiz, Gloria,123435567.930.002049.101223.842294.99
She, Corey, T,212144659.900.002181.560.002478.34
Becker, Kara,211674657.510.002181.560.002475.95
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
Sanz, Lawrence, M,140306905.470.000.002071.424834.05
Fernandez, Rachael, M,239933072.320.000.002443.35628.97
Subram, Kristi, N,15025128.940.000.000.00128.94
Hu, Susan,252422120.930.000.001000.441120.49
Blanco, Alberto, R,278672443.550.000.000.002443.55
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
Cai, Willie, S,259601957.470.00782.990.001174.48
Nara, Tara,211943911.530.002181.560.001729.97
Gomez, Sheila, J,211654673.880.002181.560.002492.32
Subram, Evelyn, S,212574144.340.002443.350.001700.99
Goel, Bridget,261341926.450.00782.990.001143.46
Jai, Michele, E,212254732.860.002181.560.002551.30
Shen, Shaun,126846893.080.002049.100.004843.98
Chen, Autumn, I,214084624.910.002181.560.002443.35
Ma, Brittney,125842633.390.002071.420.00561.97
Smith, Christian, L,14313222.440.000.000.00222.44
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
Chen, Alisha, J,142255603.920.000.002049.103554.82
Li, Ramon,2124834.980.000.000.0034.98
Chapman, Pamela, L,2714535.000.000.000.0035.00
Kumar, Shawna, L,1908578.260.000.000.0078.26
Anand, Alison, J,240092746.040.000.002181.56564.48
Kapoor, Phillip,27581539.990.000.000.00539.99
Lal, Cristina, M,146712934.370.000.002071.42862.95
Shan, Tony, M,1617531.270.000.000.0031.27
Blanco, Sheila, I,1772436.960.000.000.0036.96
Coleman, Nicole, A,215584919.300.002443.350.002475.95
Chow, Christy, M,126816784.130.002049.100.004735.03
Jai, Latoya, S,212294198.330.002443.350.001754.98
Fernandez, Kristina, A,125812646.400.002071.420.00574.98
Luo, Michele,260271938.470.00782.990.001155.48
Nara, Cedric, M,218754921.690.002443.350.002478.34
Gonzalez, Ruth,126936820.470.002071.420.004749.05
Sanchez, Candace, L,215674973.280.002443.350.002529.93
Navarro, Sheila, L,218894624.910.002181.560.002443.35
Yang, Darryl, K,215714624.910.002181.560.002443.35

Generated 2024-09-19 21:26:52.887 UTC