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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Gill, Joanna,2618638.980.000.000.0038.98
Xu, Willie, C,131606839.460.000.002071.424768.04
Madan, Denise, R,2524839.980.000.000.0039.98
Prasad, Tabitha, D,267611938.470.000.00782.991155.48
Nelson, Mary, L,131075650.900.000.002049.103601.80
Martin, Ricky, C,16608101.570.000.0071.5829.99
Zhao, Alisha, M,2198835.000.000.000.0035.00
Malhotra, Emmanuel,183324752.750.003578.270.001174.48
Allen, Logan,1581281.250.000.000.0081.25
Chande, Alvin, W,2489323.780.000.000.0023.78
Perez, Brett, M,28313647.940.000.000.00647.94
Ray, Bobby,235753302.050.000.002181.561120.49
Arun, Gerald,259401277.560.00699.100.00578.46
Xu, Arturo,136196808.100.000.002049.104759.00
Ashe, Barbara,1873424.270.000.000.0024.27
Hernandez, Kellie, A,125862636.410.002071.420.00564.99
Carlson, Marie,29311603.960.000.000.00603.96
Jiménez, Brandi,243784173.320.000.002443.351729.97
Xu, Kristen,157514446.400.000.002071.422374.98
Guo, Jaclyn,131196829.450.000.002071.424758.03
Foster, Aidan,264451938.470.000.00782.991155.48
Andersen, Calvin,2292091.950.000.000.0091.95
Jai, Gregory,1634246.470.000.000.0046.47
Sharma, Misty,257081253.070.00699.100.00553.97
Sanz, Walter, J,1819594.470.000.000.0094.47
Black, Rafael,1196655.760.000.000.0055.76
Shen, Katrina,158014381.380.000.002049.102332.28
Cox, Catherine, K,131226871.430.000.002071.424800.01
Luo, Mario, L,257111274.080.00699.100.00574.98
Serrano, Marvin, E,1731697.450.000.000.0097.45
Huang, Colleen, S,213792992.330.002443.350.00548.98
Shan, Yolanda,127026911.100.000.002049.104862.00
Ye, Tamara, A,2024360.470.000.000.0060.47
Pal, Alison,1304284.470.000.000.0084.47
Gill, Stacy,12679187.980.000.0024.99162.99
Ramos, Rebekah, L,27984561.480.000.000.00561.48
Lal, Alicia,157344426.410.000.002071.422354.99
Tang, Nina,274851354.710.000.00782.99571.72
Blanco, Erika, L,1466990.250.000.000.0090.25
Hernandez, Frank, G,221984661.500.000.002181.562479.94
She, Katie, B,11965118.740.000.0094.2524.49
Yuan, Derek, L,275891183.470.000.000.001183.47
Rai, Michele, M,265671957.470.000.00782.991174.48
Shen, Lindsey,265601396.440.000.00782.99613.45
Pal, Roger, D,2770539.980.000.000.0039.98
Long, Megan, J,1579142.260.000.0024.9917.27
Green, Kyle,283284.990.000.000.004.99
Long, Mariah, C,1673068.970.000.000.0068.97
Nara, Jaclyn, M,119305035.810.003399.990.001635.82
Arun, Brenda,136306824.730.000.002071.424753.31
Vazquez, Ross,11148126.240.000.0053.9972.25
Rodriguez, Toni, J,2525139.980.000.000.0039.98
Romero, Philip, F,221954909.670.000.002443.352466.32
Xu, Martha, C,163515873.263578.270.000.002294.99
Patterson, Jennifer, M,151295177.730.000.002071.423106.31
Martin, Diane,139586838.640.000.002049.104789.54
Romero, Ebony, A,2771712.940.000.000.0012.94
Dominguez, Larry,221974740.980.000.002181.562559.42
Tang, Julie,265891966.460.000.00782.991183.47
Williams, Anna, R,175044362.740.003578.270.00784.47
Perez, Kyle, J,161804386.370.000.002049.102337.27
Prasad, Jarrod,113594960.070.003374.990.001585.08
Raman, Deanna, H,17053123.960.000.000.00123.96
Zhou, Kelvin,2023160.470.000.000.0060.47
Hu, Barbara,19567104.960.000.0075.9728.99
Kumar, Tommy,17297100.250.000.0037.2762.98
Prasad, Edgar, E,17306117.960.000.0034.9982.97
Jenkins, Anna, M,1723491.260.000.000.0091.26
Gill, Kristy,13669102.430.000.000.00102.43
Sara, Cesar, C,221722932.300.000.002181.56750.74
Vazquez, Jésus,2666578.980.000.000.0078.98
Yang, Wesley, K,151275182.730.000.002071.423111.31
Wang, Nathan,140396808.130.000.002049.104759.03
Sanz, Renee, L,14319138.450.000.000.00138.45
Zeng, Alisha, A,15727134.460.000.000.00134.46
Rai, Rafael, H,18715123.960.000.000.00123.96
Vazquez, Anne,160273826.400.000.002071.421754.98
Sanz, Jamie,265491361.450.000.00782.99578.46
Sanz, Eddie, A,19580173.930.000.000.00173.93
Xu, Alisha,14100226.260.000.000.00226.26
Sun, Jorge,160253831.890.000.002071.421760.47
Vazquez, Eddie, T,140125249.920.000.002049.103200.82
Cox, Michelle, E,173284387.743578.270.000.00809.47
Butler, Hannah, R,131115707.200.000.002071.423635.78
Ma, Roger, V,151305215.400.000.002049.103166.30
Martinez, Tina, J,184614748.240.003578.270.001169.97
Nath, Melvin, D,276971120.490.000.000.001120.49
Chen, Louis, J,17059123.960.000.000.00123.96
Bell, Isabella,276981179.970.000.000.001179.97
Suri, Kristopher, M,2284950.230.000.000.0050.23
Lee, David, J,221994693.880.000.002181.562512.32
Luo, Lindsey, R,222015012.270.000.002443.352568.92
Garcia, Stefanie, E,277431155.480.000.000.001155.48
King, Evan,166375900.553578.270.000.002322.28
Cai, Jeffery, A,155822907.560.000.002049.10858.46
Liang, Alejandro, W,2919349.970.000.000.0049.97
Deng, Kurt, D,13635215.740.000.0032.27183.47
Martinez, Roy, J,1396977.270.000.000.0077.27
Dominguez, Lee, R,245974009.500.000.002181.561827.94
Kumar, Tonya, A,229344173.320.000.002443.351729.97
Zhang, Kristen,274841322.980.000.00782.99539.99
Gonzalez, Cynthia,15787167.930.000.000.00167.93
Lu, Alan,1976167.930.000.000.0067.93
Jones, Ethan,130516831.740.000.002071.424760.32
Sai, Ivan, E,1730094.220.000.000.0094.22
Gutierrez, Lawrence, M,195645293.240.003578.270.001714.97
Mehta, Nancy,181894118.260.003578.270.00539.99
She, Jerry, C,142775196.740.000.002071.423125.32
Hayes, Eric, A,22964123.980.000.000.00123.98
Ashe, Marshall,2893293.970.000.000.0093.97
Andersen, Nina,183386124.580.003578.270.002546.31
Wu, Shannon, F,152682840.910.000.002071.42769.49
Munoz, Meredith,139575645.240.000.002071.423573.82
Deng, Kenneth,2023534.980.000.000.0034.98
Chandra, Andre, L,2526235.720.000.000.0035.72
Jai, Brendan,26755123.980.000.000.00123.98
Torres, Melinda, J,140336809.960.000.002071.424738.54
Jai, Rafael, L,1732384.960.000.008.9975.97
Raje, Donna, A,2060723.780.000.000.0023.78
Guo, Cedric, R,274871322.980.000.00782.99539.99
Martin, Natasha, N,274901331.970.000.00782.99548.98
Raji, Andres, E,139556888.440.000.002071.424817.02
Dominguez, Raquel, A,274701371.950.000.00782.99588.96
Shan, Thomas, N,274831382.460.000.00782.99599.47
He, Eugene, L,136456817.120.000.002049.104768.02
Ye, Krystal, M,269231322.980.000.00782.99539.99
Foster, Madison,140386819.120.000.002049.104770.02
Munoz, Cheryl, C,136326838.460.000.002071.424767.04
Morgan, Melissa, M,2022274.450.000.000.0074.45
Liang, Omar,2424517.270.000.000.0017.27
Baker, Jose, A,229374179.330.000.002443.351735.98
Raje, Johnny,139755138.720.000.002049.103089.62
Chen, Jon,269201336.960.000.00782.99553.97
Gonzalez, Carla, J,183366145.070.003578.270.002566.80
Turner, Rebecca, W,276991155.480.000.000.001155.48
Wu, Glenn, R,29343553.970.000.000.00553.97
Fernandez, Brenda, L,164934197.253578.270.000.00618.98
Johnsen, Mario, W,265871920.420.000.00782.991137.43
Sullivan, Ruth,277231155.480.000.000.001155.48
Hernandez, Gina,140495290.680.000.002071.423219.26
Rodriguez, Rachael, M,119444776.270.003374.99609.96791.32
Xu, Barbara,1407459.880.000.000.0059.88
Perez, Geoffrey, P,210002721.550.002181.560.00539.99
Xie, Clarence,224022721.550.000.002181.56539.99
Lopez, Heidi,110528131.323374.990.002337.272419.06
Raje, Shawn,1705483.980.000.000.0083.98
Rana, Carla, K,195935306.540.003578.270.001728.27
Diaz, Nelson, C,213872745.330.002181.560.00563.77
Henderson, Marcus, D,1521268.960.000.000.0068.96
Martin, Hector,27860615.470.000.000.00615.47
Washington, Sydney,289244.990.000.000.004.99
Zhou, Gilbert,244753945.530.000.002181.561763.97
Sun, Brittney,113655024.790.003374.990.001649.80
Saunders, Brandy,119464697.310.003399.99554.97742.35
Sharma, Arturo,136486765.440.000.002049.104716.34
Navarro, Marc,1634637.550.000.000.0037.55
Vazquez, Joan, B,16332147.230.000.000.00147.23
Shen, Mitchell, M,229044759.990.000.002181.562578.43
Lopez, Dominic, B,275901189.460.000.000.001189.46
Zheng, Sandra, P,1514163.970.000.000.0063.97
Yuan, Darrell,18271119.950.000.000.00119.95
Hayes, Edward,1579634.990.000.000.0034.99
Kovar, Nancy, F,265681957.470.000.00782.991174.48
Gill, Anne,274691331.970.000.00782.99548.98
Liang, Eugene,1397277.270.000.000.0077.27
Schmidt, Joe, M,229054624.910.000.002181.562443.35
Tang, Dawn, R,164965960.233578.270.000.002381.96
Dominguez, Darren, M,139666842.120.000.002049.104793.02
Raji, Christy,1558462.270.000.0034.9927.28
Suarez, Gina,2024869.970.000.000.0069.97
Lal, Bradley,131562663.690.000.002071.42592.27
Zhang, Alejandro, P,21992184.260.000.000.00184.26
Kumar, Gilbert, L,2814039.980.000.000.0039.98
Lin, Alan,229737.280.000.000.007.28
Kumar, Alejandro,140555177.400.000.002049.103128.30
Madan, Stanley,196026093.200.003578.270.002514.93
Sanchez, Clifford,21188123.960.000.000.00123.96
Sara, Phillip, R,2511639.980.000.000.0039.98
Ma, Jessie,290926.280.000.000.006.28
Arthur, Raymond, S,202286093.200.003578.270.002514.93
Andersen, Maurice,1520698.960.000.000.0098.96
Luo, Alison, A,2352756.970.000.000.0056.97
Nara, Willie,244603302.050.000.002181.561120.49
Nath, Michele, L,110568207.503374.990.002413.452419.06
Perez, Preston,1237061.530.000.0034.5626.97
Sai, Ruth, D,244613302.050.000.002181.561120.49
Nath, Bethany,16177133.340.000.000.00133.34
Scott, Timothy,196315279.260.003578.270.001700.99
Griffin, Caroline,177264721.730.003578.270.001143.46
Sharma, Clayton, D,122403964.980.003399.990.00564.99
Wang, Valerie,202176089.590.003578.270.002511.32
Andersen, Tara, L,244653356.040.000.002181.561174.48
Vazquez, Theresa, F,225812749.320.000.002181.56567.76
Lopez, Cesar,17500156.960.000.000.00156.96
Shen, Kelvin,224063018.330.000.002443.35574.98
Weber, Ivan,28317539.990.000.000.00539.99
Muñoz, Ruben, L,114518249.490.003399.992366.942482.56
Flores, Miranda,1724383.980.000.0053.9929.99
Guo, Jake, P,1996998.450.000.0067.9730.48
Madan, Kristopher, A,252387.280.000.000.007.28
Jackson, Joshua,1723583.980.000.000.0083.98
Carlson, Wendy,202206060.500.003578.270.002482.23
Chande, Cassie,111038182.500.003374.992388.452419.06
Malhotra, Joel, E,1634358.250.000.000.0058.25
Xylaras, Ioannis,202155279.260.003578.270.001700.99
Liang, Alan, L,29063801.830.000.000.00801.83
Griffin, Brianna, K,1648773.240.000.000.0073.24
Shen, Russell, M,11150192.420.000.00143.4548.97
Alonso, Stacy,28315556.930.000.000.00556.93
Malhotra, Cynthia,113585034.780.003374.990.001659.79
Ye, Amy,11073191.900.000.00103.9687.94
Yuan, Marshall, P,199786060.500.003578.270.002482.23
Blanco, Orlando,225753018.330.000.002443.35574.98
Chande, Melvin, R,114608137.520.003399.992294.992442.54
Kumar, Barbara, N,274991331.970.000.00782.99548.98
Martinez, Emma,16734128.970.000.000.00128.97
Zhou, Carol, L,2445421.490.000.000.0021.49
Shan, Franklin, C,2771858.980.000.000.0058.98
Diaz, Devin, D,15829187.980.000.000.00187.98
Alonso, Jonathon, A,1523898.960.000.000.0098.96
Nara, Tonya, C,17251123.960.000.0069.9753.99
Sun, Franklin,196155279.260.003578.270.001700.99
Perez, Arthur, L,165264758.243578.270.000.001179.97
Xu, Tony, L,225762721.550.000.002181.56539.99
Rana, Stefanie, K,196165279.260.003578.270.001700.99
Suarez, Alfredo,196015314.250.003578.270.001735.98
Suarez, Billy, M,1728795.260.000.000.0095.26
Torres, Joanna, E,244644.990.000.000.004.99
Lin, Jeffery, J,2734778.980.000.000.0078.98
Carlson, Jose,1995474.450.000.0060.4713.98
Sanders, Kaylee, C,202216035.600.003578.270.002457.33
Mehta, Arthur, A,199576035.600.003578.270.002457.33
Sara, Edgar, A,111048173.030.003399.992334.982438.06
Liu, Jessie,111068079.050.003399.992294.992384.07
Sara, Ruben, A,19566164.910.000.000.00164.91
Rodriguez, Heidi, L,251202155.920.000.001000.441155.48
Zheng, Edwin, J,142165653.920.000.002049.103604.82
Mehta, Brett,114508173.260.003374.992370.222428.05
Gill, Billy, L,1670092.970.000.000.0092.97
Becker, Latoya, W,1733030.970.000.000.0030.97
Patel, Cynthia, M,15222123.450.000.000.00123.45
Alonso, Gloria, S,199646056.610.003578.270.002478.34
Gutierrez, Jonathon, R,165294752.753578.270.000.001174.48
Brown, Cameron, D,13041153.950.000.000.00153.95
Powell, Aaron,252414.990.000.000.004.99
Ortega, Jill, A,202396093.200.003578.270.002514.93
Fernandez, George,199746021.620.003578.270.002443.35
Jimenez, Jimmy,273651371.950.000.00782.99588.96
Yang, Clarence, D,251212155.920.000.001000.441155.48
Yang, Louis, J,2301312.940.000.000.0012.94

Generated 2025-11-02 00:23:10.570 UTC