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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Zheng, Rosa, G,166295933.263578.270.000.002354.99
Sanz, Kellie,167084406.743578.270.000.00828.47
Cox, Michelle, E,173284387.743578.270.000.00809.47
Vazquez, Daisy, L,255601288.060.00699.100.00588.96
Xu, Colleen,2895614.980.000.000.0014.98
Romero, Rodney,14521117.960.000.000.00117.96
Pal, Casey,165224698.763578.270.000.001120.49
Gutierrez, Natasha,170484382.753578.270.000.00804.48
Zhu, Alan,173204391.743578.270.000.00813.47
Nara, Dawn, M,218914921.690.002443.350.002478.34
Raje, Colleen, M,190846093.200.003578.270.002514.93
Ferrier, Linda, D,1314964.970.000.000.0064.97
Ramos, Marie, A,143085140.400.000.002049.103091.30
Gonzalez, Jay, C,142385642.900.000.002049.103593.80
Dominguez, Diana, L,292922393.060.000.000.002393.06
Wu, Kelvin,2459561.960.000.000.0061.96
Chow, Amy, E,126996798.130.002049.100.004749.03
Chen, Cedric, R,170654417.753578.270.000.00839.48
Suarez, Kristi, D,230992983.340.000.002443.35539.99
Sai, Preston, D,170464467.743578.270.000.00889.47
Kumar, Deborah, K,173086021.623578.270.000.002443.35
Gray, Faith,2291459.980.000.000.0059.98
Andersen, Carl, J,110578088.043374.990.002319.992393.06
Raje, Carly, J,155764344.090.000.002049.102294.99
Perez, Arthur, L,165264758.243578.270.000.001179.97
Xie, Cristina, C,170504496.233578.270.000.00917.96
Moreno, Meghan, J,151524464.570.000.002049.102415.47
Raman, Roy,163485918.243578.270.000.002339.97
Li, Stacey,140645694.210.000.002071.423622.79
Ferrier, Jaclyn, D,172994382.753578.270.000.00804.48
Rodriguez, Monica, J,289519.990.000.000.009.99
Goel, Brad, M,29085777.340.000.000.00777.34
Zheng, Christy,170694426.743578.270.000.00848.47
Sanz, Eddie, A,19580173.930.000.000.00173.93
Nath, Michele, L,110568207.503374.990.002413.452419.06
Gao, Todd, M,110618129.023374.990.002369.962384.07
Lal, Andres, L,166235973.243578.270.000.002394.97
Munoz, Alfredo, C,233142744.520.000.002181.56562.96
Kovar, Mayra, J,173124471.743578.270.000.00893.47
Wang, Trisha, V,172594404.733578.270.000.00826.46
Alexander, Gabriel, C,14073156.840.000.0038.88117.96
Perez, Kevin, M,255651239.090.00699.100.00539.99
Ramos, Eddie, T,13954128.460.000.000.00128.46
Romero, Sabrina, L,28534603.490.000.000.00603.49
Sanz, Monique, R,242732721.550.000.002181.56539.99
Ramos, Francis,163454173.243578.270.000.00594.97
Gutierrez, Desiree,15216101.740.000.0027.2874.46
Zhou, Jon, L,110608153.023399.990.002319.992433.04
Shen, Priscilla, A,28215589.960.000.000.00589.96
Vazquez, Kristi,2834939.980.000.000.0039.98
Raji, Terry,155974391.410.000.002071.422319.99
Beck, Donna, J,1824784.960.000.000.0084.96
Wang, Alejandro,173106029.573578.270.000.002451.30
Rodriguez, Sergio, D,15239123.450.000.000.00123.45
Yuan, Cassie, J,2445360.470.000.000.0060.47
Wang, Crystal, C,111128295.020.003374.990.004920.03
Wilson, Jasmine,173296021.620.003578.270.002443.35
Huang, Sandra, C,165234698.763578.270.000.001120.49
Arun, Ruth, S,172944355.713578.270.000.00777.44
Raman, Michele,172334347.760.003578.270.00769.49
Diaz, Briana,131316737.150.000.002049.104688.05
Torres, Carolyn,1526170.740.000.000.0070.74
Navarro, Tyrone, K,255571262.870.00699.100.00563.77
Walker, Anthony, T,252501883.56699.100.000.001184.46
Torres, Meghan, I,212563917.540.002181.560.001735.98
Moreno, Deanna,2894169.970.000.000.0069.97
Perez, Evelyn,143463583.260.000.002071.421511.84
Schmidt, Pamela, I,2437531.730.000.000.0031.73
Price, Vanessa, A,2356939.980.000.000.0039.98
Xu, Karl,233213060.820.000.002443.35617.47
Beck, April,143025140.730.000.002071.423069.31
Bailey, Melissa, C,1957282.250.000.000.0082.25
Sutton, Jaime, L,166305973.243578.270.000.002394.97
Foster, Maria, E,28715588.960.000.000.00588.96
Nara, Edwin, R,110978099.030.003374.992304.982419.06
Gill, Monique, L,1772721.980.000.000.0021.98
Chander, Omar, W,172414382.750.003578.270.00804.48
Wang, Jeffery, E,181886093.200.003578.270.002514.93
Diaz, Ruben, A,2513639.980.000.000.0039.98
Jackson, Joshua,1723583.980.000.000.0083.98
Serrano, Darren,291962438.060.000.000.002438.06
Powell, Lucas, T,18278158.950.000.000.00158.95
Jimenez, Walter,172324347.760.003578.270.00769.49
Mehta, Nancy,181894118.260.003578.270.00539.99
Ortega, Jessie, J,170516060.503578.270.000.002482.23
Rubio, Randall, M,172866029.570.003578.270.002451.30
Subram, Tabitha, C,175114150.530.003578.27572.260.00
Clark, Sydney,1661067.580.000.0032.6034.98
Malhotra, Geoffrey, W,1829824.270.000.000.0024.27
Cai, Curtis,212593907.540.002181.560.001725.98
Romero, Renee, E,166395908.253578.270.000.002329.98
Flores, Noah,172564362.740.003578.270.00784.47
Yuan, Louis, C,181934145.540.003578.270.00567.27
Sun, Jenny, L,122534066.930.003399.990.00666.94
Prasad, Dominic, D,1996246.750.000.000.0046.75
Nara, Leonard, G,11045114.960.000.000.00114.96
Rai, Alejandro, R,2199099.470.000.000.0099.47
Rai, Colleen,2893329.480.000.000.0029.48
Zhou, Cedric,175144142.230.003578.27563.960.00
Moreno, Krista, J,167456021.623578.270.000.002443.35
Anand, Andrés,110968063.040.003374.992294.992393.06
Chander, Edwin, T,173704742.740.003578.270.001164.47
Raman, Mayra, P,209904196.220.003578.270.00617.95
Zeng, Micah, A,255611288.060.00699.100.00588.96
Shan, Keith, T,209964149.990.003578.270.00571.72
Ramos, Randall,215724659.900.002181.560.002478.34
Raji, Lindsey,182056056.610.003578.272478.340.00
Cai, Tiffany,182044133.240.003578.270.00554.97
Kapoor, Ruben, D,111098245.010.003374.992476.962393.06
Raji, Sheena, J,182136070.590.003578.272492.320.00
Li, Krystal, A,249122120.930.000.001000.441120.49
Griffin, Rachel,182556067.200.003578.270.002488.93
Nara, Latoya, J,182086035.600.003578.272457.330.00
Ramos, Marc,182126029.570.003578.272451.300.00
Raman, Levi,291142384.070.000.000.002384.07
Gonzalez, Phillip, N,182076089.590.003578.272511.320.00
Simmons, Gabrielle,291832393.060.000.000.002393.06
Martin, Alyssa,1958721.490.000.000.0021.49
Gomez, Felicia, J,182196038.560.003578.272460.290.00
Moore, Natalie, W,182736104.210.003578.272525.940.00
Suri, Ronald,182146093.200.003578.272514.930.00
Martinez, Bruce, D,184524752.750.003578.270.001174.48
Diaz, Aaron, C,186956029.570.003578.270.002451.30
Diaz, Mallory, V,17289106.950.000.000.00106.95
Chander, Alejandro, M,2445575.470.000.000.0075.47
Diaz, Ricky, E,183356035.600.003578.270.002457.33
Garcia, Carolyn,209992735.530.002181.560.00553.97
Alan, Meghan, I,28210564.480.000.000.00564.48
Townsend, Darren,184675279.260.003578.271700.990.00
Taylor, Jennifer,184706021.620.003578.272443.350.00
Kumar, Kenneth,114728165.820.003399.990.004765.83
Sanchez, Joel,184685333.250.003578.271754.980.00
Lal, Carl, C,2895044.980.000.000.0044.98
Rai, Brad, S,184906029.570.003578.270.002451.30
Liu, Alejandro, R,195556110.600.003578.270.002532.33
Ye, Ramon,113574943.800.003374.990.001568.81
Chander, Bethany, K,114468237.010.003399.992354.982482.04
Nara, Sharon,184826030.610.003578.272452.340.00
Sharma, Misty,257081253.070.00699.100.00553.97
Chande, Jaclyn, S,186985314.250.003578.271735.980.00
Alvarez, Gloria, B,182976119.590.003578.272541.320.00
Blanco, Marc,249082155.920.000.001000.441155.48
Martin, Justin,235423337.040.000.002181.561155.48
Zheng, Claudia,186916070.590.003578.270.002492.32
Barnes, Angelica,1512877.270.000.000.0077.27
Smith, Adriana,187025333.250.003578.271754.980.00
Srini, Kristopher, A,2399739.980.000.000.0039.98
Sanz, Ross,114558142.030.003374.992319.992447.05
Hill, Adam,187406056.610.003578.272478.340.00
Kapoor, Denise, M,187256044.590.003578.270.002466.32
Moreno, Latasha, R,187356021.620.003578.272443.350.00
Ortega, Janet, L,117548163.530.003399.992319.992443.55
Subram, Adriana,2342429.480.000.000.0029.48
Zeng, Louis,189034143.740.003578.27565.470.00
Guo, Ernest,257171274.080.00699.100.00574.98
Powell, Amanda,28113901.350.000.000.00901.35
Lopez, Bruce,235403626.820.000.002443.351183.47
Richardson, Katelyn,189306035.600.003578.270.002457.33
Garcia, Dalton, M,187685314.250.003578.270.001735.98
Malhotra, Brett, E,187316054.060.003578.270.002475.79
Gomez, Ricky,187376021.620.003578.272443.350.00
Deng, Tasha,114598141.330.003399.992322.282419.06
Ortega, Linda, C,117568078.020.003374.990.004703.03
Liu, Susan,187186035.600.003578.270.002457.33
Perry, Maria, N,177284730.030.003578.270.001151.76
He, Brent, R,257121262.060.00699.100.00562.96
Lal, Karla,2521939.980.000.000.0039.98
Jones, Nathan,1502478.960.000.000.0078.96
Navarro, Kathleen, J,192694118.260.003578.27539.990.00
Lopez, Cesar,17500156.960.000.000.00156.96
Arun, Troy, P,152214447.870.000.002071.422376.45
Sanz, Marvin,196126029.570.003578.270.002451.30
Suarez, Alberto, G,1871953.990.000.000.0053.99
Suri, Troy, M,122513924.970.003374.990.00549.98
Dominguez, Stacy, S,191056056.610.003578.270.002478.34
Gomez, Anne,1304562.270.000.000.0062.27
Suri, Jillian, L,151804466.390.000.002071.422394.97
Suarez, Alfredo,196015314.250.003578.270.001735.98
Ashe, Joanna, F,209972744.520.002181.560.00562.96
Vazquez, Kristine, M,177364742.740.003578.270.001164.47
Perez, Martin,195776037.890.003578.270.002459.62
Zheng, Laura,167014426.743578.270.000.00848.47
Li, Aimee,179154792.730.003578.270.001214.46
Lu, Roger, F,197634153.250.003578.27574.980.00
Xu, Clarence,218774624.910.002181.560.002443.35
Alexander, David,1578398.960.000.000.0098.96
Deng, Devon, H,199676029.570.003578.270.002451.30
Zeng, Ernest, M,12992158.510.000.000.00158.51
Navarro, Carolyn,110698104.050.003399.992319.992384.07
Hill, Alex, C,197876054.220.003578.270.002475.95
Gill, Roy,29465791.320.000.000.00791.32
Green, Sydney,23522120.470.000.000.00120.47
Liu, Clarence,197976021.620.003578.270.002443.35
Suarez, Melody, H,142765259.360.000.002049.103210.26
Goel, Drew,173526021.620.003578.270.002443.35
Torres, Marc,117658143.030.003374.992294.992473.05
Xu, Edwin, J,252721873.58699.100.000.001174.48
Suri, Cesar,175124170.540.003578.27592.270.00
Chander, Dustin,118958149.040.003374.990.004774.05
Serrano, Javier, R,202566029.570.003578.270.002451.30
Xu, Tracy, L,179164787.740.003578.270.001209.47
Gutierrez, Ricky,197736056.610.003578.270.002478.34
Rai, Karl, M,252731898.07699.100.000.001198.97
Lu, Tiffany,2284348.980.000.000.0048.98
Liu, Darryl,199476056.510.003578.270.002478.24
Torres, Diane, M,2521179.470.000.000.0079.47
Shen, Leonard, J,242712745.330.000.002181.56563.77
Smith, Tina, K,197936056.610.003578.270.002478.34
Suarez, Ricky,29066539.990.000.000.00539.99
Ramos, Jerome, L,29187588.960.000.000.00588.96
Fernandez, Geoffrey,199636054.220.003578.270.002475.95
Sullivan, Dominic, M,2284037.290.000.000.0037.29
Hall, Jeremiah, M,182506058.210.003578.272479.940.00
Mr., Spencer, Phil,199606120.110.003578.270.002541.84
Lewis, Justin, L,2830374.980.000.000.0074.98
Harris, Eduardo, S,182386030.610.003578.272452.340.00
Sanchez, Abby, J,199666021.620.003578.270.002443.35
Hu, Amy,14320261.950.000.000.00261.95
Liu, Suzanne,195946021.620.003578.270.002443.35
Anand, Niñia, L,199496054.220.003578.270.002475.95
Cai, Susan,19101104.420.000.000.00104.42
Raji, Carl,195956095.080.003578.270.002516.81
Malhotra, Darren, L,202456085.590.003578.270.002507.32
Wu, Micah,172464380.043578.270.000.00801.77
Alonso, Danny, S,182176056.610.003578.272478.340.00
Chande, Katrina, L,199686021.620.003578.270.002443.35
Rai, Clayton, K,204466029.570.003578.270.002451.30
Lin, Autumn, E,182726056.610.003578.272478.340.00
Ramos, Dana, D,259191248.080.00699.100.00548.98
Vazquez, Roy,260291930.760.00782.990.001147.77
Carson, Terrence,113565069.290.003374.990.001694.30
Zhang, Brittney, W,199756056.610.003578.270.002478.34
Beck, Alicia, L,172484382.753578.270.000.00804.48
Powell, Thomas, R,182186021.620.003578.272443.350.00
Zheng, Jaclyn, F,119108113.030.003374.992319.992418.05
Lal, Barbara, W,231012795.010.000.002181.56613.45
Suarez, Carolyn, B,182226044.590.003578.272466.320.00
Wang, Valerie,202176089.590.003578.270.002511.32
Rana, Darren, M,172574480.733578.270.000.00902.46
Nelson, Fernando, G,255641253.070.00699.100.00553.97
She, Rafael, I,201524142.750.003578.27564.480.00
Rai, Brendan, A,215694960.160.000.002443.352516.81
Munoz, Jacquelyn,291152407.040.000.000.002407.04
Ms., Salavaria, Sharon,119648173.530.003399.990.004773.54
Yuan, Darrell,18271119.950.000.000.00119.95
Navarro, Kristine, B,255661253.070.00699.100.00553.97
Sanders, Kaylee, C,202216035.600.003578.270.002457.33
Sai, Molly,1468398.950.000.0018.9779.98
Chande, Lindsay,182446021.620.003578.272443.350.00
Watson, Anna,202386021.620.003578.270.002443.35

Generated 2024-11-10 06:05:29.558 UTC