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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Andersen, Ashlee, J,11059116.930.000.00116.930.00
Deng, Tasha,114598141.330.003399.992322.282419.06
Moore, Natalie, W,182736104.210.003578.272525.940.00
Huang, Lisa, L,141023667.230.000.002910.90756.33
Lal, Julie, A,283092419.060.000.002419.060.00
Lal, Tommy,1451678.980.000.0024.9953.99
Deng, Peter, A,240062721.550.000.002181.56539.99
Zhang, Warren, L,252521893.05699.100.000.001193.95
Wu, Micah,172464380.043578.270.000.00801.77
Ashe, Kathryn,1616880.110.000.0034.8945.22
Liang, Rosa, L,197704127.250.003578.27548.980.00
Lopez, Cesar,17500156.960.000.000.00156.96
Kapoor, Bryant,229463911.530.000.003911.530.00
Chavez, Colin,1603290.950.000.0021.9868.97
Baker, Luke, J,2295239.980.000.0039.980.00
Kovár, Donald, M,242779.990.000.009.990.00
Garcia, Jermaine,2156642.280.000.0042.280.00
Zeng, Jon, O,143105200.660.000.002071.423129.24
Navarro, Mathew, A,1967337.290.000.000.0037.29
Sanchez, Olivia, J,14278177.460.000.000.00177.46
Carlson, Philip, P,119158143.000.003374.992369.962398.05
Rana, Molly,2155474.980.000.000.0074.98
Mehta, Jay, S,150353772.410.000.002071.421700.99
Sara, Ebony,249232159.400.000.001000.441158.96
Raji, Grant, R,1618528.980.000.000.0028.98
Serrano, Leslie, T,1401462.270.000.000.0062.27
Gutierrez, Natasha,170484382.753578.270.000.00804.48
Rana, Whitney, A,130066762.150.000.002049.104713.05
Gutierrez, Ricky,197736056.610.003578.270.002478.34
Cai, Warren,249182120.930.000.001000.441120.49
Xie, Marshall, M,1979613.980.000.0013.980.00
Vazquez, Joe, C,204184207.240.003578.27628.970.00
Guo, Jamie,201514152.730.003578.27574.460.00
Deng, Carl,182846029.570.003578.272451.300.00
Madan, Marco,1889527.770.000.0027.770.00
Zhang, Suzanne, R,2031639.980.000.0039.980.00
Martin, Roy,2206569.990.000.0069.990.00
Shan, Yolanda,127026911.100.000.002049.104862.00
Shen, Shaun,126846893.080.002049.100.004843.98
Zhou, Laura, D,126836801.450.002071.420.004730.03
Jimenez, Victor,114618089.040.003374.992294.992419.06
Cai, Gilbert, J,1825698.960.000.0063.9734.99
Andersen, Mitchell, H,250266.280.000.006.280.00
Dominguez, Ebony, R,17350127.470.000.0034.9992.48
Subram, Martin, S,1959032.280.000.0032.280.00
Sun, Jaclyn,1821165.960.000.0056.978.99
Yang, Cedric,150383750.090.000.002049.101700.99
Raman, Johnathan,1910363.910.000.0041.9321.98
Raje, Jodi, E,1963074.450.000.000.0074.45
Kapoor, Pedro, H,242297.280.000.000.007.28
Ruiz, Adrienne,1352367.260.000.000.0067.26
Hu, Barbara,19567104.960.000.0075.9728.99
Sanz, Marvin,196126029.570.003578.270.002451.30
Zhao, Jessie, R,110276591.573399.990.000.003191.58
Martinez, Anna, J,129946855.440.000.002071.424784.02
Nara, Derek, A,2613934.470.000.0034.470.00
Liu, Steve, V,235233337.040.000.003337.040.00
White, Kayla,2642479.470.000.0079.470.00
Zhou, Trisha, B,126866864.460.002071.420.004793.04
Sai, Ivan, E,1730094.220.000.000.0094.22
Gomez, Adrienne,119208156.320.003374.990.004781.33
Mehta, Nancy,181894118.260.003578.270.00539.99
She, Jerry, C,142775196.740.000.002071.423125.32
Gao, Jorge,235733337.040.000.002181.561155.48
Rivera, Devin, J,251094.990.000.000.004.99
Hayes, Eric, A,22964123.980.000.000.00123.98
Alvarez, Max, M,119868245.230.003399.990.004845.24
Zhao, Glenn, C,1422182.260.000.0049.9932.27
Gao, Curtis, D,204295377.750.003578.270.001799.48
Schmidt, Kaitlin,13628191.250.000.000.00191.25
Yuan, Ricardo,1667476.150.000.000.0076.15
Hu, Valerie, M,150443803.560.000.002049.101754.46
Xu, Clayton,184886056.610.003578.272478.340.00
Martin, Naomi, A,15593116.260.000.0088.9827.28
Mehta, Evelyn, S,204204132.240.003578.27553.970.00
Torres, Sabrina, E,204254118.260.003578.27539.990.00
Rana, Jermaine, S,289272419.060.000.002419.060.00
Perez, Brenda,118998189.500.003374.992395.452419.06
Martin, Adrienne,1995239.460.000.0025.4813.98
Lopez, Heidi,110528131.323374.990.002337.272419.06
Ramirez, Olivia, D,197856076.610.003578.270.002498.34
Rodriguez, Carolyn,210022992.330.002443.350.00548.98
Raman, Harold, F,28484778.620.000.000.00778.62
Wang, Erica, J,221682997.320.000.002443.35553.97
Alvarez, Reginald, A,187466135.090.003578.272556.820.00
Patel, Marco, L,1957560.050.000.0023.7836.27
Zeng, Colleen, L,2830491.970.000.0091.970.00
Collins, Logan, H,13983180.410.000.00145.4234.99
Zhang, Clarence, M,130016799.430.000.002049.104750.33
Perez, Bryant, L,150423807.400.000.002071.421735.98
Ortega, Tyrone, H,125832646.400.002071.420.00574.98
Raji, Jaime, L,150373856.380.000.002071.421784.96
Cai, Susan,19101104.420.000.000.00104.42
Li, Edwin,269671336.960.000.001336.960.00
Suarez, Meghan, L,2217724.270.000.000.0024.27
Andersen, Brendan,151215202.730.000.002071.423131.31
Alonso, Brandi,1706186.270.000.000.0086.27
Rai, Raul, R,151335237.730.000.002071.423166.31
Sanz, Nelson, M,1405649.480.000.000.0049.48
Huang, Lacey, J,1195163.520.000.000.0063.52
Hernandez, Jill, L,13003230.250.000.006.28223.97
Prasad, Ebony,243683946.520.000.002181.561764.96
Fernandez, Marie,289297.280.000.000.007.28
Kovar, Mayra, J,173124471.743578.270.000.00893.47
Liang, Eugene,1397277.270.000.000.0077.27
Yuan, Christine,110466616.813374.990.000.003241.82
Rai, Tasha, L,243014144.340.000.002443.351700.99
Hernandez, Diana, F,110386437.333374.990.000.003062.34
Ye, Erica, E,130105716.520.000.002071.423645.10
Guo, Lisa, S,1731478.960.000.000.0078.96
Prasad, Brandy, P,1400963.970.000.000.0063.97
Ruiz, Francis, D,2138169.990.000.000.0069.99
Wang, Jon, A,261911938.470.000.00782.991155.48
Schmidt, Danny, M,289267.280.000.000.007.28
Serrano, Alfredo,212583936.540.002181.560.001754.98
Srini, Candace,154372.290.000.000.002.29
Jai, Drew, M,215624632.860.002181.560.002451.30
Sara, Ross,243674179.330.000.002443.351735.98
Ashe, Orlando, I,118978203.020.003399.990.004803.03
Deng, Jodi,161612700.050.000.002049.10650.95
Ortega, Felicia, J,1175347.920.000.000.0047.92
Martinez, Heidi, L,2292268.970.000.000.0068.97
Wilson, Edward, L,265621925.410.000.00782.991142.42
Yuan, Willie,234214208.310.000.002443.351764.96
Sanchez, Troy, H,255591253.07699.100.000.00553.97
Ye, Damien, M,136206848.070.000.002049.104798.97
Becker, Julie,13614114.210.000.000.00114.21
Arun, Brenda,136306824.730.000.002071.424753.31
Zhang, James,1468438.550.000.000.0038.55
Yang, Clarence, D,251212155.920.000.001000.441155.48
Serrano, Beth,243043946.520.000.002181.561764.96
Srini, Manuel,241682790.520.000.002181.56608.96
Xie, Karla,182014157.730.003578.270.00579.46
Raman, Ruben,155802910.900.000.002071.42839.48
Edwards, Carlos,16680104.860.000.000.00104.86
Sanchez, Andre,155954369.090.000.002049.102319.99
Xu, Martha, C,163515873.263578.270.000.002294.99
Bhat, Yolanda,152254401.410.000.002071.422329.99
Raje, Devon,292892433.040.000.000.002433.04
Wu, Shannon, F,152682840.910.000.002071.42769.49
Lal, Shawna,179244733.750.003578.270.001155.48
Sai, Ann,273391336.960.000.00782.99553.97
Jai, Warren, S,164834118.263578.270.000.00539.99
Suri, Patricia, E,154363772.410.000.002071.421700.99
Zheng, Aimee, H,242833946.520.000.002181.561764.96
Alonso, Meghan, A,244573356.040.000.002181.561174.48
Watson, Alexandra, H,252491868.56699.100.000.001169.46
Rai, Calvin,152292833.570.000.002049.10784.47
Raji, Misty,165204727.743578.270.000.001149.47
Deng, Priscilla, M,251272174.920.000.001000.441174.48
Gonzales, Logan,166075897.533578.270.000.002319.26
Deng, Kate, L,157234444.070.000.002049.102394.97
Vazquez, Daisy, L,255601288.060.00699.100.00588.96
Rodriguez, Frederick, S,244584144.340.000.002443.351700.99
Beck, Alejandro,110256576.803374.990.002405.47796.34
Subram, Douglas,273521357.970.000.00782.99574.98
West, Colleen, C,131286817.140.000.002049.104768.04
Prasad, Henry, M,243643965.520.000.002181.561783.96
Torres, Ruben,110028114.043399.990.004714.050.00
Arun, Troy, P,152214447.870.000.002071.422376.45
Sanchez, Terrance,19584116.740.000.0088.9727.77
Bell, Stephanie, A,273701322.980.000.00782.99539.99
Arthur, Tabitha, E,164824783.743578.270.001205.470.00
Evans, Jackson,1432127.280.000.000.0027.28
Wang, Curtis, A,131085718.660.000.002071.423647.24
Chander, Marshall,1909059.260.000.002.2956.97
Garcia, Andre, H,127056854.110.000.002049.104805.01
Jai, Katrina,1304459.980.000.000.0059.98
Huang, Eugene, L,110016383.883374.990.002419.93588.96
Luo, Bethany,1958236.270.000.000.0036.27
Rodriguez, Monica, J,289519.990.000.000.009.99
Chapman, Kristi, l,219863882.550.000.002181.561700.99
Sanz, Eddie, A,19580173.930.000.000.00173.93
Hernandez, Javier, A,161564344.090.000.002049.102294.99
Moreno, Jimmy, L,110296565.293399.990.000.003165.30
Chande, Michele, C,130786850.460.000.002071.424779.04
Shen, Priscilla, A,28215589.960.000.000.00589.96
Gutierrez, Cheryl, O,252132184.900.000.001000.441184.46
Huang, Sandra, C,165234698.763578.270.000.001120.49
Moreno, Lori, M,152264391.410.000.002071.422319.99
Patel, Monica, J,252342174.920.000.001000.441174.48
Gonzalez, Savannah, F,156443803.680.000.002071.421732.26
Ramos, Theresa, G,110316478.603399.990.000.003078.61
Sai, Tina, L,154253772.410.000.002071.421700.99
Walker, Anthony, T,252501883.56699.100.000.001184.46
Rana, Henry,273421348.460.000.00782.99565.47
Serrano, Max, E,120108203.500.003374.990.004828.51
Rodriguez, Francisco,243613391.030.000.002181.561209.47
Ms., Rusek, Pearlie, J.,219454886.700.002443.350.002443.35
Wood, Richard, W,243773945.530.000.002181.561763.97
Chapman, Kathryn,119888078.020.003374.990.004703.03
Nara, Willie,244603302.050.000.002181.561120.49
Alexander, Olivia, L,146675295.410.000.002049.103246.31
Fernandez, Donald, C,244623617.830.000.002443.351174.48
Gill, Monique, L,1772721.980.000.000.0021.98
Ward, Jessica,155874423.380.000.002071.422351.96
Diaz, Gloria,252701854.58699.100.000.001155.48
Davis, Morgan, J,273591344.470.000.00782.99561.48
Gonzalez, Ebony,110346491.323399.990.000.003091.33
Garcia, Roy, H,155854367.020.000.002049.102317.92
Martinez, Emmanuel, V,2137039.980.000.000.0039.98
Wu, Marshall, J,155904440.050.000.002049.102390.95
Powell, Lucas, T,18278158.950.000.000.00158.95
Goel, Gilbert,155964460.040.000.002049.102410.94
Shen, Nichole,129996840.460.000.002071.424769.04
Luo, Melvin,243664144.340.000.002443.351700.99
Price, Megan,249072183.910.000.001000.441183.47
Blanco, Victor,155864469.370.000.002071.422397.95
Lal, Devon, L,1523766.260.000.000.0066.26
Lopez, Mayra, E,273561336.960.000.00782.99553.97
Diaz, Samuel,140655608.550.000.002071.423537.13
Diaz, Megan, A,243034207.320.000.002443.351763.97
Zhou, Autumn, L,252292155.920.000.001000.441155.48
Anand, Chad,244843563.840.000.002443.351120.49
Raje, Ashlee, E,166585873.263578.270.000.002294.99
Andersen, Tara, L,244653356.040.000.002181.561174.48
Rana, Evelyn, D,18262142.450.000.000.00142.45
Brooks, Jared,244763563.840.000.002443.351120.49
Lal, Karla,2521939.980.000.000.0039.98
Zhang, Edwin,157854454.350.000.002071.422382.93
She, Alvin, E,166575900.553578.270.000.002322.28
Hall, Haley,274891383.450.000.00782.99600.46
Nelson, Sophia,166644377.753578.270.00799.480.00
Martin, Natasha, N,274901331.970.000.00782.99548.98
Coleman, Melanie, H,1563934.570.000.000.0034.57
Gonzalez, Eric, C,1909278.260.000.000.0078.26
Ye, Dennis, M,166385974.233578.270.000.002395.96
Blanco, Natasha,158084424.080.000.002049.102374.98
Jimenez, Jacquelyn,143043595.930.000.002049.101546.83
Allen, Ian, A,160313750.090.000.002049.101700.99
Rubio, Jay,151794444.890.000.002071.422373.47
He, Omar,158312646.360.000.002646.360.00
Diaz, Rebekah, J,2137878.980.000.000.0078.98
Gomez, Kathleen, J,161584369.090.000.002049.102319.99
Sanz, Kellie,167084406.743578.270.000.00828.47
Ma, Brittney,125842633.390.002071.420.00561.97
Xu, Colleen,2895614.980.000.000.0014.98
Subram, Meredith, S,142615653.920.000.002049.103604.82
Coleman, Ethan, G,166936060.503578.270.002482.230.00
He, Susan, A,244673337.040.000.002181.561155.48
Suarez, Melody, H,142765259.360.000.002049.103210.26
Lal, Gabriel,274731398.460.000.00782.99615.47
Nara, Tony, L,167136090.593578.270.002512.320.00
Alonso, Diana, L,245903911.530.000.002181.561729.97
Nath, Michele, L,110568207.503374.990.002413.452419.06
Lin, Kelli, A,2139229.990.000.000.0029.99
Ma, Cedric, W,11094157.930.000.000.00157.93
Suri, Barry,1525378.960.000.000.0078.96
Rai, Karl, M,252731898.07699.100.000.001198.97
Xu, Colin,157902668.380.000.002668.380.00

Generated 2025-11-03 15:32:11.290 UTC