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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Gomez, Ricky,187376021.620.003578.272443.350.00
Suri, Toni,184644698.760.003578.270.001120.49
Schmidt, Shane,179224821.720.003578.270.001243.45
Deng, Tasha,114598141.330.003399.992322.282419.06
Xie, Wayne, S,183026029.570.003578.272451.300.00
Lin, Bianca,111078171.010.003374.992376.962419.06
Ortega, Linda, C,117568078.020.003374.990.004703.03
Gill, Byron, J,184836056.610.003578.272478.340.00
Sai, Cesar,182436058.210.003578.272479.940.00
Liu, Susan,187186035.600.003578.270.002457.33
Malhotra, Emmanuel,183324752.750.003578.270.001174.48
Huang, Brent,182206021.620.003578.272443.350.00
Navarro, Kathleen, J,192694118.260.003578.27539.990.00
Chavez, Jodi, A,189096035.600.003578.270.002457.33
Gomez, Randall, R,117628228.010.003399.992389.962438.06
Liu, Glenn,188994118.260.003578.27539.990.00
Sanz, Marvin,196126029.570.003578.270.002451.30
Xie, Ricardo,187106098.580.003578.272520.310.00
Liu, Alejandro, R,195556110.600.003578.270.002532.33
Torres, Mathew, L,189004132.240.003578.27553.970.00
Dominguez, Stacy, S,191056056.610.003578.270.002478.34
Malhotra, Stanley, H,114538176.980.003374.992382.932419.06
Suarez, Alfredo,196015314.250.003578.270.001735.98
Lin, Laura, L,114628116.330.003374.992322.282419.06
Perez, Martin,195776037.890.003578.270.002459.62
Gutierrez, Jaime, C,114578211.480.003374.992359.962476.53
Lu, Roger, F,197634153.250.003578.27574.980.00
Dominguez, Theresa, L,187695304.250.003578.270.001725.98
Deng, Devon, H,199676029.570.003578.270.002451.30
Chen, Steve, R,189024186.230.003578.27607.960.00
Hill, Alex, C,197876054.220.003578.270.002475.95
Parker, Evan, R,187295333.250.003578.271754.980.00
Liu, Clarence,197976021.620.003578.270.002443.35
Ma, Lacey, K,187235279.260.003578.271700.990.00
Torres, Marc,117658143.030.003374.992294.992473.05
Sara, Tabitha, W,257151274.080.00699.100.00574.98
Chander, Dustin,118958149.040.003374.990.004774.05
Gao, Edwin,257161302.590.00699.100.00603.49
Gutierrez, Ricky,197736056.610.003578.270.002478.34
Navarro, Melinda,114548089.040.003374.992294.992419.06
Liu, Darryl,199476056.510.003578.270.002478.24
Suri, Douglas,190966090.590.003578.270.002512.32
Smith, Tina, K,197936056.610.003578.270.002478.34
Martin, Randall, B,195606117.690.003578.270.002539.42
Fernandez, Geoffrey,199636054.220.003578.270.002475.95
Powell, Kaitlyn,195985310.530.003578.270.001732.26
Mr., Spencer, Phil,199606120.110.003578.270.002541.84
Gonzalez, Kristopher, C,192644132.240.003578.27553.970.00
Sanchez, Abby, J,199666021.620.003578.270.002443.35
Serrano, Orlando,195616021.620.003578.270.002443.35
Anand, Niñia, L,199496054.220.003578.270.002475.95
Hill, Mackenzie,195766058.210.003578.270.002479.94
Malhotra, Darren, L,202456085.590.003578.270.002507.32
Ortega, Gloria, R,195586029.570.003578.270.002451.30
Rana, Joe, D,119168178.510.003374.992405.472398.05
Martinez, Terrance,257181274.080.00699.100.00574.98
Chande, Katrina, L,199686021.620.003578.270.002443.35
Jai, Alvin,195995279.260.003578.270.001700.99
Sharma, Alvin, M,195866056.610.003578.270.002478.34
Martinez, Meredith, M,190956056.610.003578.270.002478.34
Deng, Sheena,190996038.560.003578.270.002460.29
Gao, Krystal,258211879.070.00699.100.001179.97
She, Bridget, M,195575358.240.003578.270.001779.97
Madan, Ronald,258281873.580.00699.100.001174.48
Ramirez, Isaiah,119058155.980.003374.990.004780.99
Ashe, Orlando, I,118978203.020.003399.990.004803.03
Ortega, Danny, K,197946098.580.003578.270.002520.31
Carlson, Orlando, J,118938123.030.003374.992319.992428.05
Nath, Louis, C,258301833.570.00699.100.001134.47
Perez, Brenda,118998189.500.003374.992395.452419.06
Alonso, Gloria, S,199646056.610.003578.270.002478.34
Jai, Tasha, A,197714167.230.003578.27588.960.00
Ramos, Jessie, R,117648129.020.003399.990.004729.03
Wu, Amy,197906089.590.003578.270.002511.32
Hu, Lacey,199486021.620.003578.270.002443.35
Henderson, Angela, T,118988179.030.003399.990.004779.04
Cook, Kaylee,119048214.500.003399.990.004814.51
Raman, Candace, M,117668280.480.003399.992419.462461.03
Tang, Rafael, A,119088079.050.003374.992319.992384.07
Lopez, Jay, A,199656056.610.003578.270.002478.34
Hu, Kristen, C,197886056.610.003578.270.002478.34
Vazquez, Andy,196205279.260.003578.270.001700.99
Gonzalez, Ann,118948223.000.003374.992394.972453.04
Garcia, Sarah,119078135.330.003399.992297.282438.06
Tang, Shawn,258321850.860.00699.100.001151.76
Blanco, Rodney, A,201584153.250.003578.27574.980.00
Carlson, Philip, P,119158143.000.003374.992369.962398.05
Lopez, Kristina, L,202476056.610.003578.270.002478.34
Ms., Robinson, Dorothy, B.,119528169.000.003374.992395.962398.05
Thomas, Christopher, M,202426068.450.003578.270.002490.18
Mehta, Cesar, J,202415347.230.003578.270.001768.96
Liu, Trisha, V,202145304.250.003578.270.001725.98
Zheng, Jenny, R,119474747.300.003374.99629.96742.35
Mr., Rodgers, Scott, M.,202115333.250.003578.270.001754.98
Sharma, Tony,182416058.210.003578.272479.940.00
Zhang, Brittney, W,199756056.610.003578.270.002478.34
Harrison, Colleen, L,202196044.590.003578.270.002466.32
Chandra, Ann,182096056.610.003578.272478.340.00
Zheng, Jaclyn, F,119108113.030.003374.992319.992418.05
Huang, Dawn, E,119434734.290.003374.99539.99819.31
Kumar, Louis, A,182034172.250.003578.270.00593.98
Wang, Valerie,202176089.590.003578.270.002511.32
Xu, Randy, S,119698173.020.003399.990.004773.03
Raje, Terrence,182466030.610.003578.272452.340.00
She, Rafael, I,201524142.750.003578.27564.480.00
Munoz, Latasha,119678153.020.003374.990.004778.03
Zheng, Dennis, E,255671239.090.00699.100.00539.99
Ms., Salavaria, Sharon,119648173.530.003399.990.004773.54
Anand, Carly,259181260.580.00699.100.00561.48
Xie, Karla,182014157.730.003578.270.00579.46
Sanders, Kaylee, C,202216035.600.003578.270.002457.33
Sullivan, Carla, A,206116021.620.003578.270.002443.35
Goel, Misty, M,182456021.620.003578.270.002443.35
Watson, Anna,202386021.620.003578.270.002443.35
Mehta, Evelyn, S,204204132.240.003578.27553.970.00
Chapman, Preston, O,182686102.190.003578.270.002523.92
Xylaras, Ioannis,202155279.260.003578.270.001700.99
Andersen, Jenny,202596029.570.003578.270.002451.30
Zhu, Alisha, G,182396030.610.003578.272452.340.00
Madan, Jay, L,201564139.750.003578.27561.480.00
Hu, Dennis, J,206006056.610.003578.270.002478.34
Pal, Christine, I,182426121.710.003578.272543.440.00
Gill, Kristine,199776044.590.003578.270.002466.32
Romero, Marie,204244132.240.003578.27553.970.00
Sun, Brittney,113655024.790.003374.990.001649.80
Goel, Jodi,204476035.600.003578.270.002457.33
Sharma, Mario, J,259281316.050.00699.100.00616.95
Collins, Jennifer,113644921.820.003374.990.001546.83
Shen, Katie, A,202835314.250.003578.270.001735.98
Anand, Kara,119898139.530.003374.990.004764.54
Ross, Julian,113635035.810.003399.990.001635.82
Hu, Cara,206086035.600.003578.270.002457.33
Schmidt, Deanna, H,259361248.080.00699.100.00548.98
Huang, Vincent, A,187035314.250.003578.270.001735.98
Munoz, Audrey, V,120038256.500.003374.990.004881.51
Ashe, Maurice,204306056.610.003578.270.002478.34
Gonzalez, Carla, J,183366145.070.003578.270.002566.80
Goel, Alicia, H,204234177.740.003578.270.00599.47
Shan, Johnny,119997043.270.003399.990.003643.28
Lal, Tara, S,186975279.260.003578.271700.990.00
Torres, Sabrina, E,204254118.260.003578.27539.990.00
Russell, Ashley,120008183.000.003399.990.004783.01
Hu, Alvin, E,114498130.320.003374.992362.272393.06
Tang, Edwin,204506021.620.003578.270.002443.35
Shen, Gilbert, C,120056984.810.003399.990.003584.82
She, Gregory,184584733.750.003578.270.001155.48
Yang, Colin, J,206126060.500.003578.270.002482.23
Vazquez, Joe, C,204184207.240.003578.27628.970.00
Prasad, Levi,257051274.080.00699.100.00574.98
Hu, Leah,119948169.030.003374.990.004794.04
Malhotra, Veronica, J,259221274.080.00699.100.00574.98
Chande, Jerry,183314752.750.003578.270.001174.48
Sai, Frederick,209914118.260.003578.270.00539.99
Lopez, Adriana, A,120028145.330.003374.990.004770.34
Rubio, Erika, A,114528183.040.003374.992414.992393.06
Shan, Keith, T,209964149.990.003578.270.00571.72
Raje, Mario, S,204275314.250.003578.270.001735.98
Arthur, Regina, A,190896093.200.003578.270.002514.93
Rubio, Sabrina, A,209844153.250.003578.270.00574.98
Gutierrez, Marvin,259381308.060.00699.100.00608.96
Alonso, Gary, C,187675314.250.003578.270.001735.98
Prasad, Preston, C,208124127.250.003578.27548.980.00
Xie, Mitchell, B,209934262.040.003578.270.00683.77
She, Latoya, A,117508148.020.003399.990.004748.03
Lewis, Kayla,120133949.970.003399.99549.980.00
Johnson, Morgan, E,120114735.810.003374.99618.47742.35
Gomez, Andy,187215333.250.003578.270.001754.98
Taylor, Devin, L,122483939.980.003399.990.00539.99
Madan, Raymond, W,208194181.760.003578.27603.490.00
Rivera, Steven, T,190836021.620.003578.270.002443.35
Martinez, Ann,120098195.500.003399.990.004795.51
Martin, Anna, L,209884118.260.003578.270.00539.99
She, Rosa,189316060.500.003578.270.002482.23
Cook, Victoria, J,206206044.590.003578.270.002466.32
Goldstein, Dustin,123378137.010.003399.990.004737.02
Garcia, Donald,189296029.570.003578.270.002451.30
Ruiz, Shannon,208224134.530.003578.27556.260.00
Rodriguez, Geoffrey,208174118.260.003578.27539.990.00
Fernandez, Kristopher, O,192714153.250.003578.27574.980.00
Raman, Mayra, P,209904196.220.003578.270.00617.95
Collins, Andrea,122503964.980.003399.990.00564.99
Raman, Raymond, R,195886056.610.003578.270.002478.34
Guo, Brent, J,259451248.080.00699.100.00548.98
Sara, Jarrod,206266038.560.003578.270.002460.29
Navarro, Julio, M,258221819.590.00699.100.001120.49
Vance, Monica, G,123388265.000.003374.990.004890.01
Sanders, Devin, J,120143949.970.003399.990.00549.98
Morgan, Carlos,258191873.580.00699.100.001174.48
Liu, Omar, L,122523938.950.003374.990.00563.96
Garcia, Ruth,206236093.200.003578.270.002514.93
Andersen, Shawna, C,195566035.600.003578.270.002457.33
Lu, Willie,211914169.330.002443.350.001725.98
Gonzalez, Francisco, L,122453967.260.003399.990.00567.27
Rana, Stefanie, K,196165279.260.003578.270.001700.99
Garcia, Carolyn,209992735.530.002181.560.00553.97
Gutierrez, Rodney, J,206286056.610.003578.270.002478.34
Carlson, Frank,118968117.970.003374.990.004742.98
Flores, Katherine,211803882.550.002181.560.001700.99
Navarro, Theresa,206276044.590.003578.270.002466.32
Nara, Karla, C,258271873.580.00699.100.001174.48
Dominguez, Diana, L,292922393.060.000.000.002393.06
Liang, Gilbert,122423948.970.003374.990.00573.98
Mehta, Arthur, A,199576035.600.003578.270.002457.33
Bailey, Melissa, C,1957282.250.000.000.0082.25
Shan, Deborah,206246021.620.003578.270.002443.35
Lu, Ronnie,199506098.540.003578.270.002520.27
Serrano, Darren,291962438.060.000.000.002438.06
Ross, Connor, J,208164228.720.003578.27650.450.00
Romero, Erika,199586056.510.003578.270.002478.24
Perez, Geoffrey, P,210002721.550.002181.560.00539.99
Andersen, Tracy,208154118.260.003578.27539.990.00
She, Susan,199566060.500.003578.270.002482.23
She, Eugene, L,209982806.510.002181.560.00624.95
Yuan, Rafael, J,206256029.570.003578.270.002451.30
Gonzalez, George, L,119424792.290.003399.99614.96777.34
Cai, Curtis,212593907.540.002181.560.001725.98
Ms., Simon, Britta,259461873.580.00699.100.001174.48
Raji, Dawn, C,202446021.620.003578.270.002443.35
Hall, Jesse,261331938.470.00782.990.001155.48
Chapman, Patricia,120377107.100.003374.990.003732.11
Rai, Sharon,202256056.610.003578.270.002478.34
Zhang, Jenny, H,246092120.930.001000.441120.490.00
Nath, Ricardo, C,120398213.000.003374.990.004838.01
Jimenez, Tanya, D,199706099.100.003578.270.002520.83
Perry, Gavin, M,125782668.080.002049.100.00618.98
Martinez, Troy, L,208234216.750.003578.270.00638.48
Browning, Janet,199796090.590.003578.270.002512.32
Goel, Christine, A,212313936.540.002181.560.001754.98
Sharma, Clayton, D,122403964.980.003399.990.00564.99
Shan, Colin,259211253.070.00699.100.00553.97
Hernandez, Brandi, C,218934663.790.002181.560.002482.23
Yuan, Tamara, E,211664909.670.002443.350.002466.32
Ortega, Jill, A,202396093.200.003578.270.002514.93
Gonzalez, Ruth,126936820.470.002071.420.004749.05
Yuan, Chad, C,211734659.900.002181.560.002478.34
Rai, Clayton, K,204466029.570.003578.270.002451.30
Ramos, Randall,215724659.900.002181.560.002478.34
Kumar, Alison,212003932.540.002181.560.001750.98
Gutierrez, Larry,259261308.060.00699.100.00608.96
Kapoor, Jay, F,219564632.860.002181.560.002451.30
Rodriguez, Carolyn,210022992.330.002443.350.00548.98
Coleman, Jocelyn,206066054.220.003578.270.002475.95
Ortega, Dwayne, C,246152155.920.000.002155.920.00
Ortega, Lance, C,123546797.130.002049.100.004748.03
Martinez, Ethan, C,202605314.250.003578.270.001735.98
Srini, Joe,221804632.860.000.002181.562451.30
Gao, Wesley,123466864.460.002071.420.004793.04
Tang, April, A,259351256.030.00699.100.00556.93
Ruiz, Natasha,219944659.900.000.002181.562478.34
Raman, Ruth, L,211994144.340.002443.350.001700.99

Generated 2024-11-10 07:12:56.169 UTC