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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Xie, Kurt, A,14344126.950.000.000.00126.95
Gonzalez, Phillip, N,182076089.590.003578.272511.320.00
Mehta, Jay, S,150353772.410.000.002071.421700.99
Raje, Raul, L,2678574.980.000.000.0074.98
Munoz, Shannon, S,2912249.970.000.000.0049.97
Gomez, Felicia, J,182196038.560.003578.272460.290.00
Shen, Karl, M,151514344.090.000.002049.102294.99
Gill, Mallory, P,16698197.880.000.000.00197.88
Hernandez, Melody, E,28212619.460.000.000.00619.46
Perez, Kevin, M,255651239.090.00699.100.00539.99
Hu, Valerie, M,150443803.560.000.002049.101754.46
Chande, Alvin, W,2489323.780.000.000.0023.78
Gonzalez, Summer, L,2026660.470.000.000.0060.47
Moore, Natalie, W,182736104.210.003578.272525.940.00
Hu, Marshall, H,267971957.470.000.00782.991174.48
Alonso, Krista, P,20212100.740.000.000.00100.74
Sanz, Walter, J,1819594.470.000.000.0094.47
Suri, Ronald,182146093.200.003578.272514.930.00
Martinez, Lydia,241692735.530.000.002181.56553.97
Gutierrez, Diana,1967667.970.000.000.0067.97
Gomez, Marvin, C,28479831.330.000.000.00831.33
Martinez, Bruce, D,184524752.750.003578.270.001174.48
Lopez, George,150403807.400.000.002071.421735.98
Raman, Pamela, C,2736978.980.000.000.0078.98
Madan, Bruce, G,1820665.960.000.000.0065.96
Diaz, Aaron, C,186956029.570.003578.270.002451.30
Jimenez, Marie, C,241763042.820.000.002443.35599.47
Raji, Devon, D,2189874.980.000.000.0074.98
Deng, Tracy, E,2197837.290.000.000.0037.29
Diaz, Ricky, E,183356035.600.003578.270.002457.33
Raji, Jaime, L,150373856.380.000.002071.421784.96
Ye, Tamara, A,2024360.470.000.000.0060.47
Sullivan, Henry, L,2060323.780.000.000.0023.78
Townsend, Darren,184675279.260.003578.271700.990.00
Srini, Deanna,151824391.410.000.002071.422319.99
Zhou, Kelvin,2023160.470.000.000.0060.47
Chander, Carl,14315109.710.000.000.00109.71
Taylor, Jennifer,184706021.620.003578.272443.350.00
Li, Edwin,269671336.960.000.001336.960.00
Ruiz, Hector,275924.990.000.000.004.99
Madan, Kristi, I,291842420.340.000.000.002420.34
Sanchez, Joel,184685333.250.003578.271754.980.00
Zheng, Jeffery, W,150303786.390.000.002071.421714.97
Romero, Meredith, J,29452742.350.000.000.00742.35
Sun, Aimee, R,1831960.470.000.000.0060.47
Rai, Brad, S,184906029.570.003578.270.002451.30
Yang, Cedric,150383750.090.000.002049.101700.99
Shan, Tony, M,1617531.270.000.000.0031.27
Gomez, Mallory, R,248987.280.000.000.007.28
Ye, Ramon,113574943.800.003374.990.001568.81
Rai, Raul, R,151335237.730.000.002071.423166.31
Blanco, Sheila, I,1772436.960.000.000.0036.96
Tang, Louis, A,1829239.250.000.000.0039.25
Chander, Bethany, K,114468237.010.003399.992354.982482.04
Sara, Clifford, M,241782810.530.000.002181.56628.97
Xu, Dennis,2199739.990.000.000.0039.99
Jenkins, Noah, A,2437913.980.000.000.0013.98
Nara, Sharon,184826030.610.003578.272452.340.00
Shan, Elijah, L,267951992.460.000.00782.991209.47
She, Christine,1618478.200.000.000.0078.20
Anand, Alícia, J,291132453.040.000.000.002453.04
Chande, Jaclyn, S,186985314.250.003578.271735.980.00
Kumar, Tamara, A,252222120.930.000.001000.441120.49
Prasad, Brandy, P,1400963.970.000.000.0063.97
She, Candice,291782452.040.000.000.002452.04
Alvarez, Gloria, B,182976119.590.003578.272541.320.00
Bhat, Yolanda,152254401.410.000.002071.422329.99
Suri, Cassandra, B,1871787.210.000.000.0087.21
Martin, Byron, E,2521739.980.000.000.0039.98
Zheng, Claudia,186916070.590.003578.270.002492.32
Ye, Alvin, B,155752910.900.000.002071.42839.48
Suarez, Orlando,1112158.160.000.000.0058.16
Johnston, Tamara, H,18492218.260.000.000.00218.26
Smith, Adriana,187025333.250.003578.271754.980.00
Wu, Shannon, F,152682840.910.000.002071.42769.49
Xu, Keith, J,2512464.470.000.000.0064.47
Becker, Julie,13614114.210.000.000.00114.21
Sanz, Ross,114558142.030.003374.992319.992447.05
Dominguez, Josue, R,156004590.400.000.002071.422518.98
Sun, Tamara, L,1997644.040.000.000.0044.04
Shen, Devon, G,2735878.980.000.000.0078.98
Hill, Adam,187406056.610.003578.272478.340.00
Shan, Shaun,242743018.330.000.002443.35574.98
Rivera, Devin, J,251094.990.000.000.004.99
She, Kristin, L,1996197.970.000.000.0097.97
Gonzales, Victoria,117518215.020.003399.990.004815.03
Alvarez, Kristy,155884486.070.000.002049.102436.97
Hayes, Eric, A,22964123.980.000.000.00123.98
Griffin, Noah, E,2911873.960.000.000.0073.96
Kapoor, Denise, M,187256044.590.003578.270.002466.32
Navarro, Leslie, E,243714193.820.000.002443.351750.47
Anand, Cassie, M,29342801.830.000.000.00801.83
Xu, Kate, R,289572419.060.000.000.002419.06
Moreno, Latasha, R,187356021.620.003578.272443.350.00
He, Dawn,156473764.070.000.002049.101714.97
Suarez, Neil,1524237.270.000.000.0037.27
Perez, Rachael, D,26762133.490.000.000.00133.49
Ashe, Tara, J,190936035.600.003578.270.002457.33
Patel, Deanna, H,273541322.980.000.00782.99539.99
Nara, Karl,15142138.460.000.000.00138.46
Lal, Clarence, L,2447039.980.000.000.0039.98
Ortega, Janet, L,117548163.530.003399.992319.992443.55
Vazquez, Marc, H,243623600.770.000.002443.351157.42
Raji, Maurice, C,2061974.980.000.000.0074.98
Stewart, Margaret, C,29096574.980.000.000.00574.98
Zeng, Louis,189034143.740.003578.27565.470.00
Jiménez, Alberto, C,152154468.560.000.002049.102419.46
Ye, Steve,29087810.320.000.000.00810.32
Malhotra, Kristina,2503125.480.000.000.0025.48
Guo, Ernest,257171274.080.00699.100.00574.98
Carlson, Francis,273401350.750.000.00782.99567.76
Alvarez, Desiree,13005223.970.000.000.00223.97
Wu, Lisa,2615894.480.000.000.0094.48
Richardson, Katelyn,189306035.600.003578.270.002457.33
Nara, Willie,244603302.050.000.002181.561120.49
Patel, Virginia, R,1136677.270.000.000.0077.27
Adams, Sydney,2736769.990.000.000.0069.99
Garcia, Dalton, M,187685314.250.003578.270.001735.98
Raman, Jermaine, E,152284375.060.000.002049.102325.96
Lopez, Brandy, S,1819999.940.000.000.0099.94
Mrs., Nara, Barbara,12704217.460.000.000.00217.46
Kumar, Kenneth,114728165.820.003399.990.004765.83
Carson, Kristin, C,244593961.030.000.002181.561779.47
Lal, Drew, A,28325574.980.000.000.00574.98
Nath, Latoya, A,27582561.920.000.000.00561.92
Malhotra, Brett, E,187316054.060.003578.270.002475.79
Alvarez, Kendra, R,152672853.580.000.002049.10804.48
Muñoz, Alberto, J,13008125.510.000.000.00125.51
Hall, Mary, R,202774.990.000.000.004.99
Gomez, Ricky,187376021.620.003578.272443.350.00
Gomez, Naomi, E,243004144.340.000.002443.351700.99
Nath, Keith,1961761.750.000.000.0061.75
Chander, Gregory, J,2200174.980.000.000.0074.98
Deng, Tasha,114598141.330.003399.992322.282419.06
Raji, Damien, K,242823917.540.000.002181.561735.98
Raji, Kathryn, C,2199537.290.000.000.0037.29
Carlson, Marc, W,17501141.980.000.000.00141.98
Ortega, Linda, C,117568078.020.003374.990.004703.03
Luo, Melvin,243664144.340.000.002443.351700.99
Cai, Shannon,2615678.980.000.000.0078.98
Lopez, Chelsea,243694.990.000.000.004.99
Liu, Susan,187186035.600.003578.270.002457.33
Blanco, Victor,155864469.370.000.002071.422397.95
Kapoor, Rachael, D,1191162.460.000.000.0062.46
Serrano, Jacquelyn,2196339.990.000.000.0039.99
Navarro, Kathleen, J,192694118.260.003578.27539.990.00
Chander, Roger,252142149.910.000.001000.441149.47
Martin, Jaime,28316539.990.000.000.00539.99
Martin, Max, A,1603037.270.000.000.0037.27
Sanz, Marvin,196126029.570.003578.270.002451.30
Cai, Jeffery, A,155822907.560.000.002049.10858.46
Subram, Kari,12682227.960.000.000.00227.96
Taylor, Christopher, E,2117137.290.000.000.0037.29
Liu, Alejandro, R,195556110.600.003578.270.002532.33
Patel, Whitney, F,244684144.340.000.002443.351700.99
Mehta, Regina,1724592.970.000.000.0092.97
Ashe, Misty, R,231294.990.000.000.004.99
Dominguez, Stacy, S,191056056.610.003578.270.002478.34
Zhang, Edwin,157854454.350.000.002071.422382.93
Vance, Jillian, D,15230148.980.000.000.00148.98
Vance, Phillip,293082438.060.000.000.002438.06
Suarez, Alfredo,196015314.250.003578.270.001735.98
Travers, Alexa, A,244663337.040.000.002181.561155.48
Yuan, Melvin,2933147.970.000.000.0047.97
Zeng, Alisha, A,15727134.460.000.000.00134.46
Perez, Martin,195776037.890.003578.270.002459.62
Allen, Ian, A,160313750.090.000.002049.101700.99
Sanz, Jésus,29313539.990.000.000.00539.99
Huang, Micah,251307.280.000.000.007.28
Lu, Roger, F,197634153.250.003578.27574.980.00
Guo, Rosa, M,244743882.550.000.002181.561700.99
Diaz, Gerald, M,251187.280.000.000.007.28
Ramos, Victor, D,242469.990.000.000.009.99
Hill, Alex, C,197876054.220.003578.270.002475.95
Jiménez, Byron,160263804.080.000.002049.101754.98
Black, Wayne, E,250567.280.000.000.007.28
Sanz, Nelson, M,1405649.480.000.000.0049.48
Liu, Clarence,197976021.620.003578.270.002443.35
Zhao, Heather,245964168.830.000.002443.351725.48
Garcia, Darren,2871629.480.000.000.0029.48
Carlson, Eddie,233474.990.000.000.004.99
Patel, Toni, E,258291894.070.00699.100.001194.97
He, Omar,158312646.360.000.002646.360.00
Malhotra, Whitney, D,2894423.970.000.000.0023.97
Blanco, Erika, L,1466990.250.000.000.0090.25
Torres, Marc,117658143.030.003374.992294.992473.05
Gomez, Kathleen, J,161584369.090.000.002049.102319.99
Madan, Cassandra, D,29068751.340.000.000.00751.34
Nara, Lindsay, M,252474.990.000.000.004.99
Chander, Dustin,118958149.040.003374.990.004774.05
Chande, Willie, B,161632641.390.000.002071.42569.97
Tang, Cristina, D,19623153.930.000.000.00153.93
Lee, Grace, J,28318574.980.000.000.00574.98
Gutierrez, Ricky,197736056.610.003578.270.002478.34
Yuan, Alicia,252252129.920.000.001000.441129.48
Liang, Jenny, S,27351123.980.000.000.00123.98
Jai, Dylan, J,2312839.980.000.000.0039.98
Liu, Darryl,199476056.510.003578.270.002478.24
Hernandez, Erika,161602644.070.000.002049.10594.97
She, Sharon, F,2201769.990.000.000.0069.99
Ramos, Rebekah, L,27984561.480.000.000.00561.48
Smith, Tina, K,197936056.610.003578.270.002478.34
Sun, Dennis, K,244814179.330.000.002443.351735.98
Vance, Kristi, T,2833847.970.000.000.0047.97
Carlson, Mathew, A,230124.990.000.000.004.99
Fernandez, Geoffrey,199636054.220.003578.270.002475.95
Lin, Clayton, M,274921344.910.000.00782.99561.92
Madan, Kristopher, A,252387.280.000.000.007.28
Munoz, Felicia, D,2040659.980.000.000.0059.98
Mr., Spencer, Phil,199606120.110.003578.270.002541.84
Wang, Roger, P,246053627.810.000.003627.810.00
Ramos, Kristy,1668266.580.000.000.0066.58
Chande, Louis, A,1668168.870.000.000.0068.87
Sanchez, Abby, J,199666021.620.003578.270.002443.35
Raman, Cindy,161574391.410.000.002071.422319.99
Lal, Warren, B,2524627.770.000.000.0027.77
Alexander, Alyssa, M,1728237.270.000.000.0037.27
Anand, Niñia, L,199496054.220.003578.270.002475.95
Liang, Amy,161642639.080.000.002049.10589.98
Alonso, Jerome, H,27977553.970.000.000.00553.97
Gill, Orlando,2136093.970.000.000.0093.97
Malhotra, Darren, L,202456085.590.003578.270.002507.32
Patel, Monica, J,252342174.920.000.001000.441174.48
Gomez, Brandi, M,14675187.980.000.000.00187.98
Martin, Tabitha,2526923.780.000.000.0023.78
Rana, Joe, D,119168178.510.003374.992405.472398.05
Ashe, Brad,252282120.930.000.001000.441120.49
Morris, Megan,2364164.470.000.000.0064.47
Prasad, Cory,197484.990.000.000.004.99
Chande, Katrina, L,199686021.620.003578.270.002443.35
Kumar, Bridget,158024444.070.000.002049.102394.97
Stone, Keith,1733140.960.000.000.0040.96
Rubio, Tanya, I,15598167.930.000.000.00167.93
Zheng, Jaclyn, F,119108113.030.003374.992319.992418.05
Lal, Alicia,157344426.410.000.002071.422354.99
Vazquez, Diane, D,11987279.230.000.000.00279.23
Sanders, Charles, E,21967123.960.000.000.00123.96
Wang, Valerie,202176089.590.003578.270.002511.32
Gutierrez, Kari,157564441.390.000.002071.422369.97
Xu, Terry,2422815.230.000.000.0015.23
Huang, Willie, C,28133574.980.000.000.00574.98
She, Rafael, I,201524142.750.003578.27564.480.00
Zeng, Warren, R,244773302.050.000.002181.561120.49
Nath, Grant, A,2894714.980.000.000.0014.98
Yuan, Derek, L,275891183.470.000.000.001183.47
Ms., Salavaria, Sharon,119648173.530.003399.990.004773.54
Suri, Mayra, M,157294393.700.000.002071.422322.28
Davis, Ryan, C,278702419.060.000.000.002419.06
Martin, Arthur, L,2894349.970.000.000.0049.97
Sanders, Kaylee, C,202216035.600.003578.270.002457.33

Generated 2024-11-10 06:26:43.243 UTC