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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Andersen, Jodi,2676678.980.000.000.0078.98
Goel, Bradley,1580366.260.000.000.0066.26
_SUM9051988.22546835.112386860.532383298.863734993.72
Perez, Henry,267521917.460.000.00782.991134.47
Kapoor, Kristina,119977029.780.003399.991249.842379.95
Yuan, Chad, C,211734659.900.002181.560.002478.34
Smith, Thomas,1706853.990.000.000.0053.99
Raman, Allen, R,2512960.470.000.0060.470.00
Cai, Willie, S,259601957.470.00782.990.001174.48
Yang, Leah, J,1518659.480.000.000.0059.48
Fernandez, Marie,289297.280.000.000.007.28
Moore, Olivia, A,252312189.900.000.001000.441189.46
Vazquez, Kristine, M,177364742.740.003578.270.001164.47
Tang, Christy, R,236603917.540.000.002181.561735.98
Cook, Faith,278712384.070.000.000.002384.07
Smith, Andre,2117442.280.000.000.0042.28
Shan, Derek, R,197826089.590.003578.270.002511.32
Rana, Joe, D,119168178.510.003374.992405.472398.05
Garcia, Stefanie, E,277431155.480.000.000.001155.48
Hall, Jeremiah, M,182506058.210.003578.272479.940.00
Lal, Sheena,2331213.980.000.000.0013.98
Stone, Mitchell,2501369.970.000.000.0069.97
Moreno, Casey,2060280.470.000.000.0080.47
Yang, Stacey,142155665.890.000.002049.103616.79
Rai, Colleen,2893329.480.000.000.0029.48
Xie, Drew, A,20218104.690.000.000.00104.69
Cooper, Allison, J,29294553.970.000.000.00553.97
Subram, Ann, M,186936021.620.003578.272443.350.00
Zhou, Gilbert,244753945.530.000.002181.561763.97
Madan, Francisco, S,257061239.090.00699.100.00539.99
Li, Barbara,157884443.380.000.002071.422371.96
Madan, Martin, M,24911102.960.000.000.00102.96
Nara, Willie,244603302.050.000.002181.561120.49
Prasad, Carmen, L,189286095.080.003578.270.002516.81
Chander, Clarence, E,1398259.980.000.0034.9924.99
Alvarez, Marvin,236513917.540.000.002181.561735.98
Rodriguez, Monica, J,289519.990.000.000.009.99
Sun, Edwin, O,2117074.980.000.000.0074.98
Zhang, Willie, T,16023166.890.000.000.00166.89
Suri, Carmen, E,242502738.490.000.002181.56556.93
Ferrier, Edwin, J,157574366.410.000.002071.422294.99
Jackson, Joshua,1723583.980.000.000.0083.98
Long, Alexis,225803051.310.000.002443.35607.96
Chavez, Clayton,219494659.900.000.002181.562478.34
Navarro, Jill,2200356.970.000.000.0056.97
Andersen, Ashlee, J,11059116.930.000.00116.930.00
Dominguez, Josue, R,156004590.400.000.002071.422518.98
Sanchez, Joel,184685333.250.003578.271754.980.00
Rodriguez, Donald, L,28351574.980.000.000.00574.98
Torres, Wendy, A,182696113.200.003578.270.002534.93
Saunders, Patricia, J,195655308.240.003578.270.001729.97
Yang, Crystal, A,236654207.320.000.002443.351763.97
Raji, Derek, D,1959163.420.000.000.0063.42
Ramos, Jessie, R,117648129.020.003399.990.004729.03
Sun, Aimee, R,1831960.470.000.000.0060.47
Chen, Cedric, R,170654417.753578.270.000.00839.48
Serrano, Hector, K,28308588.960.000.000.00588.96
Sanchez, Manuel,1512686.260.000.0058.9827.28
Griffin, Olivia,2120839.980.000.000.0039.98
Shen, Priscilla, A,28215589.960.000.000.00589.96
Zhang, Ronnie,166565930.233578.270.000.002351.96
Martin, Marc, J,110396636.583399.990.000.003236.59
Ferrier, Linda, D,1314964.970.000.000.0064.97
Hu, Alejandro,13125138.540.000.000.00138.54
Alonso, Darren,27501578.460.000.000.00578.46
Chander, Andres, E,29460751.340.000.000.00751.34
Schmidt, Joe, M,229054624.910.000.002181.562443.35
Jiménez, Daisy,219444713.890.002181.560.002532.33
Moyer, Mario,234204144.340.000.002443.351700.99
Romero, Ebony, A,2771712.940.000.000.0012.94
Liu, Candice,287202419.060.000.002419.060.00
Lewis, Hannah,265611336.960.000.00782.99553.97
Gao, Amy,219963946.520.000.002181.561764.96
Garcia, Chelsea,2196142.280.000.0042.280.00
Gutierrez, Latasha, C,150222999.910.000.002071.42928.49
Martin, Joan, R,255561253.070.00699.100.00553.97
Ramos, Juan,136336803.140.000.002049.104754.04
Zhou, Carol, L,2445421.490.000.000.0021.49
Shen, Nichole,129996840.460.000.002071.424769.04
Rubio, Derrick, P,235253302.050.000.002181.561120.49
Xu, Julie,183016056.610.003578.272478.340.00
Chande, Jaclyn, S,186985314.250.003578.271735.980.00
Blanco, Erika, L,1466990.250.000.000.0090.25
Wang, Jeffery, E,181886093.200.003578.270.002514.93
Diaz, Gerald, M,251187.280.000.000.007.28
Sai, Ronald, B,136436799.450.000.002071.424728.03
Yuan, Terry, R,136466843.600.000.002049.104794.50
Madan, Joe,293002419.060.000.000.002419.06
Ross, Adam,110998215.990.003399.992363.962452.04
Garcia, Jermaine,2156642.280.000.0042.280.00
She, Willie,170554347.763578.270.000.00769.49
Ramos, Kristine,17479163.400.000.000.00163.40
Reed, Riley, A,201574118.260.003578.27539.990.00
Gomez, Carrie,229657.280.000.000.007.28
Ye, Christy,142195744.220.000.002071.423672.80
Romero, Gary,221814673.880.000.002181.562492.32
Martinez, Jay,245923896.530.000.002181.561714.97
Dominguez, Andy, L,14126135.550.000.0063.9771.58
Sharma, Julie, R,1819194.470.000.008.9985.48
Barnes, Taylor,142795137.710.000.002049.103088.61
Garcia, Virginia, C,2459926.970.000.000.0026.97
Vazquez, Roy,260291930.760.00782.990.001147.77
Zhang, Kristen,274841322.980.000.00782.99539.99
Miller, Edward,113685106.240.003374.990.001731.25
Navarro, Jacquelyn,1546540.230.000.0029.9910.24
Lopez, Ross,1844360.470.000.000.0060.47
Suarez, Neil,1524237.270.000.000.0037.27
Garcia, Dominique,165284698.763578.270.000.001120.49
Andersen, Rafael, E,12691247.460.000.000.00247.46
Gill, Monique, L,1772721.980.000.000.0021.98
Rana, Raymond,251152155.920.000.001000.441155.48
Mehta, Carla, L,2156339.990.000.0039.990.00
Martinez, Fernando,2045423.780.000.000.0023.78
Clark, Madison, A,140625647.920.000.003272.942374.98
Prasad, Henry, M,243643965.520.000.002181.561783.96
Wright, Miguel,2581186.450.000.0086.450.00
Romero, Mallory,2643469.990.000.000.0069.99
Suarez, Melinda,29181553.970.000.000.00553.97
Romero, Gina,142345687.720.000.002071.423616.30
Sharma, Terrence, N,173516117.693578.270.000.002539.42
Hernandez, Mallory,29091756.330.000.000.00756.33
Diaz, Ricky, E,183356035.600.003578.270.002457.33
Tang, Drew, W,151784445.060.000.002049.102395.96
Madan, Evelyn, D,225822756.540.000.002181.56574.98
Wang, Trisha, V,172594404.733578.270.000.00826.46
Zhou, Arturo, F,27910574.980.000.00574.980.00
Wu, Mandy,183096090.590.003578.272512.320.00
Yang, Colleen,22167123.980.000.00123.980.00
Barnes, Angelica,1512877.270.000.000.0077.27
Zhang, Damien, C,267581322.980.000.001322.980.00
Martinez, Brett,235323337.040.000.003337.040.00
Ye, Ramon,113574943.800.003374.990.001568.81
Raman, Cindy,161574391.410.000.002071.422319.99
Stewart, Ariana,167436070.593578.270.000.002492.32
Lopez, Deanna, L,251192148.210.000.001000.441147.77
Alonso, Kristine,166864157.733578.270.000.00579.46
Hayes, Alexis,13048190.230.000.000.00190.23
Gonzales, Alexis,2352121.980.000.000.0021.98
Alonso, Sheila,25054103.480.000.000.00103.48
Jiménez, Byron,160263804.080.000.002049.101754.98
He, Jon, L,142625652.540.000.002071.423581.12
Sanz, Theodore, M,1649238.980.000.000.0038.98
Gonzalez, Donald,1107932.960.000.009.9922.97
Moreno, Leslie, C,11114122.890.000.007.95114.94
Alvarez, Stacy,119018248.010.003399.990.004848.02
Phillips, Jeremy, E,184956021.620.003578.272443.350.00
Chavez, Karla, K,1670491.260.000.000.0091.26
Navarro, Francis, J,2752078.980.000.000.0078.98
Lopez, Dominic, B,275901189.460.000.000.001189.46
Raman, Rachael,2521679.470.000.000.0079.47
Ramos, Roy, A,244823882.550.000.002181.561700.99
Serrano, Kristine,289402393.060.000.000.002393.06
Suarez, Linda,1666581.810.000.000.0081.81
Cai, Amy,249202155.920.000.001000.441155.48
Wang, Curtis, A,131085718.660.000.002071.423647.24
Mehta, Tina, C,114448136.020.003374.992376.962384.07
Weber, Chelsea,291912393.060.000.000.002393.06
Shan, Damien, M,1136277.270.000.000.0077.27
Johnsen, Mario, W,265871920.420.000.00782.991137.43
Mehta, Brett,114508173.260.003374.992370.222428.05
Kim, Kari, S,114458098.030.003399.992304.982393.06
Allen, Hailey, C,26759123.980.000.000.00123.98
Shen, Cedric,2220974.980.000.000.0074.98
Sharma, Misty,257081253.070.00699.100.00553.97
Perez, Dominique,1234468.700.000.0032.2736.43
Gomez, Naomi, E,243004144.340.000.002443.351700.99
Xu, Cedric,181984143.250.003578.270.00564.98
Vance, Denise, L,212054886.700.002443.350.002443.35
Diaz, Nelson, C,213872745.330.002181.560.00563.77
Madan, Kristi, I,291842420.340.000.000.002420.34
Xu, Kara, E,2221239.990.000.000.0039.99
Shen, Dustin,27974553.970.000.000.00553.97
Suri, Rachael, J,18279162.020.000.000.00162.02
Suri, Erick,1663538.880.000.000.0038.88
Goel, April, C,16166108.850.000.0069.9738.88
Pal, Alvin, C,293192447.050.000.000.002447.05
Ramos, Briana, J,143033636.910.000.002049.101587.81
Martin, Jésus,28324548.980.000.000.00548.98
Ward, Shelby,2613239.980.000.0039.980.00
Alonso, Brandi,1706186.270.000.000.0086.27
Nara, Gregory,266511957.470.000.00782.991174.48
Ye, Leah,110778169.030.003374.992374.982419.06
Evans, Mason,154393804.080.000.002049.101754.98
Rodriguez, Bobby,157524408.690.000.002071.422337.27
Ms., Ryan, Justine, J.,230797.280.000.000.007.28
Munoz, Felicia, D,2040659.980.000.000.0059.98
Ramos, Adrienne, L,282167.280.000.007.280.00
Gao, Stacey,166624355.713578.270.00777.440.00
Guo, Cedric, R,274871322.980.000.00782.99539.99
Ruiz, Kristine, J,246074.990.000.000.004.99
Dominguez, Philip,15730122.960.000.000.00122.96
Xu, Colleen,2895614.980.000.000.0014.98
Martin, Roy,2206569.990.000.0069.990.00
Malhotra, Emmanuel,183324752.750.003578.270.001174.48
Chandra, Carmen, R,2331515.230.000.000.0015.23
Wood, Jacqueline,1670597.960.000.000.0097.96
Suri, Kaitlin, C,291902447.050.000.000.002447.05
Martin, Casey, J,2296239.980.000.000.0039.98
Anand, Ricardo,2138369.990.000.000.0069.99
Munoz, Shannon, S,2912249.970.000.000.0049.97
Ramos, Rebekah, L,27984561.480.000.000.00561.48
Garcia, Ruben,196136093.200.003578.270.002514.93
Andersen, Marshall, V,157864366.070.000.002049.102316.97
Moreno, Kristi,234153588.830.000.002443.351145.48
Moreno, Monique, R,231183913.820.000.002181.561732.26
Tang, Nina,274851354.710.000.00782.99571.72
Butler, Hannah, R,131115707.200.000.002071.423635.78
Cook, Victoria, J,206206044.590.003578.270.002466.32
Sanz, Meghan, L,28352562.960.000.000.00562.96
Romero, Wendy, H,113724965.810.003374.990.001590.82
Lu, Candice, I,2120474.980.000.000.0074.98
Sun, Rafael,267491322.980.000.001322.980.00
Deng, Carl,182846029.570.003578.272451.300.00
Sanz, Eddie, A,19580173.930.000.000.00173.93
Ramirez, Cole, E,136166872.060.000.002049.104822.96
Chande, Franklin, L,2023291.950.000.000.0091.95
Sun, Leah,177344698.760.003578.270.001120.49
Nara, Tonya, C,17251123.960.000.0069.9753.99
Goel, Tara, I,143472900.390.000.002071.42828.97
Yuan, Cassie, J,2445360.470.000.000.0060.47
Xie, Nina,12997118.180.000.000.00118.18
Johnson, Emma, M,1513662.270.000.0034.9927.28
Yang, Kevin, F,2060584.960.000.000.0084.96
Zhou, Autumn, L,252292155.920.000.001000.441155.48
Kapoor, Regina,1581067.170.000.000.0067.17
Rubio, Erika, A,114528183.040.003374.992414.992393.06
Sara, Jarrod,206266038.560.003578.270.002460.29
Rodriguez, Evelyn,131176831.420.000.002049.104782.32
Srini, Jay, M,1832662.980.000.000.0062.98
Huang, Jorge,1729186.270.000.0053.9932.28
Lal, Alisha, C,2187234.980.000.000.0034.98
Serrano, Marvin, E,1731697.450.000.000.0097.45
Zeng, Alisha, A,15727134.460.000.000.00134.46
Zheng, Roger,2932149.970.000.000.0049.97
Huang, Eugene, L,110016383.883374.990.002419.93588.96
Gutierrez, Rodney, J,206286056.610.003578.270.002478.34
Deng, Grant, C,1662581.810.000.000.0081.81
Jai, Rafael, L,1732384.960.000.000.0084.96
Henderson, Alexia, M,157174411.370.000.002049.102362.27
Chande, Casey,2614978.980.000.000.0078.98
Sara, Ebony,249232159.400.000.001000.441158.96
Zeng, Barbara,231022730.540.000.002181.56548.98
Adams, Devin,2187129.990.000.000.0029.99
Madan, Terrance,249102183.910.000.001000.441183.47
Goel, Jodi,204476035.600.003578.270.002457.33
Ashe, Marshall,2893293.970.000.000.0093.97
Subram, Rebekah,2603021.490.000.000.0021.49
Chander, Alison,182496044.590.003578.272466.320.00
Moreno, Lori, M,152264391.410.000.002071.422319.99
Ortega, Monique, C,123556818.110.002049.100.004769.01

Generated 2024-11-10 06:15:33.189 UTC