[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_SUM2023202420252026
Rana, Henry,273421348.460.000.001348.460.00
Yuan, Keith, N,229263936.540.002181.560.001754.98
Mehta, Chelsea,229514242.310.002443.351798.960.00
Diaz, Briana,131316737.150.002049.100.004688.05
Sanz, Jamie,265491361.450.00782.990.00578.46
Wu, Clarence, L,131156779.420.002049.100.004730.32
Foster, Lucas,135194492.450.002049.102443.350.00
Long, Isabelle, W,231043490.030.002181.561308.470.00
Raman, Brett, L,229304900.680.002443.350.002457.33
Baker, Jose, A,229374179.330.002443.350.001735.98
West, Colleen, C,131286817.140.002049.100.004768.04
Garcia, Martin, l,233324144.340.002443.351700.990.00
Arun, Brenda,136306824.730.002071.420.004753.31
Perez, Ivan, S,234084218.820.002443.351775.470.00
Lin, Damien, L,234143391.030.002181.561209.470.00
Zhang, Glenn, A,139675721.910.002049.100.003672.81
Hughes, Lucas, E,266571357.970.00782.99574.980.00
Allen, Kaylee,266531938.470.000.00782.991155.48
Anand, Tamara,29088756.330.000.000.00756.33
Munoz, Theresa, M,139536840.750.000.002071.424769.33
Rodriguez, Jarrod,136366831.760.000.002071.424760.34
Dominguez, Kristi, M,136446864.460.000.002071.424793.04
Sai, Emmanuel,234173337.040.000.003337.040.00
Suarez, Rebekah,136496812.130.000.002049.104763.03
Hall, Amanda,266561345.950.000.001345.950.00
Li, Wesley,233223042.820.000.002443.35599.47
Munoz, Cheryl, C,136326838.460.000.002071.424767.04
Yuan, Terry, R,136466843.600.000.002049.104794.50
Nara, Gregory,266511957.470.000.00782.991174.48
Zhao, Bianca,139716772.130.000.002049.104723.03
Ramos, Juan,136336803.140.000.002049.104754.04
Cooper, Victoria, S,136376777.130.000.002049.104728.03
Zeng, Ernest, M,12992158.510.000.0036.27122.24
Moreno, Dwayne, T,2310385.480.000.0085.480.00
Raje, Raul, L,2678574.980.000.0074.980.00
Guo, Leah, R,195625314.250.003578.271735.980.00
Alvarez, Stacy,119018248.010.003399.992374.982473.04
Romero, Walter, A,250201549.420.000.001000.44548.98
Xu, Karl,233213060.820.000.002443.35617.47
Fernandez, Cassandra, C,141343835.070.000.003835.070.00
Xu, Cara,235263563.840.000.003563.840.00
Zhu, Omar,250332120.930.000.001000.441120.49
Serrano, Rebekah,141303814.060.000.003814.060.00
Martin, Anne, V,250342164.910.000.002164.910.00
Ray, Bobby,235753302.050.000.003302.050.00
Martinez, Brett,235323337.040.000.003337.040.00
Adams, Amber,267462001.450.000.00782.991218.46
Ramos, Tanya, R,140456804.130.000.002049.104755.03
Zhang, Lacey, L,141273809.570.000.003809.570.00
Nath, Rafael,235333917.540.000.002181.561735.98
Chande, Derek,267431371.950.000.001371.950.00
Munoz, Craig, V,130766862.140.002049.102428.972384.07
Raji, Grant, R,1618528.980.000.0028.980.00
Morgan, Nathaniel, E,1662671.570.000.0071.570.00
Gutierrez, Diana,1967667.970.000.0067.970.00
Rana, Whitney, A,130066762.150.002049.102319.992393.06
Adams, Sydney,2736769.990.000.000.0069.99
Xu, Calvin, E,27583553.970.000.000.00553.97
Yang, Connor,177354752.753578.270.000.001174.48
Yuan, Rafael, J,206256029.570.003578.270.002451.30
Jimenez, Jaime, E,29095777.340.000.000.00777.34
Suri, Jarrod, E,120048114.040.003374.992319.992419.06
Sun, Lacey, L,1513181.260.000.000.0081.26
Rubio, Mallory, S,1109888.960.000.0029.9858.98
Munoz, Robyn,142145759.870.000.003464.882294.99
Yang, Stacey,142155665.890.000.003298.942366.95
Ruiz, Naomi,236493945.530.000.002181.561763.97
Cai, Candice,267471938.470.000.00782.991155.48
Mr., Sands, Patrick,140635676.250.000.003321.262354.99
Huang, Lisa, L,141023667.230.000.002910.90756.33
Torres, Melinda, J,140336809.960.000.002071.424738.54
Alonso, Ricky, S,140705618.930.000.003298.942319.99
Kumar, Karl, J,142185651.880.000.003332.922318.96
Munoz, Darren,235394144.340.000.002443.351700.99
Lopez, Bruce,235403626.820.000.003626.820.00
Romero, Jessie,250302180.410.000.001000.441179.97
Rubio, Derrick, P,235253302.050.000.003302.050.00
Pal, Donna, S,235723617.830.000.003617.830.00
Evans, Carlos, J,235384198.330.000.002443.351754.98
Lopez, Rachael,234253951.520.000.003951.520.00
Lal, Franklin, A,141013679.900.000.002888.58791.32
Beck, April,143025140.730.000.002071.423069.31
Ye, Jenny,250362120.930.000.002120.930.00
Romero, Gina,142345687.720.000.002071.423616.30
Anand, Alison, J,240092746.040.000.002181.56564.48
Huang, Colleen, S,213792992.330.002443.35548.980.00
Chow, Christy, M,126816784.130.002049.102341.972393.06
Pal, Alison,1304284.470.000.0024.9959.48
Chen, Alisha, J,142255603.920.000.002049.103554.82
Ms., Salavaria, Sharon,119648173.530.003399.992329.992443.55
Li, Ramon,2124834.980.000.000.0034.98
Chapman, Pamela, L,2714535.000.000.000.0035.00
Gonzalez, Tabitha, A,2613639.980.000.000.0039.98
Kumar, Shawna, L,1908578.260.000.0075.972.29
Ortega, Lawrence,14685146.740.000.000.00146.74
Lal, Cristina, M,146712934.370.000.002071.42862.95
Shan, Tony, M,1617531.270.000.000.0031.27
Alvarez, Erik, M,14311138.450.000.0074.4863.97
Ramirez, Mason, K,251072143.900.000.002143.900.00
Murphy, Grace, J,236554144.340.000.002443.351700.99
Ramos, Byron,143063653.230.000.002910.88742.35
Perez, Joe, A,143265207.700.000.002071.423136.28
Scott, Alex, T,143482989.380.000.002071.42917.96
Coleman, Luis, L,142305661.900.000.002049.103612.80
Deng, Peter, A,240062721.550.000.002181.56539.99
Shen, Cristina,267681371.950.000.001371.950.00
Butler, Katherine, F,267601322.980.000.001322.980.00
Tang, Colin,143235222.020.000.002071.423150.60
Rai, Terrence, R,250372174.920.000.002174.920.00
Raman, Deanna, H,17053123.960.000.0069.9753.99
Zhou, Kelvin,2023160.470.000.0060.470.00
Kapoor, Pedro, H,242297.280.000.007.280.00
Hu, Barbara,19567104.960.000.00104.960.00
Liu, Clarence,197976021.620.003578.272443.350.00
Ramos, Briana, J,143033636.910.000.002894.56742.35
Arun, Ross, C,236583936.540.000.002181.561754.98
Washington, Abigail,236613961.030.000.002181.561779.47
Chande, Bonnie, L,239923167.820.000.002443.35724.47
Zhang, Damien, C,267581322.980.000.001322.980.00
Luo, Christine, J,241592756.540.000.002181.56574.98
Nath, Omar, F,146725237.720.000.002071.423166.30
Yuan, Carl, P,241603046.840.000.002443.35603.49
Rodriguez, Heidi, L,251202155.920.000.002155.920.00
Evans, Jonathan, D,151854393.700.000.002071.422322.28
Shan, Tasha,151924384.080.000.002049.102334.98
Wang, Kelvin, S,151434366.410.000.002071.422294.99
Lu, Crystal, A,151454368.700.000.002071.422297.28
Gill, Gina, F,241772721.550.000.002181.56539.99
Martin, Briana, L,152132818.590.000.002049.10769.49
Moreno, Meghan, J,151524464.570.000.002049.102415.47
Zhu, Lacey,241672983.340.000.002443.35539.99
Wang, Lacey,241732771.520.000.002181.56589.96
Zhou, Trisha, B,126866864.460.002071.422354.982438.06
Xu, Keith, J,2512464.470.000.0064.470.00
Sun, Tamara, L,1997644.040.000.0044.040.00
Gomez, Adrienne,119208156.320.003374.992362.272419.06
Pal, Tasha,2285339.990.000.0039.990.00
Morgan, Jared, A,2821339.980.000.000.0039.98
He, Jessie,29094796.340.000.000.00796.34
Chander, Kelvin, E,278791313.340.000.000.001313.34
Pal, Nichole, J,2674169.990.000.000.0069.99
Nara, Karl,15142138.460.000.000.00138.46
Fernandez, Kristi,1958528.990.000.000.0028.99
Zeng, Stacey, J,17317128.950.000.000.00128.95
Schmidt, Monica,1201273.960.000.008.9964.97
Gonzalez, Deanna, S,152044444.070.000.002049.102394.97
Ma, Roger, V,151305215.400.000.002049.103166.30
Suri, Jillian, L,151804466.390.000.002071.422394.97
Raji, Michele,151834368.700.000.002071.422297.28
Raje, Grant, S,241623004.830.000.002443.35561.48
Zeng, Erica,269241350.750.000.00782.99567.76
Yang, Wesley, K,151275182.730.000.002071.423111.31
Alonso, Renee,241662789.520.000.002181.56607.96
Luo, Lacey,241752743.040.000.002181.56561.48
Gomez, Teresa, D,241642760.020.000.002181.56578.46
Gao, Randy,251132180.410.000.001000.441179.97
Kumar, Derek, M,151354381.390.000.002071.422309.97
Jimenez, Marie, C,241763042.820.000.002443.35599.47
Alvarez, Tabitha,150283826.400.000.003826.400.00
Srini, Deanna,151824391.410.000.002071.422319.99
Blanco, Robyn, R,241793052.310.000.002443.35608.96
He, Ramon,269191350.750.000.00782.99567.76
Andersen, Brendan,151215202.730.000.002071.423131.31
Madan, Joe,293002419.060.000.002419.060.00
Ramirez, Olivia, D,197856076.610.003578.272498.340.00
Hayes, Alexis,13048190.230.000.00111.2578.98
Wang, Erica, J,221682997.320.002443.35553.970.00
Srini, Manuel,241682790.520.000.002181.56608.96
Sara, Clifford, M,241782810.530.000.002181.56628.97
Shan, Colleen, D,151504379.080.000.002049.102329.98
Kumar, Tamara, A,252222120.930.000.001000.441120.49
Raji, Omar,156433807.400.000.002071.421735.98
Gao, Cara, B,156423772.410.000.002071.421700.99
Suri, Patricia, E,154363772.410.000.002071.421700.99
Evans, Mason,154393804.080.000.002049.101754.98
Prasad, Ebony,243683946.520.000.002181.561764.96
Martin, Ebony, F,152234366.410.000.002071.422294.99
Chen, Clayton, A,152194399.080.000.002049.102349.98
Raman, Geoffrey, P,154353801.390.000.002071.421729.97
Malhotra, Harold,152274469.560.000.002049.102420.46
Rodriguez, Arthur,154383788.680.000.002071.421717.26
Bell, Stephanie, A,273701322.980.000.001322.980.00
Sai, Evelyn,2041513.980.000.000.0013.98
Goel, Dawn,235354.990.000.000.004.99
Navarro, Byron,1662236.590.000.000.0036.59
Perez, Dominique,1234468.700.000.0044.2124.49
Wang, Rosa, I,119938131.320.003374.990.004756.33
Martinez, Ann,120098195.500.003399.992376.452419.06
Vazquez, Marc, H,243623600.770.000.003600.770.00
Sai, Tina, L,154253772.410.000.002071.421700.99
Ward, Jessica,155874423.380.000.002071.422351.96
Raji, Terry,155974391.410.000.002071.422319.99
Serrano, Danny,243813970.520.000.002181.561788.96
Sai, Ruth, D,244613302.050.000.003302.050.00
Carson, Kristin, C,244593961.030.000.002181.561779.47
Garcia, Roy, H,155854367.020.000.002049.102317.92
Suarez, Briana, A,152662935.370.000.002071.42863.95
Suri, Marie,242813302.050.000.003302.050.00
Blanco, Victor,155864469.370.000.002071.422397.95
Cai, Jeffery, A,155822907.560.000.002049.10858.46
Patel, Whitney, F,244684144.340.000.002443.351700.99
Sanchez, Clifford,21188123.960.000.00123.960.00
Lopez, Brandy, S,1819999.940.000.0099.940.00
Sara, Phillip, R,2511639.980.000.0039.980.00
Andersen, Maurice,1520698.960.000.0063.9734.99
Harrison, Colleen, L,202196044.590.003578.272466.320.00
Nath, Michele, L,110568207.503374.990.004832.510.00
Sai, Monica, L,29055765.320.000.00765.320.00
Navarro, Julio, M,258221819.590.00699.100.001120.49
Sara, Jarrod,206266038.560.003578.270.002460.29
Jai, Bonnie,119778212.500.003399.992350.962461.55
Russell, Ashley,120008183.000.003399.992309.972473.04
Sanz, Larry,14067114.960.000.0049.9964.97
Andersen, Deborah,19610118.940.000.0068.9749.97
Moore, Devin, J,16167102.570.000.000.00102.57
Diaz, Jay,1669231.270.000.0024.996.28
Wilson, Sam,259471854.580.00699.100.001155.48
Serrano, Alberto, L,158004399.080.000.002049.102349.98
Sun, Jorge,160253831.890.000.002071.421760.47
Munoz, Natasha, M,246013882.550.000.002181.561700.99
Xu, Crystal, E,157544416.380.000.002071.422344.96
Jiménez, Byron,160263804.080.000.002049.101754.98
He, Omar,158312646.360.000.002646.360.00
Gomez, Kathleen, J,161584369.090.000.002049.102319.99
Vazquez, Anne,160273826.400.000.002071.421754.98
Zheng, Kristen, J,244633917.540.000.002181.561735.98
Moore, Olivia, A,252312189.900.000.001000.441189.46
Zhu, Sandra, V,157324376.400.000.002071.422304.98
Sharma, Lindsay, E,244783337.040.000.002181.561155.48
Zhou, Autumn, L,252292155.920.000.001000.441155.48
Gao, Jon, C,114568224.460.003399.994824.470.00
Mr., Rodgers, Scott, M.,202115333.250.003578.271754.980.00
Lal, Kara,225792730.540.002181.56548.980.00
Mehta, Tina, C,114448136.023374.990.004761.030.00
Lopez, Summer,1203669.550.000.0029.5739.98
Nath, Bethany,16177133.340.000.0038.8894.46
Raman, Cindy,161574391.410.000.002071.422319.99
Ramos, Roy, A,244823882.550.000.002181.561700.99
Gonzalez, Clifford,245053302.050.000.002181.561120.49
Alonso, Naomi,158302680.380.000.002680.380.00
Goldberg, Mindy,161594411.650.000.002071.422340.23
Ashe, Brad,252282120.930.000.001000.441120.49
Zhou, Gilbert,244753945.530.000.002181.561763.97
Davis, Seth, A,163393169.590.000.003169.590.00
Kumar, Bridget,158024444.070.000.002049.102394.97
Martinez, Manuel, J,158322611.410.000.002611.410.00
Lal, Alicia,157344426.410.000.002071.422354.99
Gutierrez, Kari,157564441.390.000.002071.422369.97
Perez, Virginia, A,274941952.450.000.00782.991169.46
Hernandez, Javier, A,161564344.090.000.002049.102294.99

Generated 2026-07-21 13:42:11.607 UTC