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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Walker, Seth, E,27689539.990.000.000.00539.99
Vance, Kristopher, C,204074.990.000.000.004.99
Ma, Jeffery,1826469.970.000.000.0069.97
Raman, Ronald, M,17077138.450.000.0088.4649.99
She, Willie,170554347.763578.270.000.00769.49
Black, Tonya, M,2125489.970.000.0089.970.00
Morcos, Hany,208214118.260.003578.27539.990.00
Gill, Jay,2797583.470.000.000.0083.47
Beck, Alicia, L,172484382.753578.270.000.00804.48
Liu, Erica, A,2156474.980.000.000.0074.98
Stone, Denise,110326525.563374.990.000.003150.57
Price, Isabella, L,172784382.753578.270.000.00804.48
Jai, Jaime, M,248944.990.000.004.990.00
Alonso, Natasha, L,2500914.980.000.000.0014.98
Taylor, Ashley, E,18215150.970.000.000.00150.97
Nara, Calvin, J,1136786.260.000.000.0086.26
Raman, Geoffrey, P,154353801.390.000.002071.421729.97
She, Kristin, L,1996197.970.000.000.0097.97
Liang, Vincent,204024.990.000.000.004.99
Navarro, Casey,197956044.590.003578.270.002466.32
Ma, Cara,18885110.460.000.00110.460.00
Gill, Alberto, P,177334758.240.003578.270.001179.97
Sun, Mandy, L,1669478.200.000.0039.2238.98
Andersen, Maurice,1520698.960.000.000.0098.96
Ortega, Lawrence,14685146.740.000.000.00146.74
Nara, Jaclyn, M,119305035.810.003399.990.001635.82
Gao, Jamie,260221938.470.00782.990.001155.48
Zheng, Sandra, P,1514163.970.000.000.0063.97
Shen, Carly,2291513.980.000.000.0013.98
Subram, Evelyn, S,212574144.340.002443.350.001700.99
Gonzalez, Savannah, F,156443803.680.000.002071.421732.26
Perez, Johnathan, D,204264139.750.003578.27561.480.00
Munoz, Carolyn, L,173156030.613578.270.000.002452.34
Gomez, Hector, A,2933749.990.000.000.0049.99
Alonso, Ricky, S,140705618.930.000.002049.103569.83
Li, Stacey,140645694.210.000.002071.423622.79
She, Jenny,275861120.490.000.000.001120.49
Henderson, Angela, T,118988179.030.003399.992394.972384.07
Shen, Jaclyn, A,125752668.080.002049.100.00618.98
Arun, Brenda,136306824.730.000.002071.424753.31
Sharma, Christian,1580962.590.000.0032.6029.99
Simmons, Jacqueline, W,13137177.940.000.003.99173.95
Xu, Kelvin,18305160.550.000.000.00160.55
Raman, Jermaine, E,152284375.060.000.002049.102325.96
Zeng, Claudia, M,166964506.763578.270.00928.490.00
Rana, Meagan, M,119148165.960.003374.992329.982460.99
Chander, Clarence, E,1398259.980.000.0034.9924.99
Perez, Brenda,118998189.500.003374.992395.452419.06
Andersen, Tara, L,244653356.040.000.002181.561174.48
Gill, Ricky, A,1560728.980.000.000.0028.98
Mehta, Deanna, P,172806089.593578.270.000.002511.32
Chandra, Rebekah,28486776.330.000.000.00776.33
Pal, Omar,277141155.480.000.000.001155.48
Shan, Yolanda,127026911.100.000.002049.104862.00
Martin, Deanna,130916864.950.000.002071.424793.53
Shan, Jenny, W,1670692.970.000.000.0092.97
Pal, Clayton,27721166.280.000.000.00166.28
Zhu, Christy,110038139.293399.990.002318.962420.34
Simmons, Isabel, H,26432123.980.000.000.00123.98
Dominguez, Joy,221753018.330.000.002443.35574.98
Sun, Edwin, O,2117074.980.000.000.0074.98
Howard, Jesse, D,242492756.540.000.002181.56574.98
Gao, Rosa,2603421.490.000.000.0021.49
Romero, Deanna, K,2357021.980.000.000.0021.98
Diaz, Vanessa, J,29100102.960.000.000.00102.96
Suri, Kari,2526657.980.000.000.0057.98
Hernandez, Danny,2714674.980.000.000.0074.98
Deng, Clayton, G,172856093.203578.270.000.002514.93
Carlson, Shannon, C,110098091.333374.990.002297.282419.06
Lu, Ramon, B,1673844.950.000.0013.9830.97
Raman, Frederick, F,289429.990.000.000.009.99
Suri, Patricia, E,154363772.410.000.002071.421700.99
Pal, Gilbert,27744643.950.000.00643.950.00
Barnes, Isabella, J,252397.280.000.000.007.28
Madan, Raymond, W,208194181.760.003578.27603.490.00
White, Ashley, D,2188739.990.000.0039.990.00
Weber, Deanna, L,148553759.080.000.002049.101709.98
Kapoor, Abby, J,29054751.340.000.000.00751.34
Serrano, Tabitha,283272407.040.000.002407.040.00
Xu, Casey, J,13158221.910.000.0064.97156.94
Huang, Vincent, A,187035314.250.003578.271735.980.00
Scott, Alex, T,143482989.380.000.002071.42917.96
Nara, Yolanda,29080777.340.000.000.00777.34
Gomez, Teresa, D,241642760.020.000.002181.56578.46
Gonzalez, Rebekah, A,1692730.970.000.0030.970.00
Chander, Karla,236484144.340.000.002443.351700.99
Shen, Kelsey, R,229214647.880.000.002181.562466.32
Huang, Lacey, J,1195163.520.000.000.0063.52
Luo, Ashlee,235344179.330.000.002443.351735.98
Srini, Beth, A,259136.280.000.000.006.28
Nara, Ricardo,2893464.470.000.000.0064.47
Gao, Amy,219963946.520.000.002181.561764.96
Moreno, Jessie, C,229064624.910.000.002181.562443.35
Deng, Carl,182846029.570.003578.272451.300.00
Zheng, Curtis, S,236454198.330.000.002443.351754.98
Luo, Nina,2749535.000.000.000.0035.00
Ruiz, Alfredo,2197585.480.000.000.0085.48
Xu, Mindy,202466035.600.003578.270.002457.33
Henderson, Wyatt,1669787.080.000.0057.0929.99
Luo, Julie, M,2912169.970.000.000.0069.97
Shen, Leonard, J,242712745.330.000.002181.56563.77
Malhotra, Marco, L,29459805.330.000.000.00805.33
Diaz, Gerald, M,251187.280.000.000.007.28
Gutierrez, Marvin,259381308.060.00699.100.00608.96
Ortega, Linda, C,117568078.020.003374.990.004703.03
Mr., Short, Carlos, M.,2513960.470.000.000.0060.47
Alvarez, Marvin,236513917.540.000.002181.561735.98
Andersen, Kate,1423790.250.000.000.0090.25
Zeng, Brittney, K,13670178.450.000.0024.49153.96
Anand, Kara,119898139.530.003374.990.004764.54
Patel, Ann,213717.280.000.000.007.28
Hernandez, Jill, L,13003230.250.000.006.28223.97
Lopez, Kristina, L,202476056.610.003578.270.002478.34
Raje, Marshall, J,1926742.280.000.000.0042.28
Gao, Louis,146665199.920.000.002049.103150.82
Shen, Katie, A,202835314.250.003578.270.001735.98
Vazquez, Armando,225712835.020.000.002181.56653.46
Lopez, Barry, R,260201932.460.00782.990.001149.47
Suarez, Ruben,140316964.420.000.002049.104915.32
Liang, Lacey, A,157194429.570.000.002049.102380.47
Martinez, Jay,245923896.530.000.002181.561714.97
Hu, Leah,119948169.030.003374.990.004794.04
Tang, Julie,265891966.460.000.00782.991183.47
Kim, Kari, S,114458098.030.003399.992304.982393.06
Tang, Shawn,258321850.860.00699.100.001151.76
Anand, Andrés,110968063.040.003374.992294.992393.06
Huang, Brent,182206021.620.003578.272443.350.00
Lin, Kelli, A,2139229.990.000.000.0029.99
Suarez, Melody, H,142765259.360.000.002049.103210.26
Hernandez, Joan, J,218924921.690.002443.350.002478.34
Nara, Devon, C,21964103.490.000.000.00103.49
Garcia, Tina,1723183.980.000.000.0083.98
Gonzalez, Heidi, Z,1315724.990.000.000.0024.99
Yuan, Maurice,243804.990.000.000.004.99
Simpson, Tara, K,28107810.320.000.00810.320.00
Suarez, Linda,1666581.810.000.000.0081.81
Lu, Rosa, A,166634471.743578.270.00893.470.00
Flores, Miranda,1724383.980.000.0053.9929.99
Fernandez, Donald, C,244623617.830.000.002443.351174.48
Subram, Joe,136316817.120.000.002049.104768.02
Garcia, Toni,221934886.700.000.002443.352443.35
Yang, Colleen,22167123.980.000.00123.980.00
Gutierrez, Kristine, G,251332155.920.000.001000.441155.48
Black, Shawna, C,152054433.690.000.002071.422362.27
Hernandez, Tabitha, L,1960325.480.000.0025.480.00
Diaz, Felicia, J,1502629.980.000.000.0029.98
Hernandez, Erik, C,2199856.980.000.000.0056.98
Xu, Crystal, E,157544416.380.000.002071.422344.96
Zhou, Cedric,175144142.230.003578.27563.960.00
Serrano, Marvin, E,1731697.450.000.000.0097.45
Yang, Alan, L,1560539.970.000.000.0039.97
Ye, Krystal, M,269231322.980.000.00782.99539.99
Jimenez, Julio,240052756.540.000.002181.56574.98
Fernandez, Lydia, M,145233807.400.000.002071.421735.98
Romero, Diane, F,219474632.860.002181.560.002451.30
Gonzalez, Cynthia,15787167.930.000.000.00167.93
Sara, Troy, R,225832821.510.000.002181.56639.95
Jones, Ethan,130516831.740.000.002071.424760.32
Vazquez, Mallory, M,18283119.950.000.000.00119.95
Zhu, Dawn,266611912.470.000.00782.991129.48
Xu, Roger,2796839.980.000.0039.980.00
Dominguez, Kristine, A,140206831.760.000.002071.424760.34
Serrano, Anne,242443617.830.000.002443.351174.48
Suarez, Pedro, A,246112219.420.001000.441218.980.00
Rubio, Pedro, E,230982745.330.000.002181.56563.77
Sanchez, Abby, J,199666021.620.003578.270.002443.35
Raman, Ruben,155802910.900.000.002071.42839.48
Deng, Russell, J,2031467.930.000.000.0067.93
Anderson, Blake,110768159.040.003399.992374.982384.07
Chande, Michele, C,130786850.460.000.002071.424779.04
Malhotra, Stanley, H,114538176.980.003374.992382.932419.06
Cox, Isaac,157974415.680.000.002071.422344.26
Romero, Meredith, J,29452742.350.000.000.00742.35
Rodriguez, Allen, L,177324752.750.003578.270.001174.48
Guo, Krystal, S,17381188.930.000.00188.930.00
Ruiz, Naomi,236493945.530.000.002181.561763.97
Garcia, Rebekah, M,140073772.410.000.003772.410.00
Rodriguez, Pamela,29065777.340.000.000.00777.34
Jai, Latoya, S,212294198.330.002443.350.001754.98
Kumar, Mindy, R,127006860.440.000.002071.424789.02
Wu, Christy, D,255681253.070.00699.100.00553.97
Gomez, Marc, J,2188039.990.000.000.0039.99
Guo, Margaret,234314158.320.000.002443.351714.97
Ortega, Latasha,242702844.510.000.002181.56662.95
He, Susan, A,244673337.040.000.002181.561155.48
Navarro, Jaime, T,27690574.980.000.000.00574.98
Moreno, Lori, M,152264391.410.000.002071.422319.99
Chen, Cedric, R,170654417.753578.270.000.00839.48
Ramos, Craig,14209193.970.000.004.99188.98
Ruiz, Hector,275924.990.000.000.004.99
Ramos, Rodney, C,14059106.750.000.0074.4832.27
Martinez, Tyler, T,282012419.060.000.002419.060.00
Kumar, Tonya, A,229344173.320.000.002443.351729.97
Williams, Madison, J,2119869.970.000.000.0069.97
Collins, Rebecca, M,261531957.470.00782.990.001174.48
Goel, Jodi,204476035.600.003578.270.002457.33
Sullivan, Summer, E,2118132.280.000.000.0032.28
Ashe, Jimmy, S,2895914.980.000.000.0014.98
Ma, Warren, A,1976248.970.000.000.0048.97
Martin, Craig, M,2501274.460.000.000.0074.46
Zhang, Cara,12351117.970.000.000.00117.97
Martin, Beth, K,2331739.980.000.000.0039.98
Navarro, Rodney, L,293092419.060.000.000.002419.06
Rai, Alejandro, R,2199099.470.000.000.0099.47
Shen, Alison, A,1661471.160.000.000.0071.16
Shen, Nichole,129996840.460.000.002071.424769.04
Zhu, Louis,14858196.970.000.00187.988.99
Cooper, Allison, J,29294553.970.000.000.00553.97
Chapman, Jodi, L,229663917.540.000.002181.561735.98
Martin, Natasha, N,274901331.970.000.00782.99548.98
Wu, Amy,197906089.590.003578.270.002511.32
Ma, Dawn, A,1395682.260.000.000.0082.26
Gill, Joanna,2618638.980.000.000.0038.98
Xie, Drew, A,20218104.690.000.000.00104.69
Green, Devin, J,264401957.470.000.00782.991174.48
_SUM9051988.22588293.382372161.832474601.913616931.10
Raman, Cassandra,2871867.970.000.000.0067.97
Sun, Shannon,120077023.780.003399.990.003623.79
Pal, Lacey, K,265711938.470.000.00782.991155.48
Perez, Joel,166844158.243578.270.000.00579.97
Zheng, Darryl,187066060.500.003578.272482.230.00
Shen, Kelvin,224063018.330.000.002443.35574.98
Collins, Andrea,122503964.980.003399.990.00564.99
Murphy, Grace, J,236554144.340.000.002443.351700.99
Shan, Brad, H,196055314.250.003578.270.001735.98
Lopez, Heidi,110528131.323374.990.002337.272419.06
Liang, Ronnie,2458430.480.000.000.0030.48
Yang, Stacey,142155665.890.000.002049.103616.79
Wu, Jamie, S,2759564.470.000.000.0064.47
Raman, Abby, T,151225193.720.000.002071.423122.30
Vazquez, Danny, J,260331903.480.00782.990.001120.49
Lopez, Adriana, A,120028145.330.003374.990.004770.34
Allen, Mary,212034633.900.002181.560.002452.34
Navarro, Leslie, E,243714193.820.000.002443.351750.47
Romero, Ricky,213612997.320.002443.350.00553.97
Kumar, Cristina, N,15426115.920.000.00106.938.99
Suarez, Jerome, L,206226139.590.003578.270.002561.32
Kumar, Louis, A,182034172.250.003578.270.00593.98
Sutton, Jaime, L,166305973.243578.270.000.002394.97
Dominguez, Lee, R,245974009.500.000.002181.561827.94
Patel, Rachael, G,1364071.250.000.0032.2738.98
Yang, Crystal, A,236654207.320.000.002443.351763.97
Lal, Mario, T,233454.990.000.000.004.99
Lin, Alan,229737.280.000.000.007.28
Dominguez, Jimmy,219594702.390.002181.560.002520.83
Griffin, Olivia,2120839.980.000.000.0039.98
Sanchez, Bryant, C,131136832.410.000.002071.424760.99
Ward, Brooke,130075671.240.000.002071.423599.82
Fernandez, Marie,289297.280.000.000.007.28
Shan, Deborah,206246021.620.003578.270.002443.35

Generated 2025-11-01 05:40:08.963 UTC